How can I see what the CXX enqueue scope has been set to, whether LOCAL or SYSPLEX?

Document ID : KB000011449
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

 

 

Question:

How can I see what the CXX enqueue scope has been set to, whether LOCAL or SYSPLEX?

Environment:
z/OS
Answer:

Any one of the following methods below will provide the CXX enqueue setting:

 1- DBUTLTY REPORT AREA=CXX: A full CXX report (without DBID= ) will tell you the scope of your CXX Enqueue.

In the CXX report output, the first page is the CXX Directory report. This CONTROL AREA DIRECTORY section will provide the CXX ENQ value SYSPLEX or LOCAL. 

For example:

CONTROL AREA DIRECTORY
DBCRBAS REQUIREMENT (ALL BASES OPEN)  -    xx,xxx           CXX ENQ - SYSPLEX

...

 

 2- DBUTLTY REPORT AREA=CXX,TYPE=K (with no other parameters). 

The TYPE=K report will produce just the CXX Directory report which shows the full CXX options in place and also provides information about encryption as defined to the CXX and tables.

 

 3- SQL request. Another way, for those who have Datacom SQL available, is to execute the following request: 

SELECT * FROM SYSADM.DIR_DIRECTORY;

The CXX_ENQ column contains the level of CXX locking in effect, either LOCAL or SYSPLEX. This value can be changed by running CXXMAINT.

 

 4- Another way, for those who have CA SYSVIEW, is to use the command DCDIR after attaching (command ACID) to the desired MUF job.

DCDIR command will display the CXX settings including "Locking": 

CXX Settings
Dataset Extent Validation     YES
Locking                       SYSPLEX
...

Additional Information:

Refer to CA Datacom Core - 15.1 section on "Directory (CXX) Reports"
https://docops.ca.com/ca-datacom/15-1/en/reference/dbutlty-reference/utility-function-summary/report-generate-reports/directory-cxx-reports