IBM Support

InfoSphere DataStage job using DB2 Enterprise Stage fails with SQL -1390

Troubleshooting


Problem

InfoSphere DataStage job using DB2 Enterprise Stage fails with SQL -1390

Symptom

Error message in DataStage log
Item #: 11
Event ID: 10
Timestamp: 2014-06-19 17:50:33
Type: Warning
User Name: isadmin
Message Id: IIS-DSEE-TNDB-00225
Message: main_program: The environment variable DB2INSTANCE is
currently set to `db2inst1' and is being changed to `<dbname>' as specified in the server option;
if this instance is a different version of DB2, the program may not succeed

Item #: 13
Event ID: 12
Timestamp: 2014-06-19 17:50:33
Type: Fatal
User Name: isadmin
Message Id: IIS-DSEE-TNDB-00534
Message: ENT_SELECT_AGENCY_PK,0: Error Idx = 1; DB2Driver Embedded SQL message: ;
sqlcode = -1390;
sqlstate = .

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.1;8.7","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21679506

Page Feedback