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/t3027.htm

322 lines
18 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 3027 - Subquery Merge" />
<meta name="DC.subject" content="summary row, subquery merge" />
<meta name="keywords" content="summary row, subquery merge" />
<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="t3027" />
<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 3027 - Subquery Merge</title>
</head>
<body id="t3027"><a name="t3027"><!-- --></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 3027 - Subquery Merge</h1>
<div><div class="example"> <pre><strong>Create View</strong> QQQ3027 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,
QVRCNT as Unique_Refresh_Counter,
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,
QQREST as Estimated_Rows_Selected,
QQAJN as Estimated_Join_Rows,
QQJNP as Join_Position,
QQI1 as DataSpace_Number,
QQC21 as Join_Method,
QQC22 as Join_Type,
QQC23 as Join_Operator,
QVJFANO as Join_Fanout,
QVFILES as Join_Table_Count,
QVP151 as Subselect_Number_of_Inner_Subquery,
QVP152 as Subselect_Level_of_Inner_Subquery,
QVP153 as Materialized_View_Subselect_Number_of_Inner,
QVP154 as Materialized_View_Nested_Level_of_Inner,
QVP155 as Materialized_View_Union_Level_of_Inner,
QQC101 as Subquery_Operator,
QVC21 as Subquery_Type,
QQC11 as Has_Correlated_Columns,
QVC3001 as Correlated_Columns
<strong>FROM</strong> UserLib/DBMONTable
<strong>WHERE</strong> QQRID=3027)
</pre>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="hsides" border="1" rules="rows"><caption>Table 1. QQQ3027 - Subquery Merge</caption><thead align="left"><tr><th align="left" valign="bottom" width="37.453183520599254%" id="d0e43">View Column Name</th>
<th align="left" valign="bottom" width="15.543071161048688%" id="d0e45">Table Column Name</th>
<th align="left" valign="bottom" width="47.00374531835206%" id="d0e47">Description</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Row_ID</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQRID</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Row identification </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Time_Created</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQTIME</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Time row was created </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Join_Column</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQJFLD</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Join column (unique per job)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Relational_Database_Name</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQRDBN</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Relational database name </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">System_Name</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQSYS</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">System name</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Job_Name</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQJOB</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Job name </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Job_User</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQUSER</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Job user </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Job_Number</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQJNUM</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Job number</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Thread_ID</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQI9</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Thread identifier </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Unique_Count</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQUCNT</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Unique count (unique per query)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">User_Defined</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQUDEF</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">User defined column </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Unique_SubSelect_Number</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQQDTN</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Subselect number for outer subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">SubSelect_Nested_Level</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQQDTL</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Subselect level for outer subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Materialized_View_Subselect_Number</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQMATN</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Materialized view subselect number for outer subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Materialized_View_Nested_Level</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQMATL</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Materialized view subselect level for outer subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Materialized_View_Union_Level</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP15E</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Materialized view union level</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Decomposed_Subselect_Number</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP15A</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Decomposed query subselect number, unique across all
decomposed subselects</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Total_Number_Decomposed_SubSelects</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP15B</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Total number of decomposed subselects</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Decomposed_SubSelect_Reason_Code</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP15C</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Decomposed query subselect reason code</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Starting_Decomposed_SubSelect</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP15D</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Decomposed query subselect number for the first decomposed
subselect</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Unique_Refresh_Counter</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVRCNT</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Unique refresh counter</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Parallel_Prefetch</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVPARPF</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Parallel Prefetch (Y/N) </td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Parallel_PreLoad</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVPARPL</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Parallel Preload (index used)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Parallel_Degree_Requested</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVPARD</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Parallel degree requested (index used)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Parallel_Degree_Used</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVPARU</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Parallel degree used (index used)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Parallel_Degree_Reason_Code</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVPARRC</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Reason parallel processing was limited (index used)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Estimated_Processing_Time</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQEPT</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Estimated processing time, in seconds</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Estimated_Cumulative_Time</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVCTIM</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Estimated cumulative time, in seconds</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Estimated_Rows_Selected</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQREST</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Estimated rows selected</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Estimated_Join_Rows</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQAJN</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Estimated number of joined rows</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Join_Position</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQJNP</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Join position - when available</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">DataSpace_Number</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQI6</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Dataspace number</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Join_Method</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQC21</td>
<td valign="top" width="47.00374531835206%" 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="37.453183520599254%" headers="d0e43 ">Join_Type</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQC22</td>
<td valign="top" width="47.00374531835206%" 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="37.453183520599254%" headers="d0e43 ">Join_Operator</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQC23</td>
<td valign="top" width="47.00374531835206%" 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="37.453183520599254%" headers="d0e43 ">Join_Fanout</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVJFANO</td>
<td valign="top" width="47.00374531835206%" 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="37.453183520599254%" headers="d0e43 ">Join_Table_Count</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVFILES</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Number of tables joined</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Subselect_Number_of_Inner_Subquery</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP151</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Subselect number for inner subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Subselect_Level_of_Inner_Subquery</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP152</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Subselect level for inner subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Materialized_View_Subselect_Number _of_Inner</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP153</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Materialized view subselect number for inner subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Materialized_View_Nested_Level_of_Inner</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP154</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Materialized view subselect level for inner subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Materialized_View_Union_Level_of_Inner</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVP155</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Materialized view union level for inner subquery</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Subquery_Operator</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQC101</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Subquery operator. Possible values are: <ul><li>EQ - Equal</li>
<li>NE - Not Equal</li>
<li>LT - Less Than or Equal</li>
<li>LT - Less Than</li>
<li>GE - Greater Than or Equal</li>
<li>GT - Greater Than</li>
<li>IN</li>
<li>LIKE</li>
<li>EXISTS</li>
<li>NOT - Can precede IN, LIKE or EXISTS</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Subquery_Type</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVC21</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Subquery type. Possible values are: <ul><li>SQ - Subquery</li>
<li>SS - Scalar subselect</li>
<li>SU - Set Update</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Has_Correlated_Columns</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QQC11</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">Correlated columns exist (Y/N)</td>
</tr>
<tr><td valign="top" width="37.453183520599254%" headers="d0e43 ">Correlated_Columns</td>
<td valign="top" width="15.543071161048688%" headers="d0e45 ">QVC3001</td>
<td valign="top" width="47.00374531835206%" headers="d0e47 ">List of correlated columns with corresponding QDT number</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