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.
//*********************************************************************
//* 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) ;