To Release 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”

• E