17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.

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.