OS/390 ODBC connection setup problems
Moderators: chulett, rschirm, roy
OS/390 ODBC connection setup problems
Hi,
I am trying to set up ODBC connection to a DB2 database on a OS/390 system.
When i tried to do 'bind20 DB2DSN', I am getting the error:
Package creation failed!: 1242.
1242 in LC_Messages is expanding to: "Remote Database Not Found"
Does anyone know how to address this problem?
Here is the .odbc.ini entry i created for this connection:
---------------------------------------------
[DB2DSN]
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xx.x
IsolationLevel=CURSOR_STABILITY
Location=OS/390
LogonID=
Password=
Package=DSPKG
PackageOwner=REVDDR
TcpPort=xxx
WithHold=1
--------------------------------------------
Appreciate any pointers toward solving this problem.
TIA,
Yakiku
I am trying to set up ODBC connection to a DB2 database on a OS/390 system.
When i tried to do 'bind20 DB2DSN', I am getting the error:
Package creation failed!: 1242.
1242 in LC_Messages is expanding to: "Remote Database Not Found"
Does anyone know how to address this problem?
Here is the .odbc.ini entry i created for this connection:
---------------------------------------------
[DB2DSN]
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xx.x
IsolationLevel=CURSOR_STABILITY
Location=OS/390
LogonID=
Password=
Package=DSPKG
PackageOwner=REVDDR
TcpPort=xxx
WithHold=1
--------------------------------------------
Appreciate any pointers toward solving this problem.
TIA,
Yakiku
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is a "/" permitted in the Location field? (I don't know the answer to this, but the rest of the definition (except, maybe, Collection and for the same reason) looks OK. Does what's in the ODBC data source definition match what's possible in your DB2 client configuration?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Got the connection to work and here is the update. "/" was one of the problems.
[DB2MC]
QEWSD=38879
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=DSDEW
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xxx.xxx
IsolationLevel=CURSOR_STABILITY
Database=DBDB2
Location=DB2MC
LogonID=
Password=
Package=DSDB2
PackageOwner=lmnr
TcpPort=446
WithHold=1
[DB2MC]
QEWSD=38879
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=DSDEW
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xxx.xxx
IsolationLevel=CURSOR_STABILITY
Database=DBDB2
Location=DB2MC
LogonID=
Password=
Package=DSDB2
PackageOwner=lmnr
TcpPort=446
WithHold=1
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can see that Collection, Location, Package, Package Owner and TCP Port have changed. Can you shed any light on why the new values are good and the old values are bad?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Collection and Location: "/" is not a valid character. Worked with the DB2 DBA and gave the names as per suggestion.
Package and Package owner: These changes were for permissions. The owner mentioned in the first post did not have the permissions to create a package.. hence the change.
TCP Port: This has not changed.. i unmasked it in my last post. thats all.
Thanks to everyone who responded. Appreciate your help.
Package and Package owner: These changes were for permissions. The owner mentioned in the first post did not have the permissions to create a package.. hence the change.
TCP Port: This has not changed.. i unmasked it in my last post. thats all.
Thanks to everyone who responded. Appreciate your help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As far as I can recall it's something to do with the licensing of the Data Direct ODBC driver - a way for DataStage to identify itself to the driver licensing mechanism. (But I'm not 100% certain on this and would be happy to be corrected.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.