Generic Job -- Unable to see the log
Moderators: chulett, rschirm, roy
Generic Job -- Unable to see the log
Hi ,
Version : 8.0.1
OS : AIX
I have a job for which multiple instance is enabled .Its a generic job used to populate 100 tables .So , We have 100 invocation id's .After running couple of times , I am unable to see the datastage log in the designer .When I am clicking the folder containing the generic job , Its getting hanged and not retreiving the log .
I have even tried with dsjob -logdetail command .But unix prompt also not returning anything .
Can someone help me in understanding the following questions ?
1) Is there any limit for a multi instance job ?Because we are calling the same job for 100 times and after that we are unable to see the log ?
2) Behind the scenes , I suppose these logs are stored as a files (RT_LOGnnn ) .Then why is it taking that much time to retrieve information from files .If it is database tables then we can expect the delay .
Thanks a lot everyone in advance .
Version : 8.0.1
OS : AIX
I have a job for which multiple instance is enabled .Its a generic job used to populate 100 tables .So , We have 100 invocation id's .After running couple of times , I am unable to see the datastage log in the designer .When I am clicking the folder containing the generic job , Its getting hanged and not retreiving the log .
I have even tried with dsjob -logdetail command .But unix prompt also not returning anything .
Can someone help me in understanding the following questions ?
1) Is there any limit for a multi instance job ?Because we are calling the same job for 100 times and after that we are unable to see the log ?
2) Behind the scenes , I suppose these logs are stored as a files (RT_LOGnnn ) .Then why is it taking that much time to retrieve information from files .If it is database tables then we can expect the delay .
Thanks a lot everyone in advance .
Nag
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What are the values of RTLogging and ORLogging in the DSParams file in your project? You may need to use the Reporting Console for Information Server, rather than Director, to view the logs.
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.
Yes craig ..whatever andrew has mentioned is correct ...I remember reading that in one of the post ...
Today also i have tried to view the log ..but still giving the same problem ...
Is there any way to purge the log through command prompt ?? I cannot clear log through director as clicking that folder is creating the problem .
Today also i have tried to view the log ..but still giving the same problem ...
Is there any way to purge the log through command prompt ?? I cannot clear log through director as clicking that folder is creating the problem .
Nag
How to find the mapping of a job and its job id ? I believe, RT_LOG_nnn -- nnn is a internal job id . Could you please let me know how to find the value of nnn for a particular job ? I remember we have to query universe tables like ds_jobs or ds_objects .But i dont know the structure and exact query .If someone can help me in getting it , it would be great ..Thanks a lot ..
Nag
Code: Select all
SELECT JOBNO FROM DS_JOBS WHERE NAME = 'xxxxx';
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers