Error while opening thejob, DS_JOBOBJECTS

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

pmadhavi
Charter Member
Charter Member
Posts: 92
Joined: Fri Jan 27, 2006 2:54 pm

Post by pmadhavi »

We refreshed the DS_JOBOBJECTS file from backup taken the last time.

After that when we ran the command COUNT DS_JOBOBJECTS we got the following output.
59110 records counted.

And the result for UVFIXFILE DS_JOBOBJECTS is as fllows:
Beginning trace of DS_JOBOBJECTS
TRACE of DS_JOBOBJECTS completed

Scanning free buffer chain.
Scan complete.

13026 groups processes.
18402 group buffers processes
59110 records processes.
Number of data bytes = 21018252

---------------------------


We took the back up on 28th march.
After we refreshed the file DS_JOBOBJECTS, we were able to open the jobs which were developed before 28th march.

the jobs which were developed after 28th are still showing the same error(design Information not found)

We have many RT_* jobs created in the server and they are occupying much space.
Can you please let us know why these files got created.
Thanks,
Madhavi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can not safely delete any of these. If they are "taking up too much room" delete jobs that are not longer required.

RT_STATUSnnn is small, and contains the status records for job number nnn.
RT_CONFIGnnn is small, and contains the run-time configuration information for job number nnn.
RT_BPnnn is small, and contains the BASIC source code generated by job control, Transformer stages, and so on, for job number nnn.
RT_BPnnn.O is small, and contains the compiled code from compiling what's in RT_BPnnn.
RT_LOGnnn contains the log for job number nnn. If you have not been purging logs, these can grow large.

Investigate your job logs and look for opportunities to purge old entries. Search the forum for techniques if you feel you want to archive them first.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply