Purpose
Specifies the amount of time (in minutes) between collections of object use-count data. The system updates the Data Dictionary table DBC.ObjectUsage with this data. This table allows you to find the use count and last access timestamps of any of the following database objects:
- Columns
- Databases
- Indexes
- Macros
- Stored Procedures
- Tables
- Triggers
- UDFs
- Users
- Views
Field Group
General
Valid Settings
| IF you set this field to… | THEN… |
|---|---|
| an integer between 1 and 32767 | the Data Dictionary is updated with collected object use count data at an interval (in minutes) based on the set value. If you specify a decimal value, DBS Control ignores the fractional part and uses only the integer part. For example, if you specify 12.34, DBS Control uses 12 for the field value and ignores .34. The recommended minimum value is 10 minutes. Any rate below 10 minutes severely impacts performance.
|
| a value higher than 32767 | DBS Control displays a warning message. |
| a negative value | DBS Control displays an error message. |
Default
10 minutes
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
If you are performing an archive/recovery operation for Data Dictionary tables, the system may disable ObjectUseCountCollectRate if it experiences any contention or locking.
Use the DBQL BEGIN/END QUERY LOGGING statements to control object use count logging on an individual database basis.
Related Topics
| For more information on… | See… |
|---|---|
| the object use count Data Dictionary columns | Data Dictionary |
| resetting the object use count Data Dictionary columns | Database Administration |
| the DBQL BEGIN/END QUERY LOGGING statements | SQL Data Definition Language |