I am using a PX DB2 API stage to connect the DB2 database, I could able to see the data in view data option but I got the below error while running.
Src_DB2API_MS_REFERENCE_DATA_MR2_M055_B_A,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL1013N The database alias name or database name "S3MSDB01" could not be found. SQLSTATE=42705
DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'S3MSDB01'.
Any help on this please.
Unable to connect the database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Thu Dec 28, 2006 1:39 am
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
I'm facing this issue as well, do we need have an entry in datastage server to connect to the DB2 database. [ Something similar to a TNS entry for Oracle?]kris007 wrote:Are you connecting to the database on a remote server? If so, you need to invoke the DB2 instance using the environment available.
Arun
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: