How to check the table range partitioning in a TDW database ?
cookcm 100000MK5C Comment (1) Visits (7932)
ITM 6.3.0 introduces Tivoli Data Warehouse significant improvements in pruning and querying large Tivoli Data Warehouse databases by allowing to partition database tables. Range partitioning permits the fast roll out of data without having to perform a resource intensive DELETE operation on blocks of rows. Range partitioning also improves query performance when the partitioning key is part of the query clause. Performance is improved because the database can discard unnecessary partitions from the list of blocks that must be fetched from disk.
ITM TDW provides configuration settings to allow the table range partitioning, the compression of the data and the possibility to provide a default container for all ITM tables and or all ITM indices.
"How to check the table range partitioning status in a TDW database ?" is a document that describes which environment variables corresponds to each configuration settings and also gives you sample SQL queries to check the status of a database table and index for the 3 database types supported by Tivoli Data Warehouse : IBM DB2 Linux and Windows, IBM DB2 ZOS and Oracle
The queries describe :