I read at the Ascential Datastage 7.5 documentation, it needs some extra plug in to make DB2 API works. I am curious whether this is needed too in Datastage 8.1
Thanks,
Caterin
error in running a job with DB2 UDB Stage
Moderators: chulett, rschirm, roy
I have similar error and still cannot fix this error.
DB2_UDB_Enterprise_0,0: Error Idx = 1;
DB2 Driver Embedded SQL message: SQL1042C An unexpected system error occurred. SQLSTATE=58004;
sqlcode = -1042;
sqlstate = 58004
Failed to connect to the database
Error Idx = 5;
DB2 Driver Embedded SQL message SQL1024N A database connection does not exist. SQLSTATE = 08003
;
SE and EE jobs used to work fine before but when I got this error, SE jobs still can run.
Has anyone successfully solve this issue ?
We have tried to:
1. Uncatalog and Catalog database
2. Drop and recreate DB2 instance
3. Rebind
But still cannot solve.
DataStage 7.5.3
DB2 9.1
DB2_UDB_Enterprise_0,0: Error Idx = 1;
DB2 Driver Embedded SQL message: SQL1042C An unexpected system error occurred. SQLSTATE=58004;
sqlcode = -1042;
sqlstate = 58004
Failed to connect to the database
Error Idx = 5;
DB2 Driver Embedded SQL message SQL1024N A database connection does not exist. SQLSTATE = 08003
;
SE and EE jobs used to work fine before but when I got this error, SE jobs still can run.
Has anyone successfully solve this issue ?
We have tried to:
1. Uncatalog and Catalog database
2. Drop and recreate DB2 instance
3. Rebind
But still cannot solve.
DataStage 7.5.3
DB2 9.1