unlock datastage jobs

28 Feb

NOTE:
In IIS v8, you’ll need to login to the Web Console “http://:9080” go to ‘Administration’ -> ‘Sessions’ and disconnect the offending session!!!!!!!!!!!

Found this on a forum:

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

Advertisements

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

%d bloggers like this: