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 11: Install Db2 Repository

This milestone installs the Code Pipeline Db2 repository.

Important

Roles involved: Code Pipeline Installer Db2 DBA

Task 11.1 Run Db2 installation jobs

Warning

Do not proceed until the tasks in Milestone-9-Create-Base-Datasets for options 1 through 5 have all been completed. If those five tasks have not been completed, the Db2 installation jobs will fail and the database will have to be deleted (using $WZD9DRP in the SPWMINST library) and re-installed.

  1. On the Code Pipeline Guided Configuration Dialog Main Menu, type 7 (DB2 Install Tasks) in the Option field and press Enter. The Execute DB2 Repository Installation Tasks screen is displayed.Execute DB2 Repository Installation Tasks screen

    ------------- Execute Db2 Repository Installation Tasks ---------------------
    Option ===>                                                                  
                                                                                
                                                                                
                                                                                
        These steps follow the Install Guide's section entitled                  
                     Install Db2 Repository.                                     
                                                                                
                    1. Create Code Pipeline Db2 Storage Group and Database      
                                                                                
                    2. Create Code Pipeline Db2 Tablespaces                     
                                                                                
                    3. Create Code Pipeline Db2 Tables and Indexes              
                                                                                
                    4. Update Db2 Catalog Statistics(RUNSTATS)                  
                                                                                
                    5. BIND Code Pipeline Plan and Execute Grants               
                                                                                
                    6. BIND all Code Pipeline Packages                          
                                                                                
                    7. Load Initial Data into Code Pipeline Database            
                                                                                
                    8. Create Db2 Image Copies of Code Pipeline Database        


    Warning

    If you are upgrading and using an existing repository, skip all options except 5 and 6.

  2. On the Execute DB2 Repository Installation Tasks screen, perform steps 1 through 7 in order by typing the corresponding number in the Option field and pressing Enter. Step 8 is optional, but recommended.
    For each step, information input previously is used to generate the $WZD jobs. An ISPF edit session is opened for each job. Review the job to verify everything is as desired, then submit the job and continue by entering the next option. The following table provides a brief description of each job, along with expected return codes.

    Important

    Option 4 (job $WZD4RST) will need to be re-run after the tables have been populated with data, either via a conversion process or through normal Code Pipeline usage.

Db2 installation jobs

Option
Number

Job Name

Description

Jobstep
Name

Expected
RC

Done?

1

$WZD1INS

Creates Storage Group, Database, and grants database authorities to the Code Pipeline AuthID.

Step 1

0


Step 2

0


2

$WZD2TBS

Creates the tablespaces.

Step 1

0


3

$WZD3TBI

Creates the tables and indexes.

Step 1

0


4

$WZD4RST

Updates catalog statistics using RUNSTATS utility.

Step 1

0


5

$WZD5PLN

Binds the plan and grants execute authority on it to the Code Pipeline Server.

Step 1

0


Step 2

0


6

$WZD6PKG

Binds the packages.

Step 1

0


7

$WZD7LOD

Inserts required initial repository data.

Step 1

0


Step 2

0


8

$WZD8CPY

Image copies the Code Pipeline repository.

Step 1

0


 

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