CBSUSE NO and KEY-USAGE atrribute
Article ID: 102076
Updated On:
Products
Datacom
DATACOM - AD
CIS
COMMON SERVICES FOR Z/OS
90S SERVICES
DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
COMMON PRODUCT SERVICES COMPONENT
Common Services
CA ECOMETER SERVER COMPONENT FOC
Easytrieve Report Generator for Common Services
INFOCAI MAINTENANCE
IPC
UNICENTER JCLCHECK COMMON COMPONENT
Mainframe VM Product Manager
CHORUS SOFTWARE MANAGER
CA ON DEMAND PORTAL
CA Service Desk Manager - Unified Self Service
PAM CLIENT FOR LINUX ON MAINFRAME
MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
GRAPHICAL MANAGEMENT INTERFACE
WEB ADMINISTRATOR FOR TOP SECRET
Xpertware
Issue/Introduction
We have some keys that we have executed CXX ALTER to CBSUSE=NO. We would like to make this permanent by defining the KEY-USAGE attribute in the Data Dictionary.
Which KEY-USAGE parameter is the same as CBSUSE=NO?
Is it possible to update the KEY-USAGE attribute to the PROD Data Dictionary version?
Environment
z/OS
Resolution
CBS-USE=NO means that CBS access cannot be used but RAAT access (Record at a time) is allowed.
So, the equivalent to that is KEY-USAGE=R.
KEY-USAGE=N means that the key cannot be used at all.
The KEY PROD status attribute can be updated.
A warning will be given about the KEY entity being in PROD status but the update will be successful.
So, the equivalent to that is KEY-USAGE=R.
KEY-USAGE=N means that the key cannot be used at all.
The KEY PROD status attribute can be updated.
A warning will be given about the KEY entity being in PROD status but the update will be successful.
Additional Information
CA Datacom Core - 15.1 section "CXXMAINT ALTER CBSUSE (Trial Delete a Key from CBS Use)"
https://docops.ca.com/ca-datacom/15-1/en/reference/dbutlty-reference/utility-function-summary/cxxmaint-maintain-directory/cxxmaint-alter-cbsuse-trial-delete-a-key-from-cbs-use
"...
CXXMAINT ALTER CBSUSE (Trial Delete a Key from CBS Use)
The CXXMAINT ALTER CBSUSE option allows you to specify whether a particular key is used by the Compound Boolean Selection Facility for SELxx commands. If a key is deleted from Compound Boolean Selection use, it remains available for record-at-a-time requests and CA Datacom®/DB maintains it during ADDIT, UPDAT, and DELET processing. Cataloging the database restores the use of all keys.
The following topics are discussed on this page:
When to Use
Effects on Maintenance
How to Use
Example JCL
Sample Report
Copy of DDB--Sample Report CXXMAINT ALTER CBSUSE (14.0)
When to Use
Use the ALTER CBSUSE option to test how deleting a key would change performance of applications accessing the specified table. Performance can improve as well as degrade.
..."
Go to the above documentation link for additional information.
https://docops.ca.com/ca-datacom/15-1/en/reference/dbutlty-reference/utility-function-summary/cxxmaint-maintain-directory/cxxmaint-alter-cbsuse-trial-delete-a-key-from-cbs-use
"...
CXXMAINT ALTER CBSUSE (Trial Delete a Key from CBS Use)
The CXXMAINT ALTER CBSUSE option allows you to specify whether a particular key is used by the Compound Boolean Selection Facility for SELxx commands. If a key is deleted from Compound Boolean Selection use, it remains available for record-at-a-time requests and CA Datacom®/DB maintains it during ADDIT, UPDAT, and DELET processing. Cataloging the database restores the use of all keys.
The following topics are discussed on this page:
When to Use
Effects on Maintenance
How to Use
Example JCL
Sample Report
Copy of DDB--Sample Report CXXMAINT ALTER CBSUSE (14.0)
When to Use
Use the ALTER CBSUSE option to test how deleting a key would change performance of applications accessing the specified table. Performance can improve as well as degrade.
..."
Go to the above documentation link for additional information.
Feedback
Yes
No
Powered by
