We have moved to www.dataGenX.net, Keep Learning with us.

Saturday, October 06, 2012

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

No comments :

Post a Comment