DatacomDATACOM - ADCISCOMMON SERVICES FOR Z/OS90S SERVICESDATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OSCOMMON PRODUCT SERVICES COMPONENTCommon ServicesCA ECOMETER SERVER COMPONENT FOCEasytrieve Report Generator for Common ServicesINFOCAI MAINTENANCEIPCUNICENTER JCLCHECK COMMON COMPONENTMainframe VM Product ManagerCHORUS SOFTWARE MANAGERCA ON DEMAND PORTALCA Service Desk Manager - Unified Self ServicePAM CLIENT FOR LINUX ON MAINFRAMEMAINFRAME CONNECTOR FOR LINUX ON MAINFRAMEGRAPHICAL MANAGEMENT INTERFACEWEB ADMINISTRATOR FOR TOP SECRETXpertware
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?
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.
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.