The use of Global Defaults in the CA Database Management Solutions for DB2 for z/OS products.

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

The Global Defaults administration facility is flexible and can define different defaults for various subsystems. For example, if you use the Interactive SQL facility, the SQL changes option can specify if these should be committed or rolled back. SQL changes can be specified as a default on a test subsystem to be committed, but have all SQL rolled back for your production subsystem.


How to set up Global Defaults as the execution default so that the hlq.CDBAPARM member DEFAULTS settings are in effect for anyone using the CA Database Management Solutions for DB2 for z/OS tools?


Set the DEFAULTS option in the hlq.CDBAPARM member SETUPxx to DEFAULTS (YES). This option is specified in the header of the SETUPxx member thus:

SDI      (NO)  

This facility lets you specify defaults for individual users or groups of users for variables previously stored in the ISPF profiles. The default values will be saved inside a DB2 table on a per-subsystem basis.

Additional Information:

The Global Defaults are described in CA Database Management Solutions for DB2 for z/OS - 19.0: Global Defaults.
For more information about the SETUPxx member options please refer to the Installing section : Creating and Editing Global and Product Parmlib Members, section Create a SETUP Global Parmlib Member.