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:
Windows:
Unix/Linux:
- Log into the server using the dsadm user.
- cd to the DSEngine directory.
- Enter . ./dsenv to source the dsenv file
- Enter ./bin/uvsh to get into DataStage prompt
- At ">" DataStage engine prompt, enter LOGTO project name
- Run LIST.READU EVERY to list all the locks
- Check active record locks under "Item Id" column for job name or RT_CONFIG# or RT_LOG# (# matches the job description number.
- Write down the Inode numbers and user numbers associated with these locks.
- Enter LOGTO UV
- Enter UNLOCK INODE inode# USER user# ALL
- You can use Q (QUIT) to get out of DataStage engine
Windows:
- Launch DS Director
- Select Job -> Cleanup Resources (if Cleanup Resources is disabled, go to step 10 below)
- In the Processes pane, click Show All
- In the Locks pane, click Show All
- In the Locks pane, scroll to the job name in the Item ID field
- Note the PID/User # associated with the job
- Click on the PID # in the upper pane (Processes)
- Click Show by process (Locks pane)
- Click Release All (Locks pane)
- Launch DS Administrator
- In the Projects tab, highlight the job
- Click Properties
- Check Enable job administration in Director
- Click OK
- Click Close
- Exit DS Director and relaunch
- Perform steps 3 - 9 above.