The QryLockLogXMLV view of DBQLXMLLOCKTbl is populated if the WITH LOCK option is requested in addition to the default information row. Each row stores a subset of the XML document recording lock delays.
Access to this view is granted based on the security policy of your site. The data from the QryLockLogXMLV view comes directly from the DBQLXMLLockTbl table.
The DBQLXMLLockTbl table logs lock contentions in XML format. The lock logger displays lock objects as follows.
LockObjectRequested | Description |
---|---|
D | Database |
T | Table |
R | Row hash |
TP | Table Partition range |
RP | RowHash in Partition range |
RK | RowHash in one partition |
RN | RowKey range |
Shredding the XMLTextInfo Column
The XMLTextInfo column stores the XML data that needs to be shredded.
The XML shredding feature is enabled by default in Teradata Vantage. Using Teradata client software, such as BTEQ or Teradata Viewpoint, you can call the SP_LockLog_Shredder stored procedure to shred the XML data in the DBQLXMLLockTbl table.
For information about shredding the XMLTextInfo column, see Teradata Vantageā¢ - Database Administration, B035-1093.