Starting Your Product › How to Configure Without CA CSM › Configuring Host Encyclopedia and Host Construction › Establish the Environment › Tasks to Define Installation Variables › Set DB2 Variables

Set DB2 Variables

Use this option to capture the global values required for building DB2 tables and running DB2 utilities.

Follow these steps:

1. Select option 6 on the Installation variables management screen and press Enter.
2. The Set DB2 variables screen displays.

   

3. Complete the fields on the Set DB2 Variables screen based on the following considerations and according to the information gathered in your site variables configuration.
   • The following fields on the Set DB2 Variables screen are blank unless you are using an existing TILPARMS member:
     • Secondary Authorization ID
     • Bind Qualifier and DB2 Table-Index-View Owner
     • DB2 Collection ID
     • Schema DB name
     • Data DB name
     • Public Interface DB name

     Note: Secondary Authorization ID and Bind Qualifier and DB2 Table-Index-View Owner fields are optional. If entered, they must exist as valid AuthIDs or Group IDs in the security system.

   • DB2 Host Encyclopedia DDL uses Secondary Authorization ID in the SET CURRENT SQLID = 'xxxxxxx'; and it is passed to the DB2 Bind process through the OWNER parameter. For example:

     BINDPACK MEMBER(ALL) ... OWNER(xxxxxxx)

   • Bind Qualifier and DB2 Table-Index-View Owner identifier is used to prefix names of Tables, Indexes, and Views and is passed to the DB2 Bind process in the QUALIFIER variable. For example:

     CREATE TABLE xxxxx.DOBJ

     BINDPACK MEMBER(ALL) ... QUALIFIER(xxxxx)

     Where xxxxx is the DB2 Bind Qualifier and DB2 Table-Index-View

     Important! If this is an existing installation, values for Bind Qualifier and DB2 Table-Index-View Owner field must be set to the same value as in the current installation.

   • The Host Install Package bind uses the DB2 Collection ID. For example:

     BINDPACK MEMBER(ALL) ... COLLID(xxxxx)

     Where xxxxxx is the DB2 Collection ID

   • The Gen Runtime Collection ID is used to perform a package bind on runtime DBRMs TIRPROFD and TIROLBCM before CA Gen applications use the collection. For example:

     BINDPKRT MEMBER(ALL) COLLID(xxxxxxxx)

     Where xxxxxxxx is the Gen Runtime Collection ID

   • If the Data set Storage Type is S for Storage Group, the maximum and minimum space values are checked to ensure compliance with DB2 rules.
   • For assistance in choosing the size of the initial Host Encyclopedia, see Sizing an Encyclopedia.

     Important! If this is an existing instillation, the values for Data set Storage Type, Initial Data Base Size, or Secondary Storage Factor are stored in TILTAB50 and used to create space values. If you change the values in these fields, TILTAB50 is deleted and your values are lost. For more information on the tasks to complete before changing these values, see the section TILTAB50 in this section.

4. Press F2 to verify and save the values in a working copy of the user's ISPF profile pool.
5. When the verification is complete, press Enter to exit the Activity Display screen.
6. Press F3 to exit the screen.