I use to think that dsjob command pull all the information from RT_LOGn files but it certainly don't pull everything from their.
I did a small test,deleted RT_Logn from universe and ran dsjob -linkinfo for a job and it still returns the row count for all links so certainly dsjob pulls these information from other source and i would apriciate if someonce can tell me about this mystery.
Thanks in advance !!
log
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The easiest way is to use the DataStage API. There is a DataStage BASIC version and a C version of this API.
I'm wondering how you queried the RT_STATUSnnn table when no column names/definitions exist for these tables.
I'm wondering how you queried the RT_STATUSnnn table when no column names/definitions exist for these 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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray,you said right,when i query RT_Status it returns me zero rows and it is not giving me any information.
Craig,using dsjob gives my stats only for last run and I need to get stats or atleast last three or four run.
Is there any way to get this information from command line and not by using datastage job ?
Craig,using dsjob gives my stats only for last run and I need to get stats or atleast last three or four run.
Is there any way to get this information from command line and not by using datastage job ?