To Release Job locks in Datastage

There are Three methods to unlock the DataStage jobs:

– Using DataStage Administrator Tool.

 – Using UV Utility

 – Using DataStage Director

Unlock jobs -Using DataStage Administrator Tool:

• Log into Administrator (as dsadm)

 • Open the Command line for the project

 • Execute “LIST.READU EVERY”

 • Identify the values for INODE and USER columns for the job for which the locks need to be released.

 • Execute UNLOCK INODE <inodenumber> ALL

 • UNLOCK USER <user number> ALL

Unlock jobs -Using UV Utility:

 • Logon to Unix

 • Su to dsadm

 • Go to a corresponding project

 • Type “UV”

 • Type “DS.TOOLS”

 • Select the option “4” (4. Administer processes/locks >>)

 • Again Select the option “4” (4. List all locks)

 • Identify the values for PID columns for the job for which the locks need to be released.

 • Then select the Option “7” (7. Clear locks held by a process)

 • Give the PID value here(Enter pid#=) and press Enter.

Unlock jobs -Using DataStage Director:

– Open DataStage Director

– Go to the Job

– Cleanup Resources

– In the Job Resources window,

– Select “Show All” (Processes)

– Find your User Name and click on “Logout”

njoy the simplicity.......
Atul Singh