DSXchange

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 works on partitioned database, is the databse partitioned.Check with your DBA also.

Hi

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.-

Have you executed bind20 as part of setting up DB2 connectivity?

Hello Ray,

the bind20 is only for ODBC connections -or? We are using the DB2 UDB EE Stage. Do you need to run bind20 for native connections?

Thanks vicmania

Hello,

yes the database is partioned. And I have other jobs using other tables where I also write/ read in parallel - whitout any problem ...

vicmania