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
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.
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.