Portlet Lock Viewer no show data

Viewpoint
Enthusiast

Portlet Lock Viewer no show data

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

Tags (1)
7 REPLIES
Teradata Employee

Re: Portlet Lock Viewer no show data

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.

This may also be a Viewpoint roles permissions issue, so validate permissions in Roles Manager.

Enthusiast

Re: Portlet Lock Viewer no show data

ok thx for reply, ill check

Enthusiast

Re: Portlet Lock Viewer no show data

Hi,

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,

Pierre

Teradata Employee

Re: Portlet Lock Viewer no show data

Pierre,

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.

Thanks, Steve

Teradata Employee

Re: Portlet Lock Viewer no show data

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!

Teradata Employee

Re: Portlet Lock Viewer no show data

Dany3R9,

what error were you getting before you found this workaround (and where/how did you find this workaround)?

Teradata Employee

Re: Portlet Lock Viewer no show data

jjudge,

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