error connecting to DB2 database

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
shridhar.gj
Participant
Posts: 4
Joined: Wed Sep 19, 2007 6:46 am
Location: New Delhi

error connecting to DB2 database

Post by shridhar.gj »

hi all,
i am new to DataStage, i am trying a simple job to extract data from flat file (using sequential file stage) and load (copy stage) the data into DB2 database (DB2 UDB API stage). The job gets compiled properly however it is gets aborted during execution showing the following error in the log:

APT_CombinedOperatorController,0: Failure during execution of operator logic.
APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server 'localhost'.

i am able to connect to DB2 database thru system dsn

any suggestion is welcome.

regds
shridhar
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Disable operator combination so you can see whence the error is being generated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
shridhar.gj
Participant
Posts: 4
Joined: Wed Sep 19, 2007 6:46 am
Location: New Delhi

Post by shridhar.gj »

hi ray,
i am able to execute the job now... thx a lot

shridhar
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”