Hello,
I have some jobs that are writing data to db2 with an DB2 EE Stage. As long as I use the execution mode parallel I receive the following error:
main_program: DB2 Get Table Partitioning Information.
main_program: SQLCODE = 2; SQLSTATE=
main_program: SQL0002N The bind file name is not valid.
main_program: Fatal Error: DB2 Get Table Partitioning Information error;
table name: `VKBP4.DW_SONST_VTG_P_BEZ ', return code `0'; sqlcode `2', pmaplen = 0.
As i assume this means it can not read the partioning information for that table. The moment I switch to sequential execution mode the job runs fine. I have no clue how to solve the problem.
Any ideas?
Thanks vicmania
DB2 EE Stage. Error bind file name is not valid
Moderators: chulett, rschirm, roy
Hi
I think the table is not having any table partitions.You need to check with your database admin.
I think the table is not having any table partitions.You need to check with your database admin.
main_program: DB2 Get Table Partitioning Information.
main_program: SQLCODE = 2; SQLSTATE=
main_program: SQL0002N The bind file name is not valid.
main_program: Fatal Error: DB2 Get Table Partitioning Information error;
table name: `VKBP4.DW_SONST_VTG_P_BEZ ', return code `0'; sqlcode `2', pmaplen = 0.-
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: