Milestone 7: Db2 Customization

This milestone explains how to specify input settings used to create the ISPW Db2 environment. It should be performed for both new installations and upgrades so that the values specified are saved for future upgrades.

Task 7.1 Enter Db2 Subsystem Information

1. On the ISPW Guided Configuration dialog main menu (Guided Configuration Dialog Main Menu), type 3 (Configure DB2 Environment) in the Option field and press Enter. The ISPW DB2 Configuration screen is displayed.ISPW DB2 Configuration Screen

   
   

   

2. The values to be entered in the DB2 Subsystem Information section of the ISPW DB2 Configuration screen were chosen during Milestone 3: Prepare Db2 Repository. Type those values in the appropriate fields as follows:
   1. In the DB2 Subsystem field, enter the subsystem name where ISPW will be installed. (This corresponds to the variable DB2SYS in 17.02 installations.)
   2. In the VCAT name field, enter the catalog name to be used for the ISPW storage group if one is to be created. (This corresponds to the variable VCAT in 17.02 installations.)
   3. In the DB2 Plan Name field, enter the name of the batch SQL plan (for example, DSNTEP2) that will be invoked by the program you will specify for DB2 Program Name in the next step. (This corresponds to the variable DB2BPLAN in 17.02 installations.)
   4. In the DB2 Program Name field, enter the name of the batch SQL program (for example, DSNTEP2) that is used at your site. (This corresponds to the variable DB2BPROG in 17.02 installations.)
   5. In the DB2 Load Library field, enter the dataset name of your Db2 load library. (This corresponds to the variable DB2LOAD in 17.02 installations.)

   6. In the DB2 Exit Library field, enter the dataset name of your Db2 exit library. (This corresponds to the variable DB2EXIT in 17.02 installations.)

      Important

      If you don't have an EXIT library, enter the same value for the DB2EXIT and DB2LOAD parameters.

   7. In the DB2 RUNLIB Library field, enter the dataset name of your Db2 runtime library. (This corresponds to the variable DB2RLIB in 17.02 installations.)

Task 7.2 Enter ISPW Db2 Names, Sizing, and Image Copy Values

1. The values to be entered in the ISPW DB2 Names section of the ISPW DB2 Configuration screen were chosen during Plan an Authorization Strategy and Develop Db2 ISPW Naming Standard. Type those values in the appropriate fields as follows:
   1. In the ISPW AuthID field, enter the authorized ID under which the installation of ISPW be performed. (This corresponds to the variable SYSAUTH in 17.02 installations.)
   2. In the Repository AuthID field, enter the authorized ID that will be assigned to the ISPW repository owner. (This corresponds to the variable WZAUTH in 17.02 installations.)
   3. In the Maintenance AuthID field, enter the authorized ID that will be assigned to the user performing ISPW maintenance tasks. (This corresponds to the variable WZMAUTH in 17.02 installations.)
   4. In the Database Name field, enter the name of the ISPW database. (This corresponds to the variable DBNAME in 17.02 installations.)
   5. In the Tablespace Name field, enter the prefix of the ISPW tablespace name. (This corresponds to the variable TS in 17.02 installations.)
   6. In the Index Name field, enter the prefix of the ISPW index name. (This corresponds to the variable IX in 17.02 installations.)
   7. In the Plan Name field, enter the ISPW Db2 plan name. (This corresponds to the variable PLNAME in 17.02 installations.)
   8. In the Collection Name field, enter the Db2 collection name.(This corresponds to the variable COLLID in 17.02 installations.)
   9. In the Storage Group field, enter the storage group name.(This corresponds to the variable SGNAME in 17.02 installations.)
2. The values to be entered in the Sizing section of the ISPW DB2 Configuration screen were chosen during Develop Db2 ISPW Naming Standard and Planning for Other Items. Type those values in the appropriate fields as follows:

   1. In the Tablespace Bufferpool field, enter name of the bufferpool(s) that the ISPW repository tablespaces will use. (This corresponds to the variable BPTBSP in 17.02 installations.)

      Important

      All 

      ISPW

       tablespaces have a 4K page size.

   2. In the Index Bufferpool field, enter the name of the bufferpool(s) that the ISPW repository indexes will use. (This corresponds to the variable BPINDEX in 17.02 installations.)
   3. In the Repository Size field, enter the desired size of SML (small), MED (medium), LRG (large), or SYS (System Determined Size) for the Db2 Repository. An appropriate value for your site can be determined in Db2 Repository Sizes. (This corresponds to the variable SIZE in 17.02 installations.)
3. The value to be entered in the Image Copy section of the ISPW DB2 Configuration screen was chosen during the Develop Db2 ISPW Naming Standard task in Milestone-3-Prepare-Db2-Repository. In the Image Copy Prefix field, enter the name with which to supplement the Db2 database and tablespace names. (This corresponds to the variable <ICMSKPRF> in 17.02 installations.)
4. Type END in the Option field and press Enter (or press PF3) to save your values. The main menu for the ISPW Guided Configuration dialog is displayed in the Guided Configuration Dialog Main Menu in Milestone-5-Create-Configuration-Environment.