DSXchange

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.

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.

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.

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.

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.

What changed? I honestly have no idea why that would be the case. Best to involve your official support provider unless someone here has an idea.

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

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

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,

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.

Pradeep,

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