I suspect it's using a ODBC connection to establish queries that confirm the SQL quote and delimiter characters, verify table and column names, and so on.
Try creating an ODBC data source name (DSN) with the same name as your DB2 instance (as it's known to your DataStage job).
problem with db2 stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I have defined an ODBC DSN and now I get the following errors:
loaddb2..DB2_UDB_Load_4: ERROR occurred : loading table, SQLCODE -1024
loaddb2..DB2_UDB_Load_4: SQL1024C Połączenie z bazą danych nie istnieje. SQLSTATE=08003
(translation: A connection to database doesn't exist)
loaddb2..DB2_UDB_Load_4: Error occurred while loading table
loaddb2..DB2_UDB_Load_4: Internal Error: Function 'load_data' failed
Attempting to Cleanup after ABORT raised in stage loaddb2..DB2_UDB_Load_4
When I used an ODBC or DB2/UDB API stage it works fine. It gets aborted when I am using DB2/UDB Load stage.
Any ideas what I need to make this working?
Regards,
Piotrek
loaddb2..DB2_UDB_Load_4: ERROR occurred : loading table, SQLCODE -1024
loaddb2..DB2_UDB_Load_4: SQL1024C Połączenie z bazą danych nie istnieje. SQLSTATE=08003
(translation: A connection to database doesn't exist)
loaddb2..DB2_UDB_Load_4: Error occurred while loading table
loaddb2..DB2_UDB_Load_4: Internal Error: Function 'load_data' failed
Attempting to Cleanup after ABORT raised in stage loaddb2..DB2_UDB_Load_4
When I used an ODBC or DB2/UDB API stage it works fine. It gets aborted when I am using DB2/UDB Load stage.
Any ideas what I need to make this working?
Regards,
Piotrek
I mean to exploit the DB2 UDB and Bulkloader, since they do not use the DB2 Client, that you would need to install DataStage on each of the DB2 nodes in order to make this work....
If you don't have the DataStage licenses to accomodate this then your forced to use the DB2 Client or DB2 API and operate serially...
If you don't have the DataStage licenses to accomodate this then your forced to use the DB2 Client or DB2 API and operate serially...
I have got working properly DB2 UDB API stage. And I have a DB2 client installed on my ds server machine. And I want DB2 Buld load stage to use DB2 client software to connect to a remote db2 server machine. But it is not working. I suppose that db2 client is installed properly, cause I have tested a db2 udb api stage to work fine.
PS. Are you Polish?
PS. Are you Polish?