112 lines
7.9 KiB
HTML
112 lines
7.9 KiB
HTML
|
<?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="Control queries dynamically with the query options file QAQQINI" />
|
||
|
|
<meta name="abstract" content="The query options file QAQQINI support provides the ability to dynamically modify or override the environment in which queries are executed through the Change Query Attributes (CHGQRYA) command and the QAQQINI file. The query options file QAQQINI is used to set some attributes used by the database manager." />
|
||
|
|
<meta name="description" content="The query options file QAQQINI support provides the ability to dynamically modify or override the environment in which queries are executed through the Change Query Attributes (CHGQRYA) command and the QAQQINI file. The query options file QAQQINI is used to set some attributes used by the database manager." />
|
||
|
|
<meta name="DC.subject" content="query options file, command, QAQQINI, QAQQINI command" />
|
||
|
|
<meta name="keywords" content="query options file, command, QAQQINI, QAQQINI command" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="cqa.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="specifyqaqqini.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="createqaqqini.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqqaqqiniformat.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqsetoptions.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqiniauth.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqinitriggers.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="qryopt.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqlpg.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="qryoptf" />
|
||
|
|
<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>Control queries dynamically with the query options file QAQQINI</title>
|
||
|
|
</head>
|
||
|
|
<body id="qryoptf"><a name="qryoptf"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Control queries dynamically with the query options file QAQQINI</h1>
|
||
|
|
<div><p>The query options file QAQQINI support provides the ability to
|
||
|
|
dynamically modify or override the environment in which queries are executed
|
||
|
|
through the <span class="cmdname">Change Query Attributes (CHGQRYA)</span> command
|
||
|
|
and the QAQQINI file. The query options file QAQQINI is used to set some attributes
|
||
|
|
used by the database manager.</p>
|
||
|
|
<div class="section"><p>For each query that is run the query option values are retrieved
|
||
|
|
from the QAQQINI file in the schema specified on the QRYOPTLIB parameter of
|
||
|
|
the CHGQRYA CL command and used to optimize or implement the query.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>Environmental attributes that you can modify through the QAQQINI
|
||
|
|
file include: </p>
|
||
|
|
<img src="./delta.gif" alt="Start of change" /><ul><li>APPLY_REMOTE</li>
|
||
|
|
<li>ASYNC_JOB_USAGE</li>
|
||
|
|
<li>COMMITMENT_CONTROL_LOCK_LIMIT</li>
|
||
|
|
<li>FORCE_JOIN_ORDER</li>
|
||
|
|
<li>IGNORE_DERIVED_INDEX</li>
|
||
|
|
<li>IGNORE_LIKE_REDUNDANT_SHIFTS</li>
|
||
|
|
<li>LOB_LOCATOR_THRESHOLD</li>
|
||
|
|
<li>MATERIALIZED_QUERY_TABLE_REFRESH_AGE</li>
|
||
|
|
<li>MATERIALIZED_QUERY_TABLE _USAGE</li>
|
||
|
|
<li>MESSAGES_DEBUG</li>
|
||
|
|
<li>NORMALIZE_DATA</li>
|
||
|
|
<li>OPEN_CURSOR_CLOSE_COUNT</li>
|
||
|
|
<li>OPEN_CURSOR_THRESHOLD</li>
|
||
|
|
<li>OPTIMIZE_STATISTIC_LIMITATION</li>
|
||
|
|
<li>OPTIMIZATION_GOAL</li>
|
||
|
|
<li>PARALLEL_DEGREE</li>
|
||
|
|
<li>PARAMETER_MARKER_CONVERSION</li>
|
||
|
|
<li>QUERY_TIME_LIMIT</li>
|
||
|
|
<li>REOPTIMIZE_ACCESS_PLAN</li>
|
||
|
|
<li>SQLSTANDARDS_MIXED_CONSTANT</li>
|
||
|
|
<li>SQL_FAST_DELETE_ROW_COUNT</li>
|
||
|
|
<li>SQL_STMT_COMPRESS_MAX</li>
|
||
|
|
<li>SQL_SUPPRESS_WARNINGS</li>
|
||
|
|
<li>SQL_TRANSLATE_ASCII_TO_JOB</li>
|
||
|
|
<li>STAR_JOIN</li>
|
||
|
|
<li>STORAGE_LIMIT</li>
|
||
|
|
<li>SYSTEM_SQL_STATEMENT_CACHE</li>
|
||
|
|
<li>UDF_TIME_OUT</li>
|
||
|
|
<li>VARIABLE_LENGTH_OPTIMIZATION</li>
|
||
|
|
</ul><img src="./deltaend.gif" alt="End of change" />
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="specifyqaqqini.htm">Specifying the QAQQINI file</a></strong><br />
|
||
|
|
Use the <span class="cmdname">Change Query Attributes (CHGQRYA)</span> command
|
||
|
|
with the QRYOPTLIB (query options library) parameter to specify which schema
|
||
|
|
currently contains or will contain the query options file QAQQINI.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="createqaqqini.htm">Creating the QAQQINI query options file</a></strong><br />
|
||
|
|
Each server is shipped with a QAQQINI template file in schema QSYS. The QAQQINI file in QSYS is to be used as a template when creating all user specified QAQQINI files.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqqaqqiniformat.htm">QAQQINI query options file format</a></strong><br />
|
||
|
|
The QAQQINI file is shipped in the schema QSYS. It has a predefined format and has been pre-populated with the default values for the rows.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqsetoptions.htm">Setting the options within the query options file</a></strong><br />
|
||
|
|
The QAQQINI file query options can be modified with the INSERT, UPDATE, or DELETE SQL statements.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqiniauth.htm">QAQQINI query options file authority requirements</a></strong><br />
|
||
|
|
QAQQINI is shipped with a *PUBLIC *USE authority. This allows users to view the query options file, but not change it. Because changing the values of the QAQQINI file affect all queries that are run on the system, only the system or database administrator should have *CHANGE authority to the QAQQINI query options file.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqinitriggers.htm">QAQQINI file system supplied triggers</a></strong><br />
|
||
|
|
The query options file QAQQINI file uses a system-supplied trigger program in order to process any changes made to the file. A trigger cannot be removed from or added to the file QAQQINI.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="qryopt.htm">QAQQINI query options</a></strong><br />
|
||
|
|
There are different options available for parameters in the QAQQINI file.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="cqa.htm" title="You can modify different types of attributes of the queries that you will execute during a certain job with the Change Query Attributes (CHGQRYA) CL command, or by using the iSeries Navigator Change Query Attributes interface.">Change the attributes of your queries with the Change Query Attributes (CHGQRYA) command</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="rzajqlpg.htm" title="A special type of transitive closure called look ahead predicate generation (LPG) may be costed for joins. In this case, the optimizer attempts to minimize the random I/O costs of a join by pre-applying the results of the query to a large fact table. LPG will typically be used with a class of queries referred to as star join queries, however it can possibly be used with any join query.">Look ahead predicate generation (LPG)</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|