Archive | February, 2008

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

DataStage Error:

18 Feb

“Abnormal termination of stage xxx detected”

If you get this on a Transfomer stage that takes in hashfile lookup’s, try remaking the hash files