Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 22 Aug 2007 @ 19:41:57 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Controlling the activity count column
From:   Durst, James

To count the number of times the system accesses objects, enable the ObjectUseCountCollectRate field in the DBS Control Utility. The system will then populate the AccessCount and LastAccessTimeStamp fields of the data dictionary

To enable LastAccessTimeStamp, you must set the DBSControl: General field- 30) Object Use Count Collect Rate

30. Object Use Count Collect Rate - Determines the default amount of time which the Data Dictionary columns of database object AccessCount and LastAccess Time Stamp are reset automatically. The default is 0, which disables the database object use count feature. To enable, the recommended value is 10 minutes.

Reference article: >>>>> NTA946

Tpareset Required? >>>>> No

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020