DB2 UDBLoad Stage results

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
goffinw
Participant
Posts: 27
Joined: Thu Nov 18, 2004 6:50 am
Location: Belgium

DB2 UDBLoad Stage results

Post by goffinw »

How can I verify the success or failure of a UDBLoad Stage?
After the UDBStage is finished, I would like to perform a check that the load has performed it's task successfully, completely.
One of the ways in which I tried to achieve this, was to look ate the DB2 load generated message file. But no luck, the lines which the db2 load command line utility always writes at the end, mentioning the number of lines read, committed/rejected, ... are not present in the message file, when the DataStage DB2 BulkLoad plugin is used.
Is there a way this info can be obtained from the plugin?

Thanks,
Wim
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

Hi

Have a simple job which reads the count of the target before insert and writes to a file. And run the job after insert and compare the difference with the out link of the job.

Thanks
Regards
Siva

Listening to the Learned

"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Post Reply