Jobs not releasing

opdas · Post by **opdas** » Thu Jul 06, 2006 1:54 am

Hi,
We are not able to release jobs from director using "Clean up resources" as the window showing all process with "Show all" being on shows one PID# with 0 .
While our development server doesnt have any problem.

keshav0307 · Post by **keshav0307** » Thu Jul 06, 2006 3:59 am

try this :

1. Telnet to the DS server machine and cd to $DSHOME directory as root or dsadm account; (where $DSHOME is the DSEngine directory)

2. Run ". ./dsenv";

3. Run "bin/uvsh" to enter DS Command Prompt;

4. Enter "LOGTO UV" to log into UV account. (*may not need to be done on DS 7) If the LOGTO command is disabled, use this command "CHDIR <path_to_the_DSEngine_folder>" (with <path_to_the_DSEngine_folder>=cat /.dshome under a telnet session on the DataStage server). The UNLOCK command lives in UV account.

5. Type ">LIST.READU EVERY" and press "Enter". Check active record locks under "Item Id" column for job name or RT_CONFIG# or RT_LOG# (# matches the job description number.

6. Write down the inode number and user number for the lock that is not a valid lock.

7. Type ">UNLOCK INODE inode# USER user# ALL" and press "Enter";

This will unlock the lock hold on this file (inode#) and hold by this user (user#) for file locks, group locks and record locks.

9. If you need to see all the locks again, type ">LIST.READU EVERY" and press "Enter".

10. Enter ">LOGTO projectname" and press "Enter" to logto the project repository; (where projectname is case sensitive)

11. Enter "CLEAR.FILE RT_STATUSxx" and press "Enter" to clear the status for the job; (where xx is the job_number for that job);

12. Enter "LO" to exit the DS Command Prompt;

opdas · Post by **opdas** » Thu Jul 06, 2006 4:40 am

Keshav,
Thanks a lot for the reply..... we could release the locks as you have mentioned but my query was why is the Process area in the Clean up process was blank .....

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 5:49 am

Usually because someone has killed a parent process, making a zombie out of the child process.

opdas · Post by **opdas** » Thu Jul 06, 2006 7:38 am

Ray,
Restarting the server is also not helping. What should we do ??

ray.wurlod · Post by **ray.wurlod** » Thu Jul 06, 2006 5:03 pm

When you say "restarting the server" do you mean restarting DataStage or re-booting the operating system? The latter is pretty much guaranteed to work (since locks are held in memory) unless your Repository database(s) have been corrupted.

opdas · Post by **opdas** » Sun Jul 09, 2006 2:56 am

I'm restarting Datastage only.
I have to check with my client if we can restart the operating system too. Lots of approvals involved !!

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jul 10, 2006 8:36 am

I assume that using UV did not work for you since you are planning to restart the operating system