DSXchange

Hi!

One of our job got corrupted and now I have this message saying "Job has no design information"

Is there a way to fix it?

Thanks

Christian

Without knowing whats actually locked, you ought to be very careful. Generally the locks are there for a reason. Also, are the locks in DataStage (you can see these from the Cleanup Resources screen or from the DS.TOOLS menu on the server), or in one of the databases DataStage is accessing? Raymond ...

This is really true and I just made the same experience when using the CFF stage with multiple outputs to different transformers. A common variable is not valid as these outputs seem to be parallel processes. Interesting enough the common variable is accessible when using this scenario in debugging ...

Try DS.TOOLS menu from the CLI for your project. Pavan -----Original Message----- From: Himanshu Patel To: datastage-users@oliver.com Sent: 5/23/2002 2:50 PM Subject: RE: Command in CLI to Unlock a Job??? In Director under tools, You can try the "Clear Status File" to reset the job as well. If the j...

In Director under tools, You can try the "Clear Status File" to reset the job as well. If the job is locked and wont run you can try the following. 1. Right click and run the monitor to see if data is being moved or not. 2. If you can list the source file than there is no problem from that end., 3. ...

Does anyonw know a command in the CLI to unlock a job?

For some unknown reasons the Clean Up Resources in Director doesnt unlock our jobs, so I have to restart the server each time.

Thanks for your assistance...

Christian

Hooray! That worked. The UVFIXFILE command merely told me something to the effect that the Data.30 was too small. In Windows Explorer I could see that it was 0 bytes while the overflow (Over.30) section was 17,000KB. So, I followed the procedure you outlined and deleted the file. Thanks to everyone ...

At 01:37 PM 5/23/02 -0400, you wrote: >Brad, Brad, Most likely the problem is that you have a corrupted Type 30 file. A Dynamic Hashed file, also known as a Type 30 file, has a structure different to that of a Static Hashed file. It basically is : /Filename | +===========+============+ /.Type30 /DAT...

Brad, Worst case scenerio, and you have to delete the file. Can you delete it from NT ( while no users are on the system ). Locate the file and the "D_"{fiename} records and delete them. Then, remove the VOC item for the file. THen do a CREATE.FILE {filename} AND rebuild the contents of the file. -h...

Brad, 1. What does the VOC item contain ? 2. Is line 1 of the VOC item a Q. If so, you may need to log to the account where the file resides and delete the file there. Also, if it is a Q pointer, does the account ( folder in NT ) exist at all 3. Does the DICT section of the file exist? Type LIST DIC...

Thank you, Himanshu. I gave it a try. The item was already in the VOC file. You can see it in Windows Explorer as well. It just wont let me LIST or COUNT or DELETE it in Universe (via Telnet, of course). I also made sure no more processes were running. Can you think of anything else I may try? Thank...

Brad, you may not have to delete it. at the universe command line, type the following: 1. can you see the file using Windows NT Explorer? if you can, then the VOC pointer to the file is gone. type the following at the universe command line. CT VOC {filename} ( if its a new items or not found, then a...

Yep. Same thing. Unable to delete file. > -----Original Message----- > From: Riccardo Tani [SMTP:riccardo.tani@datamat.it] > Sent: Thursday, May 23, 2002 12:41 PM > To: datastage-users@oliver.com > Subject: Re: Delete bad hashed file > > Hi, > have you tried to use the command DELETE.FILE without sp...

Hi, have you tried to use the command DELETE.FILE without specifying the "DATA" option?? Regards, Riccardo ----- Original Message ----- From: "Vincent, Brad" To: "DataStage Mailing List" Sent: Thursday, May 23, 2002 6:39 PM Subject: Delete bad hashed file > Hi, > > How would I go about deleting a co...

Hi, How would I go about deleting a corrupt dynamic hashed file? We run an old version of DataStage (3.1 yuk) on an NT server. Our release of UniVerse is 9.4.1. We had a server problem today and now when we try to access one of our hashed files we get: Unable to open "filename" file When I try to is...