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


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
Online/background conversions, upgrade
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