adding new database to config and ini files...getting error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
DStageNewbie
Participant
Posts: 11
Joined: Wed Aug 12, 2009 6:05 am
Location: Kansas City

adding new database to config and ini files...getting error

Post by DStageNewbie »

We are adding a new db2 database, modeling our file entries after an existing database with minor changes. DBX0 is the new db id. After making changes in these two files, we try doing a BIND using the stmt bind22 dbx0 and received the msg "Package creation failed!: Remote Database Not Found: DBX0". Am I missing a step or do we have an error in our config file?

Our config and ini entries are shown below
congig -
[DBX0]
QEWSD=38944
Driver=/dst/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMdb222.so
AddStringToCreateTable=
AlternateID=
Collection=DSDEW
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=dev0.dstcorp.net
IsolationLevel=CURSOR_STABILITY
Location=DBX0
LogonID=
Password=
Package=DSDB2
PackageOwner=MFDTEMPR
TcpPort=446
WithHold=1


ini -
<DBX0>
DBMSTYPE = ODBC
Bob
tatikramos
Participant
Posts: 36
Joined: Tue Sep 16, 2008 12:15 pm

Post by tatikramos »

1. make sure you catalog the db2 db in the remote server and that you are able to connect to that datbase.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Also make sure that you have used the appropriate bind utility (probably bind22) on the DB2 client (that is, the DataStage server).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply