Ascential DataStage: Cleanup Resources to Release Orphans Processes

When there are defunct processes with PID of 0 (zero). You can see those orphan processes (through Director) but cannot kill the processes by selecting the orphan processes and pressing "Release". You can only Unlock the process using TCL commands:

1. Login as root DataStage Server machine.
2. Launch DataStage TCL
3. At TCL prompt, you can enter "LOGTO projectname" to log into the project account. The project name is case sensitive.
4. To find out what the job description number, enter "LISTDS_JOBS jobname".
5. Enter "LIST.READU EVERY" at TCL. 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. Enter "LOGTO UV" to log into UV account. The UNLOCK command lives in UV account.
8. Enter "UNLOCK INODE inode# USER user# ALL". This will unlock the lock hold on this file (inode#) and hold by this user (user#) for file locks, group locks and record locks. If you need to see all the locks again, enter "LIST.READU EVERY".
9. type Q to logout from Universe

References:

• DataStage Documentations
• Other References On The Web

Related Posts:

• Ascential DataStage: Find Out What a Job Description Number Is for a Particular Job
• Ascential DataStage: Unlock a User’s Processes and Clean resources.