DB2 Load append Error

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
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

DB2 Load append Error

Post by synsog »

Hi,
We are using datastage 8.1. Job design is like a
dataset - > Transformer -> DB2/UDB enterprise stage

The write method is kept as Load append. But job is getting aborted with following are the error messages from job log

DSP_DB2,5: {0} [db2load_driver.C:969]
DSP_DB2,5: SQLCODE = -3,025; SQLSTATE= ?????Q? [db2load_driver.C:969]
DSP_DB2,5: SQL3025N A parameter specifying a filename or path is not valid.
[db2load_driver.C:969]

Same job is working fine in another project on same server.

Any pointers to this.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DB2 wrote:A parameter specifying a filename or path is not valid.
Double check that all relevant parameters are supplying correct values. Examine the detail of the job status record in Director (or the "job starting" event in the job log) to ascertain parameter values that were used.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply