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
>
Code: Select all
>WHO
120 Engine From DSServer\Administrator
>
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!&
>
Code: Select all
>UNLOCK USER 65123 ALL
Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.
>
Code: Select all
>HELP command
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 +------------------------------+
Code: Select all
>Q