17.00 - 17.05 - Resetting Use Counts - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

When you enable query logging for a database, system and user use counts and timestamps are reset. However, when you disable query logging, only system counts and timestamps are reset. User use counts and timestamps are not reset. To reset them, use these macros:

This macro... Resets...
ClearAllDatabaseUseCount AccessCount and LastTimeStamp for all objects in the system.
ClearDatabaseUseCount AccessCount and LastTimeStamp of objects in a specified database.
ClearTVMUseCount the AccessCount and LastAccessTimeStamp for all of the objects in a specified table, view, macro, trigger, stored procedure, join index, user-defined type, user-defined method, or user-defined function.
ClearUserUseCount all access counts (excluding statistics) for a particular user.
ClearUserStatCount all statistics counts for a particular user.
ClearUserUDICount all update, delete, and insert counts for a particular user.
You must have the EXECUTE privilege on the macros to use them.

To create these macros, check if the DIP utility script DIPVIEWSV has run. If not, run DIPVIEWSV.

All SQL statements used by the ClearDatabaseUseCount macros place write locks on the database objects involved.

Examples of Resetting Use Counts

TO reset the AccessCount and LastAccessTimeStamp fields for… USE the following syntax…
the table tab1 Exec DBC.ClearTVMUseCount('db1', 'tab1');

Specify the databasename and the tablename in apostrophes, separated by a comma.

the database db2 Exec DBC.ClearDatabaseUseCount('db2');

Specify databasename in apostrophes.

all the objects in the system Exec DBC.ClearAllDatabaseUseCount;