DB2 Version 8.2 Comapatibility with Datastage version 7.1r2
Posted: Wed Apr 11, 2007 3:33 pm
Hi
Recently in Development environment we Upgraded the DB2 version from 8.1 to DB2 UDB v8.2.6 (Fixpak 13). The Datastage is on 7.1r2 . The ETL jobs which use the API stage are functioning properly but the Jobs which use the DB2 EE stage are failing with fatal errors such as:
Error Idx = 1;
DB2 Driver Embedded SQL: -5005;
sqlcode = ;
sqlstate = SQL5005C System Error.
Error Idx = 5;
DB2 Driver Embedded SQL: -10004;
sqlcode = 58031;
sqlstate = SQL10004C An I/O error occurred while accessing the database directory.
SQLSTATE=58031
Wondering if this is related to Version Compatibility between DataStage and DB2. Did anyone have experience similar situation. Any help in this matter would be appreciated.
Thanks.
Kiran.
Recently in Development environment we Upgraded the DB2 version from 8.1 to DB2 UDB v8.2.6 (Fixpak 13). The Datastage is on 7.1r2 . The ETL jobs which use the API stage are functioning properly but the Jobs which use the DB2 EE stage are failing with fatal errors such as:
Error Idx = 1;
DB2 Driver Embedded SQL: -5005;
sqlcode = ;
sqlstate = SQL5005C System Error.
Error Idx = 5;
DB2 Driver Embedded SQL: -10004;
sqlcode = 58031;
sqlstate = SQL10004C An I/O error occurred while accessing the database directory.
SQLSTATE=58031
Wondering if this is related to Version Compatibility between DataStage and DB2. Did anyone have experience similar situation. Any help in this matter would be appreciated.
Thanks.
Kiran.