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
cosec
Premium Member
Posts: 230 Joined: Tue May 08, 2007 8:10 pm
Post
by cosec » Wed Aug 15, 2007 8:00 pm
The Job Log we currently have is very limitted and only indicates if the job is successful or not.
Is there any sample code to add to the script to give the following details
A)
i) Job Status
ii) Number of Rows Written
iii) Number of Rows Looked up
B)
how do I get the director log for a particular run to be output into the batch log ?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 15, 2007 8:07 pm
A)
ETLStats. Say 'Thank you Mr Kim.'
B) See A.
-craig
"You can never have too many knives" -- Logan Nine Fingers
cosec
Premium Member
Posts: 230 Joined: Tue May 08, 2007 8:10 pm
Post
by cosec » Wed Aug 15, 2007 8:19 pm
Thanks but how do I accomplish the above using a shell script....
it seems that is much simpler....
chulett wrote: A)
ETLStats. Say 'Thank you Mr Kim.'
B) See A.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Aug 15, 2007 8:29 pm
What? Reinventing the wheel is easier than using an already-invented wheel? Please reconsider.
It's definitely NOT "much easier using a shell script, since the job logs are database tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
cosec
Premium Member
Posts: 230 Joined: Tue May 08, 2007 8:10 pm
Post
by cosec » Thu Aug 16, 2007 1:59 am
I already have a shell script to give me the jobs status but I am trying to add the number of records extracted and written.....I am not sure which variable/parameter to use. How do I find that out ?
I was able to get what I needed using Kim's Doc but I also want to try the above. Thanks
kduke
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Thu Aug 16, 2007 6:16 am
The job that can extract row counts from old log records is written in BASIC. You might be able to use dsjob -logsum or -logdetail to get what you want. If you want the last run only then dsjob -report will give you that.
Mamu Kim
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Aug 16, 2007 4:07 pm
Maybe you could also use dsjob -linkinfo, with a lot of preliminary mucking about to determine the stage name and link name.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.