Can't see locks in DS.TOOLS

jhmckeever · Post by **jhmckeever** » Tue Jun 20, 2006 5:38 am

Hi Everyone,

We recently implemented proper user groups/privileges on our DS development environment and since then I haven't been able to see any locks using DS.TOOLS when logged in as dsadm.

Using LIST.READU gives me a list of locks no problem, but DS.TOOLS (option 5, then 4) gives nothing! I also get nothing when I try and list all processes (option 1). Any ideas?

Thanks,
John.

chulett · Post by **chulett** » Tue Jun 20, 2006 5:55 am

No ideas off the top of my head, but I think that you should explain exactly what this means to help set the scene properly:

We recently implemented proper user groups/privileges on our DS development environment

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 6:20 am

Make sure you are connected in the project. Try for the same in TCL.

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 6:33 am

For first time I pressed 5 then 4, it didnt gave me the list of locks. But for second in the same page I pressed 4, it gave me out the results.
I tried this form several project.
You too can try.

jhmckeever · Post by **jhmckeever** » Tue Jun 20, 2006 6:50 am

chulett wrote:No ideas off the top of my head, but I think that you should explain exactly what this means to help set the scene properly:

We recently implemented proper user groups/privileges on our DS development environment

Craig:
User dsadm now has primary group 'dstage', as do all DataStage users. Each user also has secondary group 'dsdev' or 'dsopt' depending upon whether they should have developer or operator permissions on projects.

kumar_s:
I am logged on to my project. I get the same response no matter how many times I try the menu option. It's also the same if I exit UV and go back in.

John.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 20, 2006 7:52 am

Does the DS.TOOLS option give you anything at all?

jhmckeever · Post by **jhmckeever** » Tue Jun 20, 2006 8:06 am

ray.wurlod wrote:Does the DS.TOOLS option give you anything at all?

Here's one on a project with a Manager and Designer connected:

Code: Select all

DataStage Process and Lock Administration

 1. List all processes
 2. List state of a process
 3. List state of all processes in a job
----------------------------------------------
 4. List all locks
 5. List locks held by a process
 6. List locks held by all processes in a job
----------------------------------------------
 7. Clear locks held by a process
 8. Clear locks held by all processes in a job
----------------------------------------------
 9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job

Which would you like? ( 1 - 11 )  ?4
==========================Locks held by all processes==========================




Press any key to return to the menu...

The same for option 1 too. This is the same for all projects on the server. Other servers (on which we haven't implemented our user/group privileges) are OK.

DSguru2B · Post by **DSguru2B** » Tue Jun 20, 2006 8:09 am

I use the DS.Tools option to unlock the processes.
These are the steps I follow:
1. List.readu -- give you the Processes with usernames and jobs that are used or locked.
2. Note the PID number for the job to unlock.
3. DS.Tools
4. Option 7
5. Option 4
6. Enter the PID.
7. enter Y to confirm.

If by change even after entering the PID number you are not prompted for confirmation, then you will be taken to the main menu and follow the steps from 4 again.

IHTH

kumar_s · Post by **kumar_s** » Tue Jun 20, 2006 8:12 am

jhmckeever wrote:
ray.wurlod wrote:Does the DS.TOOLS option give you anything at all?
Here's one on a project with a Manager and Designer connected:
Code: Select all
DataStage Process and Lock Administration

 1. List all processes
 2. List state of a process
 3. List state of all processes in a job
----------------------------------------------
 4. List all locks
 5. List locks held by a process
 6. List locks held by all processes in a job
----------------------------------------------
 7. Clear locks held by a process
 8. Clear locks held by all processes in a job
----------------------------------------------
 9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job

Which would you like? ( 1 - 11 )  ?4
==========================Locks held by all processes==========================




Press any key to return to the menu...
The same for option 1 too. This is the same for all projects on the server. Other servers (on which we haven't implemented our user/group privileges) are OK.

Press any key to return to the menu...

What comes after if you press Next or Respond at this stage?

jhmckeever · Post by **jhmckeever** » Tue Jun 20, 2006 9:56 am

As promised, it returns to the menu.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 20, 2006 2:39 pm

The equivalent command for option 4 is LIST.READU. I will have to research the equivalent command for option 7 but am not doing DataStage work this week.