17.00 - Usage Notes - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.