I am trying to setup Viewpoint to capture locks. However, I get the following error as a ! within a red triangle.
Unable to get lock information from dumplocklog utility! [Teradata Database] [TeraJDBC 13.10.00.18] [Error 3190] [SQLState 42000] Access to utility dumplocklogb denied.
I still get this error after I have granted access to the Viewpoint user as follows (according to the Viewpoint Users guide).
replace macro console.dumplocklogb as (;);
grant exec on console.dumplocklogb to viewpoint;
I am now getting this message:
Unable to get lock information from dumplocklog utility! *** Error - Logger was not activated. Q No rows have been inserted to table 'VIEWPOINT'.'LOCKLOGGERTABLE20121008161503'. *** DumpLockLogb is terminated ***
I see in the documentation - it says "
For the Lock Info collector to run, the LockLogger flag in DBSControl on the Teradata system must be set
How do I do this?
Using Viewpoint, I set the LockLogger to TRUE but after a few minutes it is automatically set back to FALSE. When it was TRUE I did a tpareset but when I check the status it is set back to FALSE. Any Idea why?
Use DBSControl, turn on "LockLogger":