Create a SETUP Global Parmlib Member

The SETUP global parmlib member contains information about your z/OS environment and Db2 subsystems. This member is required to install the CA Database Management Solutions for Db2 for z/OS.
dm20
Create one or more SETUP global parmlib members to define your z/OS environment and Db2 subsystems to the
CA Database Management Solutions for DB2 for z/OS
.
We recommend that you create one SETUP member for each LPAR
.
If you plan on processing a Db2 subsystem from more than one LPAR, define that subsystem on each LPAR so that each SETUP member contains the same Db2 subsystem definitions. For example, you might use this processing with
RC/Compare
, which can access Db2 objects across Db2 subsystems on different processors.
When using separate SETUP members for each LPAR, we recommend that you define all member names and data sharing group names, group attachment names, or subgroup attachment names in each SETUP member so that the
CA Database Management Solutions for DB2 for z/OS
can access information about all the subsystems within the group. When you edit an existing SETUP member, you can edit group-wide options for all data sharing group members simultaneously. See Data Sharing Requirements.
Use the SETUP member to specify:
  • Site options like the long name truncation symbol, Xmanager connection identifier (XMANID), and Db2 connection type. You can also specify whether to display all
    CA Database Management Solutions for DB2 for z/OS
    on the products main menu or only licensed products. The main menu is accessible after completion of the post-installation customization tasks.
    The XMAINID is used to establish a connection between the products in the
    CA Database Management Solutions for DB2 for z/OS
    and the Xmanager started task. You can connect to multiple Xmanager started tasks by maintaining multiple suffixed SETUP members. For example, SETUP00, SETUP01, and so on. The value that is specified in the SETUP member must match the XMANID JCL parameter in the Xmanager started task JCL. For more information about this parameter, see Prepare the Xmanager Started Task Procedure.
  • Db2 subsystem information (Db2 version information, PTDB options, tablespace and index options, QMF options if applicable and DDF information). The Db2 version information is used:
    • During post-install processing to generate Db2 version-specific object definitions when generating DDL and BIND control statements. These values also enable offline generation of the BIND control statements to reduce the maintenance window.
    • When connecting to Db2 for validation and comparison with the Db2 environment. When inconsistencies exist between these field values and the Db2 runtime environment, the Db2 connection is denied. To ensure that tha the runtime environment is configured properly to support that environment, correct these values in the SETUP member. Then, execute the Db2 catalog post-install compare and bind Db2 catalog customization tasks.
    • To enable certain features in some products when the Db2 subsystem is not available.
    The Db2 subsystem information also includes:
    • PTDB options (storage group, database, bind owner, and data sharing group name if part of a data sharing group).
    • Tablespace and index options (BUFFERPOOL, DEFINE, CLOSE, and COMPRESS).
    • QMF options if applicable.
    • DDF location, subsystem ID, and location type (z/OS or remote DBMS system that supports DRDA access).
Detailed information is provided in the online help panels for all SETUP member options.
Follow these steps:
  1. Type
    1
    (Setup) in the Option line on the Post-Install Tailoring menu (INSMAIN) and press Enter.
    The Parameter Setup Menu (INSPMM) appears.
  2. Type
    2
    (Global) in the Option line and press Enter.
    The Create/Edit Parmlib Members panel (INSEDPRM) appears. This panel lists the global parmlib members (PTISYS, DSNAME, SETUP, PLANS, ISPF, and ENVDEF) and the member status.
  3. Type
    S
    next to the SETUP (Global and DB2 Subsystem Information) entry to select it for processing and press Enter.
    A list of currently defined SETUP members appears on the Create/Edit Parmlib Members Selection List panel (INSEDPR2).
    Initially, the SETUP member is listed with the default suffix (00). You can select the member for processing, insert a new member, or delete an existing member. Manual editing of the member in
    hlq
    .CDBAPARM using the E option is
    not
    recommended.
  4. Complete
    one
    of the following steps:
    • Type
      S
      to select the default member for processing and press Enter.
    • Type
      I
      (INSERT) to insert a new member and press Enter. A new row is inserted for the new member. Specify a two-digit suffix to assign to the new SETUP member in the Suffix field and press Enter. Then, type
      S
      (SELECT) next to the new member and press Enter to select it for processing.
    The Edit Parmlib SETUP Member Site Options 1 panel (INSEDSET) appears.
    In the following steps, the parameter name for the fields is included in parentheses. This value is used for the field value in the SETUP parmlib member in
    hlq
    .CDBAPARM.
  5. Specify the following values to define site-specific settings:
    • Company Name (COMPANY)
    • Work Unit Name (WORKUNIT)
    • Display All Products (FULLMENU)
    • Assembler Name (ASSEMBLR)
    • Use Global Default Process (DEFAULTS)
    • Alternate Catalog Mapping Check (ACMCHECK)
    • Long Name Truncation Symbol (LONG_NAME)
    • Xmanager Connection Identifier (XMANID)
    • Service Desk Interface (SDI)
    • Prompt for DECP Module Name (DECPROMPT)
    • DB2 Connection Type (CONNECT)
    Press Enter.
    The settings are saved and the Edit Parmlib SETUP Member Site Options 2 panel (INSEDSE1) appears.
  6. Specify the following national language settings site options:
    • Vertical bar character (VERTBAR)
    • Decimal point character (DECPOINT)
    • Mixed DBCS/SBCS data (CASEMIX)
    • Date format (DATEFORM)
    • Time delimiter (TIMEFORM)
    • Display seconds (TIMEFORM)
    Press Enter.
    The settings are saved and the Edit Parmlib SETUP Member SSID List panel (INSEDSE2) appears. The subsystems are shown by subsystem ID, Db2 version, messages if applicable, a subsystem description, and data sharing groups. To view a list of data sharing groups, type
    G
    or
    GRP
    in the View field and press Enter. The Edit Parmlib SETUP Member DS Group List panel (INSEDSG2) appears. Go to Step 8.
    To find or locate a relevant subsystem ID quickly when many Db2 subsystems are displayed, use the find or locate commands (
    F|L
    ssid
    ). To sort the columns in ascending (default) or descending order on the panel, use the
    SORT
    command with the column identifier (
    S
    for SSID,
    V
    for Version,
    M
    for Message,
    D
    for Description, or
    G
    for data sharing group) followed by
    A
    (ascending) or
    D
    (descending). For example,
    SORT S A
    or
    SORT S
    sorts the SSID column in ascending order.
    SORT V D
    sorts the Version column in descending order. To restore the original order on the panel, specify
    SORT
    without any sub parameters. For more information about these commands, see the online help.
  7. Complete
    one
    of the following steps to select a Db2 subsystem for processing:
    • Type
      S
      next to an existing Db2 subsystem to select it for processing.
      You can also delete (D) or replicate (R) an existing entry.
    • Type
      I
      to insert a new subsystem in the SETUP member and press Enter. Specify the Db2 subsystem ID in the SSID field and press Enter. Then, type
      S
      next to the subsystem to select it for processing.
    Press Enter.
    The Edit Parmlib SETUP Member Db2 Options panel (INSEDSE3) appears. Go to Step 9 to specify the subsystem values.
  8. Complete the following steps to select a data sharing group for processing:
    1. Type
      G
      or
      GRP
      in the View field on the Edit Parmlib SETUP Member SSID List panel (INSEDSE2) and press Enter.
      The Edit Parmlib SETUP Member DS Group List panel (INSEDSG2) appears. The data sharing groups are shown by:
      • Data sharing group name or by subsystem ID for non-data sharing group subsystem IDs
      • Number of members in the data sharing group or N/A for non-data sharing group subsystem IDs
      • Db2 version
      • Db2 catalog level
      • Messages, if any, about the data sharing group
      To find a relevant data sharing group quickly when many groups are displayed, use the find command (
      F
      grp
      ). To sort the columns in ascending (default) or descending order on the panel, use the
      SORT
      command with the column identifier (
      S
      for SSID/Grp,
      N
      for Number,
      V
      for Version,
      C
      for Catalog, or
      M
      for Messages) followed by
      A
      (ascending) or
      D
      (descending). For example,
      SORT S A
      or
      SORT S
      sorts the SSID/Grp column in ascending order.
      SORT N D
      sorts the Number column in descending order. To restore the original order on the panel, specify
      SORT
      without any sub parameters. For more information about these commands, see the online help.
    2. Type
      S
      next to a data sharing group to select it for processing and press Enter.
      The Edit Parmlib SETUP Member Group Options panel (INSEDSG3) appears.
    3. Edit the following data sharing group options for all data sharing group members:
      • Db2 12 Function Level (SSIDVERF) and Catalog Level (SSIDVERC) or Db2 11 Version (SSIDVER) and Db2 11 Mode (SSIDMODE).
      • VSAM Catalog Alias (CATALIAS)
      • STOGROUP Name (STOGROUP) and Volume (STOGRPV)
      • Database Name (DATABASE)
      • Bind Owner (PLANOWN)
      • Tablespace BUFFERPOOL 4KB (SSBP4KKTS), 8KB (SSBP8K), 16KB (SSBP16K), and 32KB (SSBP32K)
      • Index BUFFERPOOL (SSBP4KIX)
      • DEFINE (TS and IX) (SSDEFINE)
      • CLOSE (TS and IX) (SSCLOSE)
      • COMPRESS TABLESPACE (SSCOMPTS)
      Press Enter.
      The group values are updated on all subsystems that are members of the data sharing group.
      The data sharing group members are displayed in the Group Members field.
    4. Type End to return to the Edit Parmlib SETUP Member DS Group List panel (INSEDSG2).
    5. Complete
      one
      of the following steps:
      • Repeat steps 8b through 8d to edit another data sharing group.
      • Type
        S
        or
        SSID
        in the View field and press Enter to return to the Edit Parmlib SETUP Member SSID List panel (INSEDSE2). Go to Step 7.
      • Press the End key. The Edit Parmlib SETUP Member Site Options 2 panel appears (INSEDSE1). Go to Step 6.
  9. Specify the following Db2 options:
    • DB2 Subsystem (SSID)
    • DB2 Subsystem Description (SSIDDESC)
    • DB2 Version:
      • For Db2 12: Function Level (SSIDVERF) and Catalog Level (SSIDVERC)
      • For Db2 11: Version (SSIDVER) and Mode (SSIDMODE)
      The Db2 12 and Db2 11 values are mutually exclusive.
    • VSAM Catalog Alias (CATALIAS)
    • DB2 Load Libraries (LOADLIBS)
      These libraries must be APF-authorized. READ access is required for product users.
    • BSDS01 Dataset and BSDS02 Dataset (BSDS)
    • DB2 ZPARM Library (ZPARMLIB) (READ access is required for product users)
    • DB2 ZPARM Member (ZPARMMEM)
    • Install SYSADM (SYSADM)
    • Install SYSADM2 (SYSADM2)
    Press Enter to continue.
    The next Edit Parmlib SETUP Member PTDB Options panel (INSEDSE4) appears.
  10. Specify the following PTDB options:
    • STOGROUP Name (STOGROUP) (PTSG is the default name)★
    • STOGROUP Volume (STOGRPV)
    • Database Name (DATABASE) (PTDB is the default name)★
      ★ For
      Recovery Analyzer
      , if you use non-default names for the storage group and database names, the customized values must be put in the SETUP member for the target Db2 subsystem before running PRA#LOAD. The default names are PTSG and PTDB, respectively.
    • Bind Owner (PLANOWN)
    • Data Sharing Group Name (DSGROUP)
      In a data sharing environment, use this field to define the Db2 subsystem member names, group attachment names, or subgroup attachment names with the data sharing group name in each SETUP xx parmlib member. Doing so ensures that the CA Database Management Solutions for Db2 for z/OS can access information from all Db2 subsystems within the data sharing group. Use the same VSAM catalog alias for each subsystem and unique boot strap data sets for each member subsystem.
      In coexistence mode (Db2 11 NFM with V12R1M100), the group attachment name or subgroup attachment name must point to the highest Db2 version in the data sharing group. It must also include a concatenation of load libraries from all releases in the Db2 Load Libraries (LOADLIBS) parameter.
    Press Enter to continue.
    The Edit Parmlib Member SETUP TS/IX Options panel (INSEDSE6) appears.
  11. Specify the following Db2 catalog values:
    • Tablespace BUFFERPOOL:
      • 4 KB (SSBP4KTS)
      • 8 KB (SSBP8K)
      • 16 KB (SSBP16K)
      • 32 KB (SSBP32K)
    • Index BUFFERPOOL (SSBP4KIX)
    • DEFINE (TS and IX) (SSDEFINE)
    • CLOSE (TS and IX) (SSCLOSE)
    • COMPRESS Tablespace (SSCOMPTS)
    Press Enter to continue.
    The Edit Parmlib SETUP Member QMF Options panel (INSEDS4A) appears.
  12. Specify the following QMF values if applicable:
    • DRDA Remote Binds (SSREMOTE)
    • (Optional) QMF Plan Name (QMFPLAN)
    • (Optional) QMF Version (QMFVER)
    • (Optional) QMF Prefix (QMFPRE)
    • (Optional) DECP Module Name (DSNHDECP)
    • XML column default value (XMLDEFVL)
    Press Enter to continue.
    The Edit Parmlib SETUP Member Locations panel (INSEDSE5) appears.
  13. Specify the following values to create the remote location list:
    • Location (LOCATION | DRDALOC)
      This value must be unique and must match the value that is entered in the LOCATION column of the SYSIBM.LOCATIONS table.
    • Location Subsystem ID (LOCSSID)
      Required only for z/OS locations.
    • Location Type (Panel Only)
      Indicates whether the Db2 subsystem is running on z/OS (ZOS) or a remote DBMS system that supports DRDA access (DRDA). This column determines whether the parameter name for the DDF location of the subsystem uses LOCATION or DRDALOC in the SETUP parmlib member in
      hlq
      .CDBAPARM.
    Press Enter to save your entries. The Locations list is updated.
  14. Press the End key (F3) until you return to the Create/Edit Parmlib Members Selection panel (INSEDPR2).
    The SETUP global parmlib member is created and appears in the member list. A message indicates that the SETUPxx member has been successfully updated.
  15. Press the End key again to return to the Create/Edit Parmlib Members panel (INSEDPRM).