Data.30 - Size of File
Moderators: chulett, rschirm, roy
Data.30 - Size of File
I have a couple of Data.30 files in various RT_LOGxxx folders that have become quite large. I need to try and reduce these files. I have gone into each job and used the clear LOG option but this has not reduced the file size. In addition I cannot see how to identify the specific job related to this specific log file. Can anyone help me with this please.
Go to the TCL prompt by logging on to the administrator and run
This might not be the best way as it will remove the default purge settings.
Once you are able to take care of all the huge files, you need to set the purge frequency. That is the best way to handle log files.
As per your second query, you can get the job name by running the following sql in TCL again in the administrator.
replace nnn with the job number you see suffixed in RT_LOG.
Code: Select all
CLEAR.FILE RT_LOGnnn
Once you are able to take care of all the huge files, you need to set the purge frequency. That is the best way to handle log files.
As per your second query, you can get the job name by running the following sql in TCL again in the administrator.
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = 'nnn';
Last edited by DSguru2B on Wed Nov 15, 2006 7:18 am, edited 1 time in total.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Ops Sorry, its DS_JOBS and not DS_JOBOBJECTS, i corrected the earlier post
Do you have that particular job log opened in the director, close all clients except the administrator client. and then try clearing it again.
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = 'nnn' ;
Last edited by DSguru2B on Wed Nov 15, 2006 9:19 am, edited 1 time in total.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DS_JOBOBJECTS/DATA.30 is espected to be large, as it contains every object in every job and job sequence design in the project. If can grow towards 2GB before you should become alarmed.
As it approaches that size (say, if it exceeds 1.5GB) then you should schedule some down time for maintenance. You should begin by archiving and deleting any jobs that are no longer required. That may be enough.
If you have a really huge project containing hugely complex job designs, then you may need to RESIZE the DS_JOBOBJECTS hashed file so that it supports 64-bit addressing. Before you attempt this make sure you have at least two good backups of it; this is the second most crucial hashed file in the Respository. Maybe third most crucial.
As it approaches that size (say, if it exceeds 1.5GB) then you should schedule some down time for maintenance. You should begin by archiving and deleting any jobs that are no longer required. That may be enough.
If you have a really huge project containing hugely complex job designs, then you may need to RESIZE the DS_JOBOBJECTS hashed file so that it supports 64-bit addressing. Before you attempt this make sure you have at least two good backups of it; this is the second most crucial hashed file in the Respository. Maybe third most crucial.
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.