ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
CA Database Management Solutions for DB2 for z/OS : Set Global Defaults as the execution default for the CA Database Management Solutions for DB2 for z/OS products.
Article ID: 187134
Database Management for DB2 for z/OS - Administration Suite
How do you set Global Defaults as the execution default so the highlvl.CDBAPARM member DEFAULTS settings are in effect for anyone using the CA Database Management Solutions for DB2 for z/OS tools?
An advantage of using the Global Defaults administration facility is the flexibility to have different defaults defined for various subsystems. For example, if you use the Interactive SQL facility, you specify if SQL changes should be committed or rolled back. You could specify the default for SQL changes on a test subsystem to be committed, but have all SQL rolled back for your production subsystem. 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.
DB2 for Z/OS
Set the DEFAULTS option in the highlvl.CDBAPARM member SETUPxx to DEFAULTS (YES). This option is specified in the header of the SETUPxx member.
The GLBLDEF command is used to access the CA-DB2 Global Defaults Administration facility.
S USERID SSID LOCATION DESCRIPTION CA-DB2 D23B LOCAL CA-DB2 PARMLIB DEFAULTS PD* D23B LOCAL DEVELOPEMENT DEFAULTS PDX* D23B LOCAL DEVELOPEMENT DEFAULTS FOR GROUP X PDXPGMR D23B LOCAL DEFAULTS FOR USER PDXPGMR TD* D23B LOCAL DEFAULTS FOR TECHNICAL WRITERS -------------------------------------------------------------------------------
The CA-DB2 Global Defaults Selection screen displays each row that represents a Global Defaults Definition. A Global Defaults Definition can apply to an individual user or a group of users. For example in the screen above the definition PDX* applies to all userids that start with PDX. PDXPGMR applies to an individual user. From this screen the defaults administrator can select a definition to be templated, updated or deleted. The defaults administrator can also view a definition after it has been merged with higher applicable definitions. For example for the screen above the administrator could view the definition PDX* after it has been merged with the definitions PD* and the CA-DB2 base defaults.