After searching the forum we have tried below options,
- Able to connect to DB2 from command line of ETL box
- All values are hardcoded, didn't use parameter or env var for below properties:
1. Use Defualt Database = False
1.2. Database = <database>
2. Use default server = False
2.1. Server = <DB2 instance name for the table, same as $DB2INSTANCE >
3. Client Instance name = <DB2 client instance name >
3.1. User = <User name>
3.2. Password = <Password>
But still not able to resolve the issue. ODBC stage is working, so uid/pwd are correct. Could you please suggest any help ?
Do you get the same error when using an update/insert method instead of load? For LOAD you need additional permissions to the table, I am fairly certain that they are documented in the installation guide.
Can you try using the "load" method to see if the error message is the same? Sometimes you can examine the generated load scripts to see what values DataStage is using.