error while using DB2 EE stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gsym
Charter Member
Charter Member
Posts: 118
Joined: Thu Feb 02, 2006 3:05 pm

error while using DB2 EE stage

Post by gsym »

i got an error while running job, which has DB2 EE stage as the target

following are the errors got from log

step: Can not find db2node.cfg file. Please set APT_DB2INSTANCE_HOME
main_program: Could not check all operators because of previous error(s)
main_program: Creation of a step finished with status = FAILED.


Thank you . .
Vidyut
Participant
Posts: 24
Joined: Wed Oct 13, 2010 12:45 am

Re: error while using DB2 EE stage

Post by Vidyut »

In Datastage Administrator go to properties of the project, now here in environment variables set APT_DB2INSTANCE_HOME = (path of your database installation for example /home/ibm/sqllib)
Post Reply