Collection Services

Collection Services consists of extract procedures, object selection profiles (OSPs), and the Statistics Maintenance Facility (SMF).
cadadb220
Collection Services consists of extract procedures, object selection profiles (OSPs), and the Statistics Maintenance Facility (SMF).
Extract procedures specify which objects to process. An extract procedure can access any combination of databases, tablespaces, indexspaces, and tables residing on the same Db2 subsystem. The databases do not have to be started because native VSAM I/O is used to access them. However, the Db2 subsystem that contains the
Database Analyzer
statistics tables must be active during statistics collection.
An OSP limits the objects that the RTOS extract procedure processes.
SMF lets you maintain and manage your
Database Analyzer
statistics tables. Use SMF to back up, delete, and restore product statistics for the Db2 objects in your system. SMF can also look for missing rows and values in the Real-Time Statistics (RTS) tables.