bind20 fails to create package during DB2 ODBC set up

[htang619]

I am trying to set up ODBC DB2 connection by adding the following to odbc.ini file:

[xxerdb]
Driver=/appl/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Database=bherdb
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xx.xx.xx
IsolationLevel=CURSOR_STABILITY
LogonID=
Password=
Package=pgerdw
PackageOwner=
TcpPort=51544
WithHold=1

The DB2 is on AIX box. After that, I ran: bind20 xxerdb, and I got this msg: Package creation failed!: 1402. Can you tell what does this mean?

[bcarlson]

Not sure about the ODBC error, but I do have a question. Are you running DataStage on AIX as well? Why do you need ODBC for DataStage to access DB2? You may want to consider using the DB2 Enterprise Stage. It would provide a better connection, better performance, better support, etc.

Brad.

[htang619]

Brad, I need the ODBC connection for some of my custom routines where I use SQLConnect function and that connection has to be ODBC. Thanks.

[Sreenivasulu]

HI,

Just a suggestion
Using the DB2 enterprise stage would be much faster.

Regards
Sreeni

I am trying to set up ODBC DB2 connection by adding the following to odbc.ini file:

[xxerdb]
Driver=/appl/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Database=bherdb
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xx.xx.xx
IsolationLevel=CURSOR_STABILITY
LogonID=
Password=
Package=pgerdw
PackageOwner=
TcpPort=51544
WithHold=1

The DB2 is on AIX box. After that, I ran: bind20 xxerdb, and I got this msg: Package creation failed!: 1402. Can you tell what does this mean?