Archives of the TeradataForum
Message Posted: Fri, 20 Feb 2015 @ 17:53:31 GMT
Hi Raghu Maram,
The Lock Info collector uses the data written to the DBC.DBQLXMLLockTbl table to capture lock information. For which this need DBQL query logging must be enabled with the WITH LOCK option.
Please make sure the locking logger for userx is turned on and set the lock threshold to 5 cent seconds.
Thus in which the table dbc.dbqlxmllocktbl starts to populate and gets reflected the same in Lock viewer.
GANGA SANDEEP KUMAR
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|