Default language.

Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.
Space announcement To view the latest version of the product documentation, select the version from the Product version menu above the navigation pane.

Milestone 7: Db2 Customization

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

Important

  • Roles involved:
    • Code Pipeline Installer
    • Db2 DBA
  • If upgrading, check DDL member WZZ#PLAN to make sure it contains DYNAMICRULES(BIND).

Task 7.1 Enter Db2 Subsystem Information

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

    -------------------- Code Pipeline Db2 Configuration -------------------------
    Option  ===>                                                                  
                                                                                 
    Enter END to Save or CAN to Cancel updates.                                  
                                                                  More:     +    
                                                                                 
           Db2 Subsystem Information:                                            
           Db2 Subsystem   :  DSN1                                               
                                                                                 
           VCAT name       :  DSN1____                                               
                                                                                 
           Db2 Plan Name   :  DSNTEP2_                                            
           Db2 Program Name:  DSNTEP2_                                            
                                                                                 
           Db2 Load Library  :  DSN910.SDSNLOAD______________________________    
           Db2 Exit Library  :  DSN910.SDSNEXIT______________________________    
           Db2 RUNLIB Library:  DSN910.RUNLIB.LOAD___________________________                               
                                                                                 
           Code Pipeline Db2 Names:                                              
           Install Authid    :  SYSADM__                                           
           Repository AuthID :  WZZT180_                                          
           Maintenance AuthID:  WZMT180_                                          
                                                                                 
           Database Name  :  WZZT180_                                             
           Tablespace Name:  TST_                                                 
           Index Name     :  IXT_                                                 
                                                                                 
           Plan Name      :  WZZT180_                                             
           Collection Name:  WZZ180CO_______                                            
                                                                                 
           Storage Group:  WZSGT___                                                 
                                                                                 
           Sizing:                                                               
           Tablespace Bufferpool:  BP1___                                           
           Index Bufferpool     :  BP1___                                           
                                                                                 
           Repository Size:  SYS   (SYS, SML, MED, LRG)                          
                                                                                 
           Image Copy:                                                           
           Image Copy Prefix:  DSN1.IMAGCOPY                                                                                              
  2. The values to be entered in the DB2 Subsystem Information section of the Code Pipeline 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 Code Pipeline 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 Code Pipeline 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 data set 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 data set 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 data set name of your Db2 runtime library. (This corresponds to the variable DB2RLIB in 17.02 installations.)

Task 7.2 Enter Code Pipeline Db2 names, sizing, and image copy values

  1. The values to be entered in the Code Pipeline Db2 Names section of the Code Pipeline Db2 Configuration screen were chosen during Plan an Authorization Strategy and Develop Db2 Code Pipeline Naming Standard. Type those values in the appropriate fields as follows:
    1. In the Code Pipeline AuthID field, enter the authorized ID under which the installation of Code Pipeline 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 Code Pipeline 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 Code Pipeline maintenance tasks. (This corresponds to the variable WZMAUTH in 17.02 installations.)
    4. In the Database Name field, enter the name of the Code Pipeline database. (This corresponds to the variable DBNAME in 17.02 installations.)
    5. In the Tablespace Name field, enter the prefix of the Code Pipeline tablespace name. (This corresponds to the variable TS in 17.02 installations.)
    6. In the Index Name field, enter the prefix of the Code Pipeline index name. (This corresponds to the variable IX in 17.02 installations.)
    7. In the Plan Name field, enter the Code Pipeline 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 Code Pipeline Db2 Configuration screen were chosen during Develop Db2 Code Pipeline 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 Code Pipeline repository tablespaces will use. (This corresponds to the variable BPTBSP in 17.02 installations.)

      Important

      All 

      Code Pipeline

       tablespaces have a 4K page size.

    2. In the Index Bufferpool field, enter the name of the bufferpool(s) that the Code Pipeline 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 Code Pipeline Db2 Configuration screen was chosen during the Develop Db2 Code Pipeline 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 Code Pipeline Guided Configuration dialog is displayed in the Guided Configuration Dialog Main Menu in Milestone-5-Create-Configuration-Environment.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*