DB2 EE Stage. Error bind file name is not valid

vicmania · Post by **vicmania** » Tue Sep 12, 2006 11:07 am

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

thumsup9 · Post by **thumsup9** » Tue Sep 12, 2006 11:53 am

DB2 EE works on partitioned database, is the databse partitioned.Check with your DBA also.

meena · Post by **meena** » Tue Sep 12, 2006 12:14 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Sep 12, 2006 4:14 pm

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

vicmania · Post by **vicmania** » Wed Sep 13, 2006 3:54 am

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

vicmania · Post by **vicmania** » Wed Sep 13, 2006 4:22 am

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