16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update

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 Database. 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.

You cannot shred the contents of the XMLTextInfo column in QryLockLogXMLV. To shred this column, you must use the underlying table, DBQLXMLockTbl.

For information about shredding the XMLTextInfo column, see Teradata® Vantage - Database Administration, B035-1093.