62 lines
4.0 KiB
HTML
62 lines
4.0 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="concept" />
|
|
<meta name="DC.Title" content="Apply remote (APYRMT) parameter" />
|
|
<meta name="abstract" content="You can use the APYRMT parameter to specify whether the other CHGQRYA options should be applied to the associated remote system jobs that are used in the processing of the distributed query requests." />
|
|
<meta name="description" content="You can use the APYRMT parameter to specify whether the other CHGQRYA options should be applied to the associated remote system jobs that are used in the processing of the distributed query requests." />
|
|
<meta name="DC.subject" content="apply remote (APYRMT) parameter, (APYRMT) apply remote parameter" />
|
|
<meta name="keywords" content="apply remote (APYRMT) parameter, (APYRMT) apply remote parameter" />
|
|
<meta name="DC.Relation" scheme="URI" content="chgqrya.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="applyremote" />
|
|
<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>Apply remote (APYRMT) parameter</title>
|
|
</head>
|
|
<body id="applyremote"><a name="applyremote"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Apply remote (APYRMT) parameter</h1>
|
|
<div><p>You can use the APYRMT parameter to specify whether the other CHGQRYA
|
|
options should be applied to the associated remote system jobs that are used
|
|
in the processing of the distributed query requests.</p>
|
|
<p>The APYRMT parameter has the following options:</p>
|
|
<ul><li>*YES—apply the CHGQRYA options to remote jobs. This requires that the
|
|
remote job have authority to use the CHGQRYA command. Otherwise, an error
|
|
is signalled to the remote job.</li>
|
|
<li>*NO—apply the CHGQRYA options only locally.</li>
|
|
</ul>
|
|
<div class="p">The following example prevents the CHGQRYA options from being applied remotely:
|
|
<pre>CHGQRYA DEGREE(*NONE) APYRMT(*NO)</pre>
|
|
</div>
|
|
<p>In this case, symmetric multiprocessing (SMP) parallel support
|
|
is prevented on the coordinator node, but the remote systems are allowed to
|
|
choose their own parallel degree.</p>
|
|
<p>In addition to these parameters, you should be aware of how the parameter
|
|
Query Time Limit (QRYTIMLMT) works. The time limit specified on the parameter
|
|
is applied to each step (local and remote) of the distributed query; it is
|
|
not applied to the entire query. Therefore, it is possible for one query step
|
|
to encounter the time limit; whereas, another step can continue without problems.
|
|
While the time limit option can be quite useful, it should be used with caution
|
|
on distributed queries.</p>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="chgqrya.htm" title="The CHGQRYA command has two parameters that are applicable to distributed queries.">Changes to the change query attributes (CHGQRYA) command with DB2 Multisystem</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |