Archives of the TeradataForum
Message Posted: Fri, 10 Apr 2009 @ 20:30:18 GMT
| 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".