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?
bind20 fails to create package during DB2 ODBC set up
Moderators: chulett, rschirm, roy
DB2 ODBC set up
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.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Re: bind20 fails to create package during DB2 ODBC set up
HI,
Just a suggestion
Using the DB2 enterprise stage would be much faster.
Regards
Sreeni
Just a suggestion
Using the DB2 enterprise stage would be much faster.
Regards
Sreeni
htang619 wrote: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?