Volume Statistics (RAVL_STATS_xxxx)

The RAVL_STATS_xxxx table contains statistics that are collected at the DASD volume level.
cadadb220
The RAVL_STATS_xxxx table contains statistics that are collected at the DASD volume level.
Each collection date contains rows per volume, as follows:
  • One row for each unpartitioned tablespace or index
  • One row per volume for each partition of a tablespace or index
The RAVL_STATS_xxxx table has the following indexes:
Index Name
U =Unique
N =Nonunique
Indexed Columns
RAVL_IX_xxxx
N
RAVL_TYPE, RAVL_SYSID, RAVL_CREATOR, RAVL_OBJECT, RAVL_PART
RAVL_IX2_xxxx
N
RAVL_TIMESTAMP_D
RAVL_IX3_xxxx
N
RAVL_TYPE, RAVL_SYSID, RAVL_CREATOR, RAVL_TSNAME, RAVL_PART
The RAVL_STATS_xxxx table has the following fields:
Column Name
Type
Description
RAVL_COLLECT_TYPE
CHAR(1)
Type of statistics collection (R, F, S, U, blank)
RAVL_CREATOR
CHAR(8)
Object creator (or database name if the row represents tablespace information)
RAVL_DBNAME
CHAR(8)
Database name of object
RAVL_DSID
SMALLINT
Data set name (if object has multiple data sets)
RAVL_EXTALLOC
SMALLINT
Number of extents still available
RAVL_EXTENTS
SMALLINT
Number of extents
RAVL_FREESPACE
INTEGER
Total free space in object (in KB)
RAVL_INSTANCE
SMALLINT
Data set name instance number for the tablespace/index on the current base table
RAVL_MAINT_ACTION
CHAR(1)
The RTOS Extract Maint Action that was selected when defining the extract:
  • R -- Reorg
  • S -- Statistics
  • C -- Copy
  • F -- Full Image Copy
  • I -- Incremental Image Copy
  • D -- User-Defined
  • U -- Unknown. The statistics rows were created before Version 18.0.00 or the statistics rows were created from a Classic Mode=Name Extract.
RAVL_OBJECT
CHAR(18)
Object name
RAVL_PAGE_TRK
SMALLINT
Number of Db2 pages per track (in 4-KB pages)
RAVL_PART
SMALLINT
Partition number (if applicable)
RAVL_PQTY
INTEGER
PRIQTY allocated (in 4-KB pages)
RAVL_PQTY_USED
INTEGER
PRIQTY used (in 4-KB pages)
RAVL_SELECTED_CONDN
SMALLINT
Internal use only
RAVL_SQTY
INTEGER
SECQTY allocated (in 4-KB pages)
RAVL_SQTY_ALLOC
INTEGER
SECQTY allocation amount
RAVL_SQTY_USED
INTEGER
SECQTY used (in 4-KB pages)
RAVL_STATUS
CHAR(1)
Reserved
RAVL_SYSID
CHAR(4)
Db2 system ID of object
RAVL_TIMESTAMP_D
TIMESTAMP
Db2 timestamp of the statistics collection
RAVL_TSNAME
CHAR(8)
Tablespace name
RAVL_TYPE
CHAR(2)
Object type (TS or IX)
RAVL_TYPE
CHAR(1)
Used for collection type during extract
RAVL_UPDATE_DB2CAT
SMALLINT
Internal use only
RAVL_UPDPAGE
INTEGER
Total number of updated pages
RAVL_UTILITY_EXECUTED
CHAR(1)
Internal use only
RAVL_VERSION
SMALLINT
CA Database Analyzer™ for DB2 for z/OS
version that generated this statistic row, in
vvrmm
format (example: 02601=2.6.1)
RAVL_VOLSER
CHAR(6)
DASD volume serial number