CBSUSE NO and KEY-USAGE atrribute
search cancel

CBSUSE NO and KEY-USAGE atrribute

book

Article ID: 102076

calendar_today

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. 

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.