friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzajq_5.4.0.1/t3004.htm

430 lines
25 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
2024-04-02 14:02:31 +00:00
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="security" content="public" />
<meta name="Robots" content="index,follow" />
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
<meta name="DC.Type" content="reference" />
<meta name="DC.Title" content="Database monitor view 3004 - Temp Table" />
<meta name="DC.subject" content="summary row, temporary table" />
<meta name="keywords" content="summary row, temporary table" />
<meta name="DC.Relation" scheme="URI" content="lofdds.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="t3004" />
<meta name="DC.Language" content="en-us" />
<!-- All rights reserved. Licensed Materials Property of IBM -->
<!-- US Government Users Restricted Rights -->
<!-- Use, duplication or disclosure restricted by -->
<!-- GSA ADP Schedule Contract with IBM Corp. -->
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
<link rel="stylesheet" type="text/css" href="./ic.css" />
<title>Database monitor view 3004 - Temp Table</title>
</head>
<body id="t3004"><a name="t3004"><!-- --></a>
<img src="./delta.gif" alt="Start of change" /><!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Database monitor view 3004 - Temp Table</h1>
<div><div class="example"> <pre><strong>Create View</strong> QQQ3004 as
(<strong>SELECT</strong> QQRID as Row_ID,
QQTIME as Time_Created,
QQJFLD as Join_Column,
QQRDBN as Relational_Database_Name,
QQSYS as System_Name,
QQJOB as Job_Name,
QQUSER as Job_User,
QQJNUM as Job_Number,
QQI9 as Thread_ID,
QQUCNT as Unique_Count,
QQUDEF as User_Defined,
QQQDTN as Unique_SubSelect_Number,
QQQDTL as SubSelect_Nested_Level,
QQMATN as Materialized_View_Subselect_Number,
QQMATL as Materialized_View_Nested_Level,
QVP15E as Materialized_View_Union_Level,
QVP15A as Decomposed_Subselect_Number,
QVP15B as Total_Number_Decomposed_SubSelects,
QVP15C as Decomposed_SubSelect_Reason_Code,
QVP15D as Starting_Decomposed_SubSelect,
QQTLN as System_Table_Schema,
QQTFN as System_Table_Name,
QQTMN as Member_Name,
QQPTLN as System_Base_Table_Schema,
QQPTFN as System_Base_Table_Name,
QQPTMN as Base_Member_Name,
QQSTIM as Start_Timestamp,
QQETIM as End_Timestamp,
QQC11 as Has_Default_Values,
QQTMPR as Table_Rows,
QQRCOD as Reason_Code,
QVQTBL as Table_Name,
QVQLIB as Table_Schema,
QVPTBL as Base_Table_Name,
QVPLIB as Base_Table_Schema,
QQC101 as Temporary_Table_Name,
QQC102 as Temporary_Table_Schema,
QVBNDY as Bound,
QVRCNT as Unique_Refresh_Counter,
QVJFANO as Join_Fanout,
QVFILES as Join_Table_Count,
QVPARPF as Parallel_Prefetch,
QVPARPL as Parallel_PreLoad,
QVPARD as Parallel_Degree_Requested,
QVPARU as Parallel_Degree_Used,
QVPARRC as Parallel_Degree_Reason_Code,
QQEPT as Estimated_Processing_Time,
QVCTIM as Estimated_Cumulative_Time,
QQAJN as Estimated_Join_Rows,
QQJNP as Join_Position,
QQI6 as DataSpace_Number,
QQC21 as Join_Method,
QQC22 as Join_Type,
QQC23 as Join_Operator,
QQI2 as Temporary_Table_Row_Size,
QQI3 as Temporary_Table_Size,
QQC12 as Temporary_Query_Result,
QQC13 as Distributed_Temporary_Table,
QVC3001 as Distributed_Temporary_Data_Nodes,
QQI7 as Materialized_Subqery_QDT_Level,
QQI8 as Materialized_Union_QDT_Level,
QQC14 as View_Contains_Union
<strong>FROM</strong> UserLib/DBMONTable
<strong>WHERE</strong> QQRID=3004)</pre>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="hsides" border="1" rules="rows"><caption>Table 1. QQQ3004 - Temp Table</caption><thead align="left"><tr><th align="left" valign="bottom" width="34.35114503816794%" id="d0e43">View Column Name</th>
<th align="left" valign="bottom" width="10.114503816793894%" id="d0e45">Table Column Name</th>
<th align="left" valign="bottom" width="55.534351145038165%" id="d0e47">Description</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Row_ID</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQRID</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Row identification </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Time_Created</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQTIME</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Time row was created </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Column</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQJFLD</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Join column (unique per job)</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Relational_Database_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQRDBN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Relational database name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">System_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQSYS</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">System name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Job_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQJOB</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Job name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Job_User</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQUSER</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Job user</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Job_Number</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQJNUM</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Job number</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Thread_ID</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQI9</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Thread identifier</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Unique_Count</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQUCNT</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Unique count (unique per query) </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">User_Defined</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQUDEF</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">User defined column </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Unique_SubSelect_Number</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQQDTN </td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Unique subselect number</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">SubSelect_Nested_Level</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQQDTL</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Subselect nested level</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Materialized_View_Subselect_Number</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQMATN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Materialized view subselect number</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Materialized_View_Nested_Level</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQMATL</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Materialized view nested level</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Materialized_View_Union_Level</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVP15E</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Materialized view union level</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Decomposed_Subselect_Number</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVP15A</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Decomposed query subselect number, unique across all
decomposed subselects</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Total_Number_Decomposed_SubSelects</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVP15B</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Total number of decomposed subselects</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Decomposed_SubSelect_Reason_Code</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVP15C</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Decomposed query subselect reason code</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Starting_Decomposed_SubSelect</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVP15D</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Decomposed query subselect number for the first decomposed
subselect</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">System_Table_Schema</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQTLN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Schema of table queried</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">System_Table_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQTFN </td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Name of table queried </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Member_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQTMN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Member name of table queried</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">System_Base_Table_Schema</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQPTLN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Schema name of base table</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">System_Base_Table_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQPTFN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Name of base table for table queried</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Base_Member_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQPTMN</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Member name of base table </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Start_Timestamp</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQSTIM</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Start timestamp, when available </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">End_Timestamp</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQETIM</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">End timestamp, when available </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Has_Default_Values</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC11</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Default values may be present in temporary <ul><li>Y - Yes</li>
<li>N - No</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Table_Rows</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQTMPR</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Estimated number of rows in the temporary </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Reason_Code</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQRCOD</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Reason code. Possible values are: <ul><li>F1 - Query contains grouping columns (GROUP BY) from more that one table,
or contains grouping columns from a secondary table of a join query that cannot
be reordered.</li>
<li>F2 - Query contains ordering columns (ORDER BY) from more that one table,
or contains ordering columns from a secondary table of a join query that cannot
be reordered.</li>
<li>F3 - The grouping and ordering columns are not compatible.</li>
<li>F4 - DISTINCT was specified for the query.</li>
<li>F5 - UNION was specified for the query.</li>
<li>F6 - Query had to be implemented using a sort. Key length of more than
2000 bytes or more than 120 key columns specified for ordering.</li>
<li>F7 - Query optimizer chose to use a sort rather than an index to order
the results of the query.</li>
<li>F8 - Perform specified row selection to minimize I/O wait time. </li>
<li>F9 - The query optimizer chose to use a hashing algorithm rather than
an index to perform the grouping.</li>
<li>FA - The query contains a join condition that requires a temporary table</li>
<li>FB - The query optimizer creates a run-time temporary file in order to
implement certain correlated group by queries.</li>
<li>FC - The query contains grouping fields and there is a read trigger on
at least one of the physical files in the query.</li>
<li>FD - The query optimizer creates a runtime temporary file for a static-cursor
request.</li>
<li>H1 - Table is a join logical file and its join type does not match the
join type specified in the query.</li>
<li>H2 - Format specified for the logical table references more than one base
table.</li>
<li>H3 - Table is a complex SQL view requiring a temporary table to contain
the results of the SQL view.</li>
<li>H4 - For an update-capable query, a subselect references a column in this
table which matches one of the columns being updated.</li>
<li>H5 - For an update-capable query, a subselect references an SQL view which
is based on the table being updated.</li>
<li>H6 - For a delete-capable query, a subselect references either the table
from which rows are to be deleted, an SQL view, or an index based on the table
from which rows are to be deleted</li>
<li>H7 - A user-defined table function was materialized.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Table_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVQTBL</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Queried table, long name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Table_Schema</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVQLIB</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Schema of queried table, long name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Base_Table_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPTBL</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Base table, long name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Base_Table_Schema</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPLIB</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Library of base table, long name</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Temporary_Table_Name</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC101</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Temporary table name </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Temporary_Table_Schema</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC102</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Temporary table schema</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Bound</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVBNDY</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">I/O or CPU bound. Possible values are: <ul><li>I - I/O bound</li>
<li>C - CPU bound</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Unique_Refresh_Counter</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVRCNT</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Unique refresh counter</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Fanout</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVJFANO</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Join fan out. Possible values are: <ul><li>N - Normal join situation where fanout is allowed and each matching row
of the join fanout is returned.</li>
<li>D - Distinct fanout. Join fanout is allowed however none of the join fanout
rows are returned.</li>
<li>U - Unique fanout. Join fanout is not allowed. Error situation if join
fanout occurs.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Table_Count</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVFILES</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Number of tables joined </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Parallel_Prefetch</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPARPF </td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Parallel Prefetch (Y/N)</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Parallel_PreLoad</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPARPL</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Parallel Preload (Y/N)</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Parallel_Degree_Requested</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPARD</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Parallel degree requested </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Parallel_Degree_Used</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPARU </td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Parallel degree used</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Parallel_Degree_Reason_Code</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVPARRC</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Reason parallel processing was limited</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Estimated_Processing_Time</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQEPT</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Estimated processing time, in seconds</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Estimated_Cumulative_Time</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVCTIM</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Estimated cumulative time, in seconds</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Estimated_Join_Rows</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQAJN </td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Estimated number of joined rows</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Position</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQJNP</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Join position - when available</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">DataSpace_Number</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQI6</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Dataspace number</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Method</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC21</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Join method - when available <ul><li>NL - Nested loop</li>
<li>MF - Nested loop with selection</li>
<li>HJ - Hash join</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Type</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC22</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Join type - when available <ul><li>IN - Inner join</li>
<li>PO - Left partial outer join</li>
<li>EX - Exception join</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Join_Operator</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC23</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Join operator - when available <ul><li>EQ - Equal </li>
<li>NE - Not equal </li>
<li>GT - Greater than</li>
<li>GE - Greater than or equal </li>
<li>LT - Less than</li>
<li>LE - Less than or equal </li>
<li>CP - Cartesian product</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Temporary_Table_Row_Size</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQI2</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Row size of temporary table, in bytes</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Temporary_Table_Size</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQI3</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Estimated size of temporary table, in bytes. </td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Temporary_Query_Result</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC12</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Temporary result table that contains the results of the query. (Y/N)</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Distributed_Temporary_Table</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC13</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Distributed Table (Y/N)</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Distributed_Temporary_Data_Nodes</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QVC3001</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Data nodes of temporary table</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Materialized_Subqery_QDT_Level</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQI7</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Materialized subquery QDT level</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">Materialized_Union_QDT_Level</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQI8</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Materialized Union QDT level</td>
</tr>
<tr><td valign="top" width="34.35114503816794%" headers="d0e43 ">View_Contains_Union</td>
<td valign="top" width="10.114503816793894%" headers="d0e45 ">QQC14</td>
<td valign="top" width="55.534351145038165%" headers="d0e47 ">Union in a view (Y/N)</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="lofdds.htm" title="The following examples show the different optional SQL view format that you can create with the SQL shown. The column descriptions are explained in the tables following each example. These views are not shipped with the server, and you must create them, if you choose to do so. These views are optional and are not required for analyzing monitor data.">Optional database monitor SQL view format</a></div>
</div>
</div>
<img src="./deltaend.gif" alt="End of change" /></body>
</html>
Reference in New Issue Copy Permalink