To Release Job locks in Datastage

Hi All,

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”