Page 1 of 1
Sparse Look Up on DB2 UDB on Mainframes in PX
Posted: Tue Sep 29, 2009 10:55 pm
by vijayk.kumar@target.com
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
Posted: Wed Sep 30, 2009 2:43 am
by ArndW
Does that mean that the lookup works when it is not defined as sparse?
Posted: Wed Sep 30, 2009 2:54 am
by vijayk.kumar@target.com
Hi,
Yes Normal Look Up, Joiner works fine.Sparse look up is creating a problem.
Regards
VJ
Posted: Wed Sep 30, 2009 3:09 am
by vijayk.kumar@target.com
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
Posted: Wed Sep 30, 2009 4:15 am
by stefanfrost1
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)....