Datastage job is locked by another user

Problem

When trying to open a job in Designer client in DataStage (DS), message indicates the job is locked by another user.

Solution

Perform the following steps for unlocking the job.
Unix/Linux:
  1. Log into the server using the dsadm user.
  2. cd to the DSEngine directory.
  3. Enter . ./dsenv to source the dsenv file
  4. Enter ./bin/uvsh to get into DataStage prompt
  5. At ">" DataStage engine prompt, enter LOGTO project name
  6. Run LIST.READU EVERY to list all the locks
  7. Check active record locks under "Item Id" column for job name or RT_CONFIG# or RT_LOG# (# matches the job description number.
  8. Write down the Inode numbers and user numbers associated with these locks.
  9. Enter LOGTO UV
  10. Enter UNLOCK INODE inode# USER user# ALL
  11. You can use Q (QUIT) to get out of DataStage engine

Windows:
  1. Launch DS Director
  2. Select Job -> Cleanup Resources (if Cleanup Resources is disabled, go to step 10 below)
  3. In the Processes pane, click Show All
  4. In the Locks pane, click Show All
  5. In the Locks pane, scroll to the job name in the Item ID field
  6. Note the PID/User # associated with the job
  7. Click on the PID # in the upper pane (Processes)
  8. Click Show by process (Locks pane)
  9. Click Release All (Locks pane)
  10. Launch DS Administrator
  11. In the Projects tab, highlight the job
  12. Click Properties
  13. Check Enable job administration in Director
  14. Click OK
  15. Click Close
  16. Exit DS Director and relaunch
  17. Perform steps 3 - 9 above.

Popular posts from this blog

Shrink you container size up to 95%.

alma linux: dnf Module yaml error: Unexpected key in data