Analysis of DB2 table statistics (1)

This article will introduce you to the description of how to collect statistics on various types of tables in the DB2 database for your reference. If you are interested in this, please take a look and I believe it will help you.

DB2 provides three command tools to reorganize and analyze table data:
REORGCHK
REORG
RUNSTAT

The statistical information of objects is collected in (1). Here, the statistical information can be used to diagnose the physical storage of objects.

2. REORGCHK: physical storage of diagnostic objects

>-REORGCHK ---- + ------------------------------- + ------------------------------------ + <
|-UPDATE -- |.-USER -------. -- |
'-- +-CURRENT-+ --- STATISTICS -- ''-on table -- +-SYSTEM ----- + --'
+-ALL -------- +
'-Table-name -'

The on schema option is added to the V8 version of UDB.

Update statistics: Call RUNSTATS to analyze the table,
Then, the system diagnoses whether to reorganize the table based on the statistical information.
Current statistics: Use existing STATISTICS to diagnose whether to reorganize the table

On table user: All Tables of the current USER
On table system: All Tables of SYSTEM
On table all: ALL Tables of the current db
On table table-name: table with the specified name