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.
DB2 Load append Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.DB2 wrote:A parameter specifying a filename or path is not valid.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.