I know this can be done by LIST.READU command. But I dont know how to execute this command.
Regards,
Prashanto
want to know which locks are held
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu May 22, 2003 4:40 am
- Location: California
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have at least six options.
1. Use the Administrator client window, as Emma suggested.
2. Use the Cleanup Resources option in Director (this needs to be enabled from Administrator). The bottom pane contains the output from LIST.READU.
3. Establish a telnet connection to the server and enter the DataStage environment (via the uv command) in your project directory after executing the dsenv script in the DataStage Engine directory. (The prompt should be >) Then execute the LIST.READU command.
4. As for 3 but execute the command DS.TOOLS and choose the Locks option.
5. At the operating system prompt on the server, execute the command list_readu (this command is located in the DataStage Engine bin directory).
6. At the operating system prompt on the server, execute the command analyze.shm -r -g -f (this command is located in the DataStage Engine bin directory).
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
1. Use the Administrator client window, as Emma suggested.
2. Use the Cleanup Resources option in Director (this needs to be enabled from Administrator). The bottom pane contains the output from LIST.READU.
3. Establish a telnet connection to the server and enter the DataStage environment (via the uv command) in your project directory after executing the dsenv script in the DataStage Engine directory. (The prompt should be >) Then execute the LIST.READU command.
4. As for 3 but execute the command DS.TOOLS and choose the Locks option.
5. At the operating system prompt on the server, execute the command list_readu (this command is located in the DataStage Engine bin directory).
6. At the operating system prompt on the server, execute the command analyze.shm -r -g -f (this command is located in the DataStage Engine bin directory).
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518