Clean up resources in Director
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Tue May 13, 2008 9:55 pm
- Location: Chennai
- Contact:
Clean up resources in Director
Clean up resources in Director not showing any of the process ID and Processes. I am not able to unlock the jobs being accessed by other users. What needs to be done to get back all the process ID.
Thanks in advance
Pradeep.
Thanks in advance
Pradeep.
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: Clean up resources in Director
Try Search in dsxchange. There has been a lot of material posted! There are ways to get PIDs and stuff by logging onto the shell itself.pradeepkumar wrote:Clean up resources in Director not showing any of the process ID and Processes. I am not able to unlock the jobs being accessed by other users. What needs to be done to get back all the process ID.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Participant
- Posts: 8
- Joined: Tue May 13, 2008 9:55 pm
- Location: Chennai
- Contact:
chulett wrote:So... the 'Show All' buttons don't show you any processes?
You have to be logged in as the "Administrator" to work with other people's processes. ...
The "Show All" doesn't show any of the processes. Previously it has shown all the processes running and their Process ID. Currently it is not showing any of the process running on the server.
Pradeep KUmar, Chennai.
Re: Clean up resources in Director
Hi
i am posting collection.......
Log into DS Administrator
Enter LIST DS_JOBS <job name>. The job name is case sensitive.
Write down the job number.
Run LIST.READU EVERY. Look under the Active Record lock at last column Item-ID. Look for locks on the job name or anything associate with the
job number. For example RT_LOG##, RT_CONFIG##, RT_STATUS##.
Write down the inode# and user# for those locks.
Enter LOGTO UV to log into UV account.
Enter UNLOCK INODE <inode#> USER <user#> ALL.
This will unlock all the file, group and record locks.
Use DS.TOOLS option 5. This brings up another menu in which you can list and release locks. Please use caution.
Once you've used DS.TOOLS to unlock a lock, the UNLOCK verb [b:5d93221064]is [/b:5d93221064]in your VOC file. Magic can happen!
1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:
LIST.READU
4. The last column is the item id. Look for item id's like:
jobname
This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.
5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:
SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK
Note: This only needs to be done the first time in each project.
6. To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
i am posting collection.......
Log into DS Administrator
Enter LIST DS_JOBS <job name>. The job name is case sensitive.
Write down the job number.
Run LIST.READU EVERY. Look under the Active Record lock at last column Item-ID. Look for locks on the job name or anything associate with the
job number. For example RT_LOG##, RT_CONFIG##, RT_STATUS##.
Write down the inode# and user# for those locks.
Enter LOGTO UV to log into UV account.
Enter UNLOCK INODE <inode#> USER <user#> ALL.
This will unlock all the file, group and record locks.
Use DS.TOOLS option 5. This brings up another menu in which you can list and release locks. Please use caution.
Once you've used DS.TOOLS to unlock a lock, the UNLOCK verb [b:5d93221064]is [/b:5d93221064]in your VOC file. Magic can happen!
1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:
LIST.READU
4. The last column is the item id. Look for item id's like:
jobname
This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.
5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:
SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK
Note: This only needs to be done the first time in each project.
6. To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
Re: Clean up resources in Director
Hi
i am posting collection.......
Log into DS Administrator
Enter LIST DS_JOBS <job name>. The job name is case sensitive.
Write down the job number.
Run LIST.READU EVERY. Look under the Active Record lock at last column Item-ID. Look for locks on the job name or anything associate with the
job number. For example RT_LOG##, RT_CONFIG##, RT_STATUS##.
Write down the inode# and user# for those locks.
Enter LOGTO UV to log into UV account.
Enter UNLOCK INODE <inode#> USER <user#> ALL.
This will unlock all the file, group and record locks.
Use DS.TOOLS option 5. This brings up another menu in which you can list and release locks. Please use caution.
Once you've used DS.TOOLS to unlock a lock, the UNLOCK verb [b:5d93221064]is [/b:5d93221064]in your VOC file. Magic can happen!
1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:
LIST.READU
4. The last column is the item id. Look for item id's like:
jobname
This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.
5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:
SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK
Note: This only needs to be done the first time in each project.
6. To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
i am posting collection.......
Log into DS Administrator
Enter LIST DS_JOBS <job name>. The job name is case sensitive.
Write down the job number.
Run LIST.READU EVERY. Look under the Active Record lock at last column Item-ID. Look for locks on the job name or anything associate with the
job number. For example RT_LOG##, RT_CONFIG##, RT_STATUS##.
Write down the inode# and user# for those locks.
Enter LOGTO UV to log into UV account.
Enter UNLOCK INODE <inode#> USER <user#> ALL.
This will unlock all the file, group and record locks.
Use DS.TOOLS option 5. This brings up another menu in which you can list and release locks. Please use caution.
Once you've used DS.TOOLS to unlock a lock, the UNLOCK verb [b:5d93221064]is [/b:5d93221064]in your VOC file. Magic can happen!
1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:
LIST.READU
4. The last column is the item id. Look for item id's like:
jobname
This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.
5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:
SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK
Note: This only needs to be done the first time in each project.
6. To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
-
- Participant
- Posts: 8
- Joined: Tue May 13, 2008 9:55 pm
- Location: Chennai
- Contact:
Re: Clean up resources in Director
sreddy wrote:Hi
i am posting collection.......
Log into DS Administrator
Enter LIST DS_JOBS <job name>. The job name is case sensitive.
Write down the job number.
Run LIST.READU EVERY. Look under the Active Record lock at last column Item-ID. Look for locks on the job name or anything associate with the
job number. For example RT_LOG##, RT_CONFIG##, RT_STATUS##.
Write down the inode# and user# for those locks.
Enter LOGTO UV to log into UV account.
Enter UNLOCK INODE <inode#> USER <user#> ALL.
This will unlock all the file, group and record locks.
Use DS.TOOLS option 5. This brings up another menu in which you can list and release locks. Please use caution.
Once you've used DS.TOOLS to unlock a lock, the UNLOCK verb [b:5d93221064]is [/b:5d93221064]in your VOC file. Magic can happen!
1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:
LIST.READU
4. The last column is the item id. Look for item id's like:
jobname
This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.
5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:
SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK
Note: This only needs to be done the first time in each project.
6. To unlock by either INODE or User No use the commands:
UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL
Thanks for the information. Its working fine. But what we need to do to get the process details shown up in director. Is this the problem with the setup?
Thanks,
Pradeep KUmar, Chennai.
Pradeep,pradeepkumar wrote:chulett wrote:So... the 'Show All' buttons don't show you any processes?
You have to be logged in as the "Administrator" to work with other people's processes. ...
The "Show All" doesn't show any of the processes. Previously it has shown all the processes running and their Process ID. Currently it is not showing any of the process running on the server.
This looks like a known issue...The Cleanup Resources option of the DataStage Director doesn't show any information under Processes.
Please ask your Support Provider for a patch..
ecase 117674
version 7.5.2