db2 Loading Problem

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
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

db2 Loading Problem

Post by thumati.praveen »

Hi all,

While i am trying to load the db2 using the db2/udp stage i got these errors ,at the time i set write method is load and deflault server and database is set to false.


errors:

dbW_IIPNT0_Tgt,0: DB2 Load Binary Error.
main_program: Invalid character conversion found converting to ASCL_MS1252, substituting.
dbW_IIPNT0_Tgt,0: SQLCODE = -3508; SQLSTATE= ?V??0.
dbW_IIPNT0_Tgt,0: SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load or load query. Reason code: "1". Path: "/data/Scratch/APT_DB2_LOADMSG_db2inst10_REMOTE/DB20000C.PI".
dbW_IIPNT0_Tgt,0: Failed opening fifo /data/Scratch/ordb2228821eacca78_.000 after 90 seconds: No such device or address.
dbW_IIPNT0_Tgt,0: The runLocally() of the operator failed.
dbW_IIPNT0_Tgt,0: Operator terminated abnormally: runLocally did not return APT_StatusOk.

please give me input

thanksinadvance
Praveen
Post Reply