SAP Parameter dbs/db6/statistics_store - Decision what kind of DB statistics data to store for DB2 (for AIX)

Parameter
dbs/db6/statistics_store

Short text
Decision on what kind of DB statistics data to store

Parameter description
For DB2 for AIX, the retention of database statistics before thedeletion of tables is controlled by parameter dbs/db6/statistics_store.The default value for the parameter is 'tci'. 't' stands for tables, 'c'for columns, and 'i' for indexes. If the parameter is set to tci, thestatistics of the object set by the value are updated when the tables orindexes are deleted.
Examples: tci: Statistics for tables, columns, and indexes
tc: Statistics for tables and columns
ti: Statistics for tables and indexes

Work area
Database
Online/background conversions, upgrade
tci
SAP or customer as directed by SAP
-
DB2 only (for AIX)
Related: dbs/db6/statistics_restore Only the statistics data that couldbe saved by an active dbs/db6/statistics_store can be restored.
The letters 't', 'c', and 'i' are interpreted as information. Othercharacters are ignored. Maximum length that can be interpreted: 3