Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 20:30:18 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Finding frequency of NUSI usage
From:   Myrna, James

I believe it may be hard to tell with 100% certainty. The dbc.DBQLObjTbl may not contain all of your SQL statements if logging is not turned on for every user or if threshold logging is enabled where you don't get ever SQL statement which is under the threshold specified. (I assume you move the "dbc" data into the "PMCPData" database nightly and would look there for long term analysis).

I don't know much about the dbc.Indices column accesscount, but I know you have to enable it's use, otherwise the count will always be NULL. Enable it by setting the ObjectUseCountCollectRate field in the DBS Control Utility. A note from the manual: "Collecting use counts, like access logging, is resource-intensive. Enable this feature only if necessary, and set the collection rate as needed".


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