Optimizing the performance of your DB2 for z/OS database

To optimize the DB2® for z/OS® database performance, you can use the RUNSTATS utility after you have completed the installation of WSRR. The following topic provides instructions to optimize the performance of your DB2 database.

About this task

If you do not run this process, it can cause a serious degradation of performance in some cases.

Procedure

The following JCL will run the RUNSTATS utility:

//*********************************************************************
//*  Description                                                       
//*    WebSphere Service Registry and Repository                       
//*    Run the DB2 RUNSTATS utility against the WSRR database          
//*                                                                    
//*  Notes =                                                           
//*    Prior to running this job, customize it for your system:        
//*    (1) Add a valid job card                                        
//*    (2) Locate and change all occurrences of the following strings  
//*        as indicated:                                               
//*        @DSNPFX@       to the DB2 library prefix                    
//*        @SSID@         to the DB2 subsystem id                      
//*        @WSRR_DB_NAME@ to the Name of your WSRR database            
//*        @ACT_DB_NAME@  to the Name of your ACT  database            
//*        @SIB_DB_NAME@  to the Name of your SIB  database            
//*********************************************************************
//DSNUTILB EXEC PGM=DSNUTILB,REGION=0M,                                
//         PARM='@SSID@,RNSTWSRR,'                                     
//STEPLIB  DD DISP=SHR,DSN=@DSNPFX@.SDSNEXIT                           
//         DD DISP=SHR,DSN=@DSNPFX@.SDSNLOAD                           
//         DD DISP=SHR,DSN=@DSNPFX@.RUNLIB.LOAD                        
//SYSPRINT DD SYSOUT=*                                                 
//UTPRINT  DD SYSOUT=*                                                 
//SYSUDUMP DD SYSOUT=*                                                 
//SYSIN    DD *                                                        
LISTDEF WSRR INCLUDE TABLESPACE @WSRR_DB_NAME@.* PARTLEVEL BASE        
LISTDEF ACT  INCLUDE TABLESPACE @ACT_DB_NAME@.*  PARTLEVEL BASE        
LISTDEF SIB  INCLUDE TABLESPACE @SIB_DB_NAME@.*  PARTLEVEL BASE        
RUNSTATS TABLESPACE LIST WSRR TABLE(ALL) INDEX(ALL) ;

Note: Repeat this task if there any large changes to your data content; for example, if you do either of the following:

Activate a different configuration profile.
Import data into your registry.