How to find a huge job log
Moderators: chulett, rschirm, roy
How to find a huge job log
Hi,
I need to find a huge log generated by job within 1000 jobs in order to delete it. How can I do that quickly?
Thanks
I need to find a huge log generated by job within 1000 jobs in order to delete it. How can I do that quickly?
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Every job log is a separate table. You can't easily do it with SQL. Create yourself a Routine to do it. Loop through all the job names and find the corresponding job number from DS_JOBS, then count the records in RT_LOGnnn where nnn is the job number. Generate your report as you go.
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.
If you are in Windows then good luck but UNIX:
Code: Select all
#!/bin/ksh
# 500mb
find . -size +500000000c -exec ls -l {} \;
Mamu Kim
In other words, to do this from the operating system you need to examine all of the RT_LOGnnn directories in the Project directory where this happened, looking for the 'Big Ones'. A query against DS_JOBS will translate the job number into a job name.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 23
- Joined: Mon Jul 04, 2005 6:25 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When I did the training for version 1.0 (which was VERY slow), the instructor set us a task for a prize; the winner had to create the job that finished in the least possible time, as measured in Director.
My job finished in half the time of everyone else's. 7 minutes against their 15 and more.
I got disqualified when they found I'd changed the system clock on the server after the job had started.
My job finished in half the time of everyone else's. 7 minutes against their 15 and more.
I got disqualified when they found I'd changed the system clock on the server after the job had started.
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.