Define Defaults for DB2 Object Attributes

Using Object Definition Defaults, you can define defaults for DB2 object attributes. The specified defaults are used as the initial attribute values when an object is created, templated, or altered. If no definitions exist when an object is created, defaults are typically aligned with the values that are used by DB2. For altered and templated objects, the initial attribute settings are derived from the DB2 catalog or optionally from a strategy or imported DDL definition.
For more information about the DB2 object attributes, see the DB2 catalog table descriptions in the IBM
DB2 SQL Reference
You can define default definitions for individual users or for groups of users. Defaults can be assigned for groups of IDs using an ID mask. A mask is a valid TSO ID followed by an asterisk (*).
Use the Product Authorizations facility (option
from the CA Database Management Solutions for DB2 for z/OS Main Menu) to define which users can view and change object definition defaults for which IDs. These privileges are shared between
CA RC/Migrator™ for DB2 for z/OS
CA RC/Update™ for DB2 for z/OS
. These privileges are defined through the RC/Update Authorizations panel.
Follow these steps:
  1. Do
    of the following on the command line:
    • From
      CA RC/Migrator™ for DB2 for z/OS
      , enter
    • From
      CA RC/Update™ for DB2 for z/OS
      , enter
    Press Enter.
    The Object Definition Defaults panel appears.
    Defaults for the current user or the mask ID that matches most closely are displayed. When a template or an alter panel initially appears, the values of the existing object are displayed. To change those values to the default values, enter APPLY DEF at the command line.
  2. Complete the following values:
    • Specify the TSO ID of the user in the
      field. The user ID identifies the TSO ID of the user for whom object definition defaults are being defined or the mask ID that most closely matches. You can use character masking to select from a list. Character masking always takes precedence over a masked ID. Enter a percent sign (%) to display a selection list.
    • Specify a description of the ID or the mask (up to thirty characters) in the
    • Specify S (save), R (retrieve), or D (delete) in the
    Press Enter to process.
    The Object Definition Defaults are saved, retrieved, or deleted. The panel shows:
    • The type of DB2 object to which the attributes apply. GLOBAL DEFAULTS apply to all DB2 object types. However, if an attribute default is also specified for the specific object type, that value is used. 
    • The name of the object attribute.
    • The default value of the object attribute. For some attributes, information is displayed to help you specify a valid value.
  3. Update the default values for each object type as needed and specify
    as the Action to save your entries.