Saturday, December 27, 2008

Dataset ENQ and CONtention

If you are trying to edit or view a dataset and you get a message "data set in use", how will you find who is using it? ISRDDN is the answer.

Type TSO ISRDDN (in some shops its just ISRDDN - no TSO prefix required) and hit enter. Then type ENQ and hit enter.

You will get a screen like this:


Type your dataset name (or prefix) in "Minor name prefix" and hit enter.

You'll get a list of all the users/jobs that are viewing/editing the
dataset(s) under the Job Name field. These are color coded to indicate the following ENQue status:

GREEN - Shared
REVERSE GREEN - Waiting for shared
RED - Exclusive
REVERSE RED - Waiting for exclusive

For the System ENQ List you may specify specific Major, and Minor prefixes, as well as specific job or user prefixes to reduce the size of the list.

You can use the RESET command to reset these values to defaults.

On the ENQ display screen, you can type ALL to view all system ENQs or RESET to view the SYSDSN enqs for your user id.

The System ENQ Contention display (command Con) shows all ENQ contention on the system.

2 comments:

Vinay said...

You can also hit PF1 twice to see which USERID was actually holding the dataset... ISRDDN is the other way to come to the same information!

Kumaresh T said...

You are absolutely right Vinay.

ISRDDN has one slight advantage over this - with ISRDDN you can see ALL the enqueued datasets all at the same time in one screen instead of PF1 for every dataset separately.

- Aji