fixing corrupted 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

Post Reply
DaleK
Premium Member
Premium Member
Posts: 68
Joined: Fri Jun 27, 2003 8:33 am
Location: Orlando

fixing corrupted DS_JOBOBJECTS?

Post by DaleK »

Hello All,

We started having trouble accessing jobs in one of our projects recently.
I did an export of the whole project and saw that none of the DSJob sections in the export had any information about the attributes for a given job. Only the following text appeared "COMMENT No records in job."

I went into admin and ran a cleanup on the project and the log displayed this message along with others while trying to perform other index processes (set, create,...) for DS_jobobjects.

Program "DELETE.INDEX": pc = 70C, WARNING: Internal file corruption detected during file open!
File must be repaired, possible truncation.
hsize: 2048
bsize: 2048
fsize: 33358
Unable to open "DS_JOBOBJECTS".

I went into ds.tools and ran "LIST.INDEX DS_JOBOBJECTS ALL" and that returned a similar message.

Is there a way to correct this file?
Do I need to delete and recreate the project and import from a past Export?

Dale
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This is serious. DS_JOBOBJECTS is, as you're finding out, THE critical table for design time information.

You can use UVFIXFILE from the command prompt, or fixtool or uvfixfile from the operating system prompt, to trace the file to report whether there is, indeed any internal corruption.

If there is, either:
  • hire a competent consultant to effect repairs (one who dreams in hexadecimal is the sort of person you're after)

    delete the project, re-create it, then restore from recent backup or from recent export
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DaleK
Premium Member
Premium Member
Posts: 68
Joined: Fri Jun 27, 2003 8:33 am
Location: Orlando

Post by DaleK »

Ray thanks for your response.

I ran UVFIXFILE and got the following of warnings

"Warning "DS_JOBOBJECTS/OVER.30" has been truncated.
Warning: Internal file corruption detected during file open!
file must be repaired, possible truncation
hsize: 2048
bsize: 2048
fsize: 33358
warning: Unable to set GROUP LOCKS on DS_JOBOBJECTS.
....."

With this in mind I'm going to take option # 2 from above.
Do you have any clue as to what type of event would corrupt this file?

Do people still dream in "hexadecimal?" I thought that went out with punch cards.
Have a nice day
Dale
sathishmca
Participant
Posts: 43
Joined: Mon Mar 03, 2008 10:58 pm
Location: Chennai

Post by sathishmca »

DaleK wrote:Ray thanks for your response.

I ran UVFIXFILE and got the following of warnings

"Warning "DS_JOBOBJECTS/OVER.30" has been truncated.
Warning: Internal file corruption detected during file open!
file must be repaired, possible truncation
hsize: 2048
bsize: 2048
fsize: 33358
warning: Unable to set GROUP LOCKS on DS_JOBOBJECTS.
....."

With this in mind I'm going to take option # 2 from above.
Do you have any clue as to what type of event would corrupt this file?
Do people still dream in "hexadecimal?" I thought that went out with punch cards.
Have a nice day
Dale
I am facing the same error .. Please any one help me out from this..
Sathish Bhojan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The exact same error or a similar one involving DS_JOBOBJECTS? Which version are you working on and which part of Ray's advice did you attempt?
sathishmca
Participant
Posts: 43
Joined: Mon Mar 03, 2008 10:58 pm
Location: Chennai

Post by sathishmca »

ArndW wrote:The exact same error or a similar one involving DS_JOBOBJECTS? Which version are you working on and which part of Ray's advice did you attempt? ...

thanks for your response.

yet to start my attempt on this ?

So please advice me..
Sathish Bhojan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ray posted excellent advice, I could just repeat what he recommended as initial steps. If you have any idea how this happened it would be good know as it might change the approach to solving the problem. I would also recommend that unless you have the exact same error messages as the original poster in this thread that you continue in your other and leave this one without thread drift.
Post Reply