Extract Staus informatiom for DataStageJob Log for Audit

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Extract Staus informatiom for DataStageJob Log for Audit

Post by satheesh_color »

Hi All,

I have created the log files in Unix for each cycle run.Now, the requirement is used to extract the below information

Sequence_name,Start_Time,End_Time,Elasped_Time(This we can get it easily), but for the below information

SourcetableReadCount(SourceLinkName)
TargetTableWriteCount(UpdateLinkName and InsertLinkName)

i were not able to extract the above information through shellscript as each job has its own linknames(not identical)


Kindly let me know on how to retrieve all the above information and put it into an Audit table.

Satheesh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Change the job designs so that all link names are compliant. At least for the two links in whose counts you have an interest.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply