I have in dbscontrol the flag locklogger = TRUE, locklogger delay filter = TRUE, locklogger delay filter time = 60, i restarted tpa for apply changes, i started dumplocklog and the portlet Lock VIewer dont show any data but the portlet Query Monitor show the current blocks.
thx in advanced
For future consideration, you may want to submit issues like this to Teradata Support Services as analysis of an issue is more easily resolved following that process versus posting the condition in a DevX forum posting. So if these additional ideas don't resolve your issue, go the Service incident route. The Viewpoint Configuration Guide mentions the following for Lock Viewer:
The Teradata Viewpoint user account must have sufficient spool space to allow Teradata Viewpoint to issue monitoring queries. Also, permanent (perm) space is required by the Lock Info collector that is used by the Lock Viewer portlet.
maybe you could point (and add) the following rights (Database side) :
grant execute procedure on locklogshredder to "viewpoint";
grant create table on "viewpoint" to locklogshredder;
just a suggestion,
The Grant Tool in the Monitored Systems portlet (or the Teradata Systems portlet in Viewpoint 14.10 and earlier) is the tool Viewpoint provides to either display or execute all the grants needed for data collection to work properly. These 2 statements are already included in that tool.
Guys, since i got the same issue i want to share that for the Lock Info collector to run against Teradata Database 14.10 and later, DBQL query logging must be enabled with the WITH LOCK option.
So you can activate the log via TD Administrator (query logging..) flagging the Lock and indicating the lock threshold to be considered.
Have a nice day!
before activating the lock collection functionality the Lock Viewer portlet in Viewpoint did not display anything.
For activate the lock tracking you have to set the logging functionality in this way: via TD Administrator, under Tools -> Query Logging you have to set the Lock >= x centisecond for obtaining the evidence only for the locks above that threshold.
Have a nice day