DSXchange

I recently installed the patch "Connectors Rollup Patch 1." that include the DB2 Connector.
I built very simple job that read from table using the stage DB2_Connector and write it to sequential file.

When I configured the stage and used the "View Data" I was able to see the content of the DB2 table, but during runtime I get the following error:

main_program: Fatal Error: An error occurred while getting the DB2 instance. Verify that a valid DB2 instance is specified in the Instance property. The method sqlegins returned reason code 0, SQLCODE -1,390.

does any one know to which DB2 instance it relate in each case (view data and runtime) and how can I solved the runtime problem ?

(the same job with DB2/UDB stage is working good)

Thanks
Tamar

Is the DB2INSTANCE environment variable correctly set for the process under which user ID the job runs? Check in the "environment variables" entry in the job log.

The DB2INSTANCE env variable is the same as in the stage "Instance" Property and the still connection "test" and the "view data" is working whereas are at runtime it fails

What user ID is involved at run time (tip: include an id command executed through the before-job subroutine ExecSH to find out)? Check the job log for the settings of the DB2-specific environment variable values at run time.