Sparse Look Up on DB2 UDB on Mainframes in PX

vijayk.kumar@target.com · Tue Sep 29, 2009 10:55 pm

Hi All,

We are facing some issues when doing sparse lookups on DB2 DB on Mainframes.

The DB user is unable to Bind the DB.

Can any one please help on this.

Regards
VJ

ArndW · Post by **ArndW** » Wed Sep 30, 2009 2:43 am

Does that mean that the lookup works when it is not defined as sparse?

vijayk.kumar@target.com · Wed Sep 30, 2009 2:54 am

Hi,

Yes Normal Look Up, Joiner works fine.Sparse look up is creating a problem.

Regards
VJ

vijayk.kumar@target.com · Wed Sep 30, 2009 3:09 am

DB2 Driver Embedded SQL message: SQL0551N "JDBCFFFT" does not have the privilege to perform operation "CREATE
IN" on object "DB2T.DSADM.DB2ESQL". SQLSTATE=42501
sqlcode = -551;
sqlstate = 42501
Program not bound to database

Attempting to bind to the database /apps/Ascential/DataStage/PXEngine/bin/db2esql.bnd ....failed

The file `/opt/udb/psaedi04/sqllib/sqllib/db2nodes.cfg' must exist and be readable by all users!

This is the error which we got

stefanfrost1 · Post by **stefanfrost1** » Wed Sep 30, 2009 4:15 am

Sounds strange to me! As far as I know you can't use sparse lookup using DB2 API stage and you can't use DB2 Enterprise stage to connect to Mainframe DB2 (at least not from Unix)....