New DB2_Connect stage

[tamar]

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

[ray.wurlod]

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.

[tamar]

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

[ray.wurlod]

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.