Updating and sampling of catalog statistics for DB2 tablespace

The DB2 RUNSTAT utility records the details of tablespace, table, index, etc in the system catalog. The RUNSTAT generates the data like space available in table space, indexes, access paths, etc. We can use the below JCL step to update the catalog statistics of DB2 tablespace TABSPAC2 and to sample 25% of the rows.

//STEP1 EXEC DSNUPROC
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RUNSTATS TABLESPACE DBSET1.TABSPAC1
   TABLE(ALL) SAMPLE 25
   INDEX(ALL)

The SYSIN parameter can be used with RUNSTATS TABLESPACE statement followed by tablespace name qualified by database name.

Mandalika

Published on 12-Sep-2020 15:12:49

• Related Questions & Answers
• How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
• How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
• How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
• Reservoir Sampling
• How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
• Different Types of Sampling Techniques
• Give the panel command to start a specific tablespace within a DB2 database.
• Updating MongoDB collection for _id?
• Difference between Data Mining and Statistics?
• What are Sampling-Based Approaches?
• Checking savepoint statistics of SAP HANA
• Investigation of root cause and resource responsible for the deadlock in DB2
• Example and usage of JOINS in DB2
• Getting statistics details of SAP HANA system
• Use of Statistics service in SAP HANA