Page 1 of 1

DB2 Load append Error

Posted: Fri Dec 10, 2010 6:54 am
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.

Posted: Fri Dec 10, 2010 3:18 pm
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.