The QryLockLogXMLV view of DBQLXMLLOCKTbl is populated if you request WITH LOCK and 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 must be shredded.
The XML shredding feature is enabled by default in VantageCloud Lake. Using Teradata client software, such as BTEQ, 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 Shredding the Lock Plan Information in the XML Lock Log Table, DBQLXMLLockTbl.