Extract Staus informatiom for DataStageJob Log for Audit
Posted: Wed Aug 03, 2011 2:57 am
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
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