Ascential DataStage: Unlock a User’s Processes and Clean resources.

From time to time, if the client, i.e., the designer, was abnormally exited you will see your jobs being locked. For example, a user turns off the PC without close the datastage job first. In this situation, you need to unlock a lock on a job before you can open it.

(A.) Unlock From Unix/Linux TLC

1. Login into DataStage Server machine as root
# sudo su -root

2. Change to DataStage home directory
Type: # cd `cat /.dshome`
Alternatively, you can just type the full directory path. i.e.:
#cd /home/dsadm/Ascential/DataStage/DSEngine)

3. Source the dsenv file to set up the environment variables# . dsenv (source the dsenv file)
4. Load the TCL prompt# bin/uv you are now at the TCL prompt.
5. Type the following in the TCL to displays all the locks)

>LIST.READU EVERY

look for the lock on your job. You may need to scroll down a bit. Note the number under the userno column. You will also notice the user login id under the login id column.
6. At the TCL prompt , type the command to unlock locks for this user.

>UNLOCK USER userno ALL

Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.

userno is the number in the userno column holding the lock.

(B.) Unlock From the DataStage Director

1. From the DataStage Director window highlight the job being accessed by another user. From the "Job" menu choose "Cleanup Resources".
2. If this is grayed out (disabled) you need to go to the DataStage Administration Window highlight this project, then choose Properties and under the General tab click on "Enable Job administration in Director".
If you had to enable "Cleanup Resources" you will need to close your Director window and log back in.
3. Once you are in the Cleanup resources Window. On both panes click on "Show All" the top pane is "processes" and the bottom pane is Locks.
Scroll down on the bottom pane until you see the job that is locked. Note the PID number. On the top pane highlight the pid number. From the bottom pane click on "Show By Process" the Release all button should now be enabled. Click on it and it should release the locks. Now try to log in an open the job in question.

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: Cleanup Resources to Release Orphans Processes