Page 1 of 1
Can't see locks in DS.TOOLS
Posted: Tue Jun 20, 2006 5:38 am
by jhmckeever
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.
Posted: Tue Jun 20, 2006 5:55 am
by chulett
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
Posted: Tue Jun 20, 2006 6:20 am
by kumar_s
Make sure you are connected in the project. Try for the same in TCL.
Posted: Tue Jun 20, 2006 6:33 am
by kumar_s
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.
Posted: Tue Jun 20, 2006 6:50 am
by jhmckeever
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.
Posted: Tue Jun 20, 2006 7:52 am
by ray.wurlod
Does the DS.TOOLS option give you anything at all?
Posted: Tue Jun 20, 2006 8:06 am
by jhmckeever
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.
Posted: Tue Jun 20, 2006 8:09 am
by DSguru2B
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
Posted: Tue Jun 20, 2006 8:12 am
by kumar_s
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?
Posted: Tue Jun 20, 2006 9:56 am
by jhmckeever
As promised, it returns to the menu.
Posted: Tue Jun 20, 2006 2:39 pm
by ray.wurlod
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.