idpt0000

Icon

Unlock DataStage Object

Just find a useful thread in IBM’s forum : How to unlock a job accessed by another user.  

Removing locks when you receive the error:…Cannot get exclusive access …

1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:

LIST.READU

4. The last column is the item id. Look for item id’s like:

jobname

This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.

5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:

>SET.FILE UV VOC UV.VOC
>COPY FROM UV.VOC TO VOC UNLOCK

Note: This only needs to be done the first time in each project.

6. To unlock by either INODE or User No use the commands:

UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL

Another approach :

1. telnet to DS server machine as ds administrative account (dsadm or root for example);
2. cd to $DSHOME;
3. source dsenv by “. ./dsenv”; (read as dot_space_dot_dsenv)
4. run “bin/uvsh” to enter TCL prompt;
5. run “>LIST.READU EVERY”, are you able to find any lock for the project under Active Record Locks? If yes, mark down the Userno for the command below;
6 run “>UNLOCK USER userno ALL”;
7. run “>LIST.READU EVERY” again to verify the lock for the user is gone;
8. repeat step 6 and 7 until all locks for the project is clear;
9. run “>LO” to exit TCL prompt.
10. try login to the project again.

Filed under: DataStage, ETL, 走在最前,

5 Responses

  1. Vanessa says:

    Many thanks! it really works..
    More power

  2. Ram says:

    Thanks alot… it was the need of the hour

  3. VM says:

    Thanks a Lot.Works well with Datastage Windows Version

  4. HA says:

    thanks a lot.. it really works :)

  5. viv says:

    It was the best explaniation I have seen.Bingo :-)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

RSS 極力推介

  • An error has occurred; the feed is probably down. Try again later.

Tweets

%d bloggers like this: