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

629 lines
36 KiB
HTML
Raw Permalink Blame History

<?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 3014 - Generic QQ Information" />
<meta name="DC.subject" content="summary row, generic query information" />
<meta name="keywords" content="summary row, generic query information" />
<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="t3014" />
<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 3014 - Generic QQ Information</title>
</head>
<body id="t3014"><a name="t3014"><!-- --></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 3014 - Generic QQ Information</h1>
<div><div class="example"> <pre><strong>Create View</strong> QQQ3014 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,
QQREST as Estimated_Rows_Selected,
QQEPT as Estimated_Processing_Time,
QQI1 as Open_Time,
QQORDG as Has_Ordering,
QQGRPG as Has_Grouping,
QQJNG as Has_Join,
QQC22 as Join_Type,
QQUNIN as Has_Union,
QQSUBQ as Has_Subquery,
QWC1F as Has_Scalar_Subselect,
QQHSTV as Has_Host_Variables,
QQRCDS as Has_Row_Selection,
QQC11 as Query_Governor_Enabled,
QQC12 as Stopped_By_Query_Governor,
QQC101 as Open_Id,
QQC102 as Query_Options_Library,
QQC103 as Query_Options_Table_Name,
QQC13 as Early_Exit,
QVRCNT as Unique_Refresh_Counter,
QQI5 as Optimizer_Time,
QQTIM1 as Access_Plan_Timestamp,
QVC11 as Ordering_Implementation,
QVC12 as Grouping_Implementation,
QVC13 as Join_Implementation,
QVC14 as Has_Distinct,
QVC15 as Is_Distributed,
QVC3001 as Distributed_Nodes,
QVC105 as NLSS_Table,
QVC106 as NLSS_Library,
QVC16 as ALWCPYDATA,
QVC21 as Access_Plan_Reason_Code,
QVC22 as Access_Plan_Reason_SubCode,
QVC3002 as Summary,
QWC16 as Last_Union_Subselect,
QVP154 as Query_PoolSize,
QVP155 as Query_PoolID,
QQI2 as Query_Time_Limit,
QVC81 as Parallel_Degree,
QQI3 as Max_Number_of_Tasks,
QVC17 as Apply_CHGQRYA_Remote,
QVC82 as Async_Job_Usage,
QVC18 as Force_Join_Order_Indicator,
QVC19 as Print_Debug_Messages,
QVC1A as Parameter_Marker_Conversion,
QQI4 as UDF_Time_Limit,
QVC1283 as Optimizer_Limitations,
QVC1E as Reoptimize_Requested,
QVC87 as Optimize_All_Indexes,
QQC14 as Has_Final_Decomposed_QDT,
QQC15 as Is_Final_Decomposed_QDT,
QQC18 as Read_Trigger,
QQC81 as Star_Join,
SUBSTR(QVC23,1,1) as Optimization_Goal,
SUBSTR(QVC24,1,1) as VE_Diagram_Type,
SUBSTR(QVC24,2,1) as Ignore_Like_Redunant_Shifts,
QQC23 as Union_QDT,
QQC21 as Unicode_Normalization,
QVP153 as Pool_Fair_Share,
QQC82 as Force_Join_Order_Requested,
QVP152 as Force_Join_Order_Dataspace1,
QQI6 as No_Parameter_Marker_Reason_Code,
QVP151 as Hash_Join_Reason_Code,
QQI7 as MQT_Refresh_Age,
SUBSTR(QVC42,1,1) as MQT_Usage,
QVC43 as SQE_NotUsed_Reason_Code,
QVP156 as Estimated_IO_Count,
QVP157 as Estimated_Processing_Cost,
QVP158 as Estimated_CPU_Cost,
QVP159 as Estimated_IO_Cost,
SUBSTR(QVC44,1,1) as Has_Implicit_Numeric_Conversion
<strong>FROM</strong> UserLib/DBMONTable
<strong>WHERE</strong> QQRID=3014) </pre>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="hsides" border="1" rules="rows"><caption>Table 1. QQQ3014 - Generic QQ Information</caption><thead align="left"><tr><th align="left" valign="bottom" width="34.4294003868472%" id="d0e43">View Column Name</th>
<th align="left" valign="bottom" width="10.058027079303674%" id="d0e45">Table Column Name</th>
<th align="left" valign="bottom" width="55.512572533849124%" id="d0e47">Description</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Row_ID</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQRID</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Row identification</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Time_Created</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQTIME</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Time row was created</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Join_Column</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQJFLD</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Join column (unique per job)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Relational_Database_Name</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQRDBN</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Relational database name</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">System_Name</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQSYS</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">System name</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Job_Name</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQJOB</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Job name</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Job_User</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQUSER</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Job user</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Job_Number</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQJNUM</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Job number</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Thread_ID</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI9</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Thread identifier</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Unique_Count</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQUCNT</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Unique count (unique per query)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">User_Defined</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQUDEF</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">User defined column </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Unique_SubSelect_Number</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQQDTN</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Unique subselect number</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">SubSelect_Nested_Level</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQQDTL</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Subselect nested level</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Materialized_View_Subselect_Number</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQMATN</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Materialized view subselect number</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Materialized_View_Nested_Level</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQMATL</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Materialized view nested level</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Materialized_View_Union_Level</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP15E</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Materialized view union level</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Decomposed_Subselect_Number</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP15A</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Decomposed query subselect number, unique across all
decomposed subselects</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Total_Number_Decomposed_SubSelects</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP15B</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Total number of decomposed subselects</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Decomposed_SubSelect_Reason_Code</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP15C</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Decomposed query subselect reason code</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Starting_Decomposed_SubSelect</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP15D</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Decomposed query subselect number for the first decomposed
subselect</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Estimated_Rows_Selected</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQREST</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Estimated number of rows selected </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Estimated_Processing_Time</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQEPT </td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Estimated processing time, in seconds</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Open_Time</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI1</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Time spent to open cursor, in milliseconds</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Ordering</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQORDG</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Ordering (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Grouping</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQGRPG</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Grouping (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Join</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQJNG</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Join Query (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Join_Type</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC22</td>
<td valign="top" width="55.512572533849124%" 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.4294003868472%" headers="d0e43 ">Has_Union</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQUNIN</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Union Query (Y/N) </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Subquery</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQSUBQ </td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Subquery (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Scalar_Subselect</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QWC1F</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Scalar Subselects (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Host_Variables</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQHSTV </td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Host variables (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Row_Selection</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQRCDS</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Row selection (Y/N) </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Query_Governor_Enabled</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC11</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query governor enabled (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Stopped_By_Query_Governor</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC12</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query governor stopped the query (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Open_Id</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC101</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query open ID </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Query_Options_Library</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC102</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query Options library name</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Query_Options_Table_Name</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC103</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query Options file name</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Early_Exit</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC13</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query early exit value</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Unique_Refresh_Counter</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVRCNT</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Unique refresh counter</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Optimizer_Time</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI5 </td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Time spent in optimizer, in milliseconds</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Access_Plan_Timestamp</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQTIM1</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Access Plan rebuilt timestamp, last time access plan was rebuilt.</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Ordering_Implementation</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC11</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Ordering implementation. Possible values are: <ul><li>I - Index</li>
<li>S - Sort</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Grouping_Implementation</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC12</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Grouping implementation. Possible values are: <ul><li>I - Index</li>
<li>H - Hash grouping</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Join_Implementation</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC13</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Join Implementation. Possible values are: <ul><li>N - Nested Loop join</li>
<li>H - Hash join</li>
<li>C - Combination of Nested Loop and Hash</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Distinct</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC14</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Distinct query (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Is_Distributed</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC15</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Distributed query (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Distributed_Nodes</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC3001</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Distributed nodes </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">NLSS_Table</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC105</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Sort Sequence Table</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">NLSS_Library</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC106</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Sort Sequence Library</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">ALWCPYDATA</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC16</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">ALWCPYDTA setting</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Access_Plan_Reason_Code</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC21</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Reason code why access plan was rebuilt</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Access_Plan_Reason_SubCode</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC22</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Subcode why access plan was rebuilt</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Summary</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC3002</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Summary of query implementation. Shows dataspace number and name of
index used for each table being queried.</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Last_Union_Subselect</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QWC16</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Last part (last QDT) of Union (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Query_PoolSize</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP154</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Pool size </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Query_PoolID</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP155</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Pool id </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Query_Time_Limit</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI2 </td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Query time limit</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Parallel_Degree</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC81</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Parallel Degree <ul><li>*SAME - Don't change current setting</li>
<li>*NONE - No parallel processing is allowed</li>
<li>*I/O - Any number of tasks may be used for I/O processing. SMP parallel
processing is not allowed.</li>
<li>*OPTIMIZE - The optimizer chooses the number of tasks to use for either
I/O or SMP parallel processing.</li>
<li>*MAX - The optimizer chooses to use either I/O or SMP parallel processing.</li>
<li>*SYSVAL - Use the current system value to process the query.</li>
<li>*ANY - Has the same meaning as *I/O.</li>
<li>*NBRTASKS - The number of tasks for SMP parallel processing is specified
in column QVTASKN.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Max_Number_of_Tasks</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI3</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Max number of tasks</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Apply_CHGQRYA_Remote</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC17</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Apply CHGQRYA remotely (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Async_Job_Usage</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC82</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Asynchronous job usage <ul><li>*SAME - Don't change current setting</li>
<li>*DIST - Asynchronous jobs may be used for queries with distributed tables</li>
<li>*LOCAL - Asynchronous jobs may be used for queries with local tables only</li>
<li>*ANY - Asynchronous jobs may be used for any database query</li>
<li>*NONE - No asynchronous jobs are allowed</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Force_Join_Order_Indicator</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC18</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Force join order (Y/N) </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Print_Debug_Messages</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC19</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Print debug messages (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Parameter_Marker_Conversion</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC1A</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Parameter marker conversion (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">UDF_Time_Limit</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI4 </td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">User Defined Function time limit </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Optimizer_Limitations</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC1283</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Optimizer limitations. Possible values: <ul><li>*PERCENT followed by 2 byte integer containing the percent value</li>
<li>*MAX_NUMBER_OF_RECORDS followed by an integer value that represents the
maximum number of rows</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Reoptimize_Requested</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">&nbsp;</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Reoptimize access plan requested. Possible values are: <ul><li>O - Only reoptimize the access plan when absolutely required. Do not reoptimize
for subjective reasons.</li>
<li>Y - Yes, force the access plan to be reoptimized.</li>
<li>N - No, do not reoptimize the access plan, unless optimizer determines
that it is necessary. May reoptimize for subjective reasons.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Optimize_All_Indexes</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">&nbsp;</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Optimize all indexes requested <ul><li>*SAME - Don't change current setting</li>
<li>*YES - Examine all indexes</li>
<li>*NO - Allow optimizer to time-out</li>
<li>*TIMEOUT - Force optimizer to time-out</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Final_Decomposed_QDT</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC14</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Final decomposed QDT built indicator (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Is_Final_Decomposed_QDT</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC15</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">This is the final decomposed QDT indicator (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Read_Trigger</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC18</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">One of the files contains a read trigger (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Star_Join</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC81</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Star join optimization requested. <ul><li>*NO - Star join optimization will not be performed.</li>
<li>*COST - The optimizer will determine if any EVIs can be used for star
join optimization.</li>
<li>*FORCE - The optimizer will add any EVIs that can be used for star join
optimization.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Optimization_Goal</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC23</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Byte 1 = Optimization goal. Possible values are: <ul><li>F - First I/O, optimize the query to return the first screen full of rows
as quickly as possible.</li>
<li>A - All I/O, optimize the query to return all rows as quickly as possible.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">VE_Diagram_Type</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC24</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Byte 1 = Type of Visual Explain diagram. Possible values
are: <ul><li>D - Detail</li>
<li>B - Basic</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Ignore_Like_Redunant_Shifts</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC24</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Byte 2 - Ignore LIKE redundant shifts. Possible values
are: <ul><li>O - Optimize, the query optimizer determines which redundant shifts to
ignore.</li>
<li>A - All, all redundant shifts will be ignored.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Union_QDT</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC23</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Byte 1 = This QDT is part of a UNION that is contained
within a view (Y/N) <p>Byte 2 = This QDT is the last subselect of the UNION
that is contained within a view (Y/N)</p>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Unicode_Normalization</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC21</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Unicode data normalization requested (Y/N)</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Pool_Fair_Share</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP153</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Fair share of the pool size as determined by the optimizer</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Force_Join_Order_Requested</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQC82</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Force Join Order requested. Possible values are: <ul><li>*NO - The optimizer was allowed to reorder join files</li>
<li>*YES - The optimizer was not allowed to reorder join files as part of
its optimization process</li>
<li>*SQL - The optimizer only forced the join order for those queries that
used the SQL JOIN syntax</li>
<li> *PRIMARY - The optimizer was only required to force the primary dial
for the join. </li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Force_Join_Order_Dataspace1</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP152</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Primary dial to force if Force_Join_Order_Indicator
is *PRIMARY. </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">No_Parameter_Marker_Reason_Code</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI6</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Reason code for why Parameter Marker Conversion was
not performed: <ol><li>Argument of function must be a literal</li>
<li>LOCALTIME or LOCALTIMESTAMP</li>
<li>Duration literal in arithmetic expression</li>
<li>UPDATE query with no WHERE clause</li>
<li>BLOB literal</li>
<li>Special register in UPDATE or INSERT with values</li>
<li>Result expression for CASE</li>
<li>GROUP BY expression</li>
<li>ESCAPE character</li>
<li>Double Negative value -(-1)</li>
<li>INSERT or UPDATE with a mix of literals, parameter markers, and NULLs</li>
<li>UPDATE with a mix of literals and parameter markers</li>
<li>INSERT with VALUES containing NULL value and expressions</li>
<li>UPDATE with list of expressions</li>
</ol>
<ul class="simple"><li>99. Parameter marker conversion disabled by QAQQINI </li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Hash_Join_Reason_Code</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP151</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Reason code why hash join was not used.</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">MQT_Refresh_Age</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QQI7</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Value of the MATERIALIZED_QUERY_TABLE_REFRESH_AGE duration.
If the QAQQINI parameter value is set to *ANY, the timestamp duration will
be 99999999999999. </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">MQT_Usage</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC42,1,1</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Byte 1 - Contains the MATERIALIZED_QUERY_TABLE_USAGE.
Possible values are:<ul><li>N - *NONE - no materialized query tables used in query optimization and
implementation</li>
<li>A - *ALL - User-maintained. Refresh-deferred query tables can be used.</li>
<li>U - *USER - Only user-maintained materialized query tables can be used.</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">SQE_NotUsed_Reason_Code</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC43</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">SQE Not Used Reason Code. Possible values:<ul><li>XL - Translation used in query</li>
<li>XU - Translation for UTF used in query</li>
<li>UF - User Defined Table Function used in query</li>
<li>LF - DDS logical file specified in query definition</li>
<li>LC - Lateral correlation</li>
<li>DK - An index with derived key or select/omit was found over a queried
table</li>
<li>NF - Too many tables in query</li>
<li>NS - Not an SQL query or query not run through an SQL interface</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">SQE_NotUsed_Reason_Code (continued)</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">&nbsp;</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 "><ul><li>DF - Distributed table in query</li>
<li>RT - Read Trigger defined on queried table</li>
<li>PD - Program described file in query</li>
<li>WC - WHERE CURRENT OF a partition table</li>
<li>IO - Simple INSERT query</li>
<li>CV - Create view statement</li>
</ul>
</td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Estimated_IO_Count</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP156</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Estimated I/O count </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Estimated_Processing_Cost</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP157</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Estimated processing cost in milliseconds </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Estimated_CPU_Cost</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP158</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Estimated CPU cost in milliseconds </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Estimated_IO_Cost</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVP159</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Estimated I/O cost in milliseconds </td>
</tr>
<tr><td valign="top" width="34.4294003868472%" headers="d0e43 ">Has_Implicit_Numeric_Conversion</td>
<td valign="top" width="10.058027079303674%" headers="d0e45 ">QVC44</td>
<td valign="top" width="55.512572533849124%" headers="d0e47 ">Byte 1: Implicit numeric conversion (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 View Git Blame Copy Permalink