Function of XMLQCD
Captures the XML QCD output from an INSERT EXPLAIN or BEGIN QUERY CAPTURE request submitted with the IN XML option.
XMLQCD Table Definition
The following CREATE TABLE request defines the XMLQCD table:
CREATE MULTISET TABLE qcd.XMLQCD, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( ID INTEGER NOT NULL, Kind CHARACTER(1) NOT NULL CHARACTER SET LATIN NOT CASESPECIFIC, Seq INTEGER NOT NULL, Length INTEGER NOT NULL, Text VARCHAR(31000) NOT NULL CHARACTER SET UNICODE NOT CASESPECIFIC, UDB_Name VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL, CaptureTimeStamp TIMESTAMP(0) NOT NULL, SessionID INTEGER FORMAT ‘--,---,---,--9’ NOT NULL, WorkloadName VARCHAR(128) CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC NOT NULL, XMLDocType INTEGER FORMAT ‘--,---,---,--9’) UNIQUE PRIMARY INDEX (ID, Kind, Seq);
Attribute Definitions for XMLQCD
The following table defines the XMLQCD table attributes:
| Attribute | Definition |
|---|---|
| ID |
|
| Kind |
|
| Seq |
|
| Length | The number of characters that remain in the XML document beginning with this row. The equation for determining the approximate value for Length is as follows:
For example,
and so on. |
| Text | The Seqth slice of the XML document. |
| UDB_Name | Name of the user who submitted the captured query. |
| CaptureTimeStamp | Time stamp of when the query was captured. |
| SessionID | ID for the session in which the query was captured. |
| WorkloadName | Name of the workload specified in the BEGIN QUERY CAPTURE request used to capture the query. |
| XMLDocType | The type of XML content stored in the Text column. |
