Bulk load in db2

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
harikhk
Participant
Posts: 64
Joined: Tue Jun 04, 2013 11:36 am

Bulk load in db2

Post by harikhk »

Hi,

In my sequence there are two bulk load jobs(Job A and Job B) running in parallel.
Both the jobs are Truncate and Bulk Load

Loading to a DB2 table hosted on AIX

However the load job A failed due to table name issue. So corrected the issue and restarted the sequence.The corrected job A ran fine but job B whose load got interrupted is issuing an error
"SQL0668N Operation not allowed for reason code "3" on table".

So made below modifications to Job B
1.Changed Table Action from Truncate to Append
2. With point 1 enabled Load Control options
Changed load mode to RESTART and Restart Phase as Load (Default)

With the above changes on re-running the sequence the job was successful and sequence completed .

But when running new instance of the sequence, Job B failed
with below error.
"LOAD RESTART/TERMINATE was not performed on the targeted partitions because they were not in LOAD PENDING state"
Understood cannot run as there is nothing in load pending state.
So rolled back the changed settings and then job is success.

Please advice how to handle this as I would not have access to make the modification for each run in production in case the above kind of error occurs
Thanks,
HK
*Go GREEN..Save Earth*
Post Reply