Steps to releasing job locks on DataStage Server for NT

[kcbland]

Here's how you release locks on NT reeeallly easily:

1. From your favorite terminal emulator, or simply use telnet, connect to your DataStage Server.
2. Login as the administrator user
3. For account or path, enter uv

Code: Select all

Welcome to the DataStage Telnet Server.
Enter user name: administrator
Enter password:
Account name or path(uv):uv
DataStage Command Language 5.1
(c) Copyright 2002 Ascential Software, Inc. -  All Rights Reserved
Engine logged on: Thu Dec 11 12:47:41 2003

>

Type in WHO for kicks:

Code: Select all

>WHO
120 Engine From DSServer\Administrator
>

List all locks on this server (lock table is for all projects, no way to tell in which project the object is in). Hope your locked object is the only one by that name. Also, it's difficult to tell a job from a routine from a table definition. The Item-ID column shows the name of the object.

Code: Select all

>LIST.READU

Active Record Locks:
Device.... Inode..... Netnode Userno  Lmode     Pid Item-ID....................
 658927608  862307173       0  65123   2 RU     413 xyz\Logfile\asdf 
 172083384 1571328983       0  65127  10 RU     409 Batch::testjob
1830106384 2118112721       0  65123  56 RU     413 NVL    
2122005122  321145999       0  65123  60 RU     413 93721C80-EDEA-11D5-9217-0001
03327D34-DSServer:413
 671011395 1268139670       0  65123  94 RL     413 YourProject&!DS.ADMIN!&

>

The column USERNO is the one you want to look at. You can unlock by USERNO. Be careful, all locks by that user will be released.

Code: Select all

>UNLOCK USER 65123 ALL
Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.
>                                                        

If you get stuck, all session commands have online help by typing:

Code: Select all

>HELP command

So, try unlock:

Code: Select all

 
>HELP UNLOCK

+-----------------------------------------------------------------------------+
 |                                                                             |
 | UNLOCK                                                                      |
 |                                                                             |
 | _________________________________________________________________           |
 |                                                                             |
 |                                                                             |
 |    Use UNLOCK to clear file, group, and update record locks.  You           |
 |    must  be  a DataStage Administrator logged in to the DataStage account   |
 |    to execute UNLOCK.                                                       |
 |                                                                             |
 | SYNTAX                                                                      |
 |                                                                             |
 |       UNLOCK [NODE node] [USER user.number]                                 |
 |          [FILE pathname | [DEVICE device.number]                            |
 |          [INODE i.node.number]] [GROUP group.address]                       |
 |          [RECORD record.ID]                                                 |
 |          {FILELOCK | GROUPLOCK | READULOCK | READLLOCK | ALL}               |
 |                                                                             |
 | QUALIFIERS                                                                  |
 |                                                                             |
 |               More               End Help          List Commands            |
 +--------------------------+     Page Down     +------------------------------+

To logout, enter Q:

Code: Select all

>Q

[JDionne]

Awsome man!!! Thats Just what I needed
Jim

[mfortuna]

I also recieved a compiled version of DS.UNLOCK from Ascential support. This is an unlock command that lets you release jobs as dsadm if you do not have root access. It was an added feature in 6.x, but you can catalog the BP for earlier Dstage versions. It has been invaluable on our project because of the number of VPN connections.

[kcbland]

Share the details! Don't tickle us and walk away. Those stuck in 5.1 land need to know

[mfortuna]

I can forward the BP to anyone who requires it.

[kduke]

I think we all want a copy. I hope you can send me one or post it.

Kim_G_Duke@hotmail.com

Kim.

[ray.wurlod]

If you send it to Clif Oliver (moderator@oliver.com) he can post it in the Files area of datastage-users@oliver.com

This site is still resolving the mechanisms for such a posting area.