1958 lines
55 KiB
HTML
1958 lines
55 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="copyright" content="(C) Copyright IBM Corporation 2005" />
|
||
|
|
<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.Format" content="XHTML" />
|
||
|
|
<!-- 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>Index</title>
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
<h1>Index</h1>
|
||
|
|
<a name="IDX0_00" href="#IDX1_00">Special characters</a><br />
|
||
|
|
<a name="IDX0_41" href="#IDX1_41">A</a>
|
||
|
|
<a name="IDX0_42" href="#IDX1_42">B</a>
|
||
|
|
<a name="IDX0_43" href="#IDX1_43">C</a>
|
||
|
|
<a name="IDX0_44" href="#IDX1_44">D</a>
|
||
|
|
<a name="IDX0_45" href="#IDX1_45">E</a>
|
||
|
|
<a name="IDX0_46" href="#IDX1_46">F</a>
|
||
|
|
<a name="IDX0_47" href="#IDX1_47">G</a>
|
||
|
|
<a name="IDX0_48" href="#IDX1_48">H</a>
|
||
|
|
<a name="IDX0_49" href="#IDX1_49">I</a>
|
||
|
|
<a name="IDX0_4A" href="#IDX1_4A">J</a>
|
||
|
|
<a name="IDX0_4B" href="#IDX1_4B">K</a>
|
||
|
|
<a name="IDX0_4C" href="#IDX1_4C">L</a>
|
||
|
|
<a name="IDX0_4D" href="#IDX1_4D">M</a>
|
||
|
|
<a name="IDX0_4E" href="#IDX1_4E">N</a>
|
||
|
|
<a name="IDX0_4F" href="#IDX1_4F">O</a>
|
||
|
|
<a name="IDX0_50" href="#IDX1_50">P</a>
|
||
|
|
<a name="IDX0_51" href="#IDX1_51">Q</a>
|
||
|
|
<a name="IDX0_52" href="#IDX1_52">R</a>
|
||
|
|
<a name="IDX0_53" href="#IDX1_53">S</a>
|
||
|
|
<a name="IDX0_54" href="#IDX1_54">T</a>
|
||
|
|
<a name="IDX0_55" href="#IDX1_55">U</a>
|
||
|
|
<a name="IDX0_56" href="#IDX1_56">V</a>
|
||
|
|
<a name="IDX0_57" href="#IDX1_57">W</a>
|
||
|
|
<hr></hr>
|
||
|
|
<strong><a name="IDX1_00" href="#IDX0_00">Special characters</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="applyremote.htm#applyremote">(APYRMT) apply remote parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="ajob.htm#ajob">(ASYNCJ) asynchronous job usage parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">*NODGRP system object</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_41" href="#IDX0_41">A</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="access.htm#access">access plan</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Logical File Member (ADDLFM) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Physical File Constraint (ADDPFCST) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Physical File Member (ADDPFM) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Physical File Trigger (ADDPFTRG) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">Add RDB Directory Entries (ADDRDBDIRE) command</a>
|
||
|
|
</li>
|
||
|
|
<li>adding systems to network
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="scali.htm#scali">redistribution issues</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDLFM (Add Logical File Member) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDPFCST (Add Physical File Constraint) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDPFM (Add Physical File Member) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDPFTRG (Add Physical File Trigger) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">ADDRDBDIRE (Add RDB Directory Entries) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ALCOBJ (Allocate Object) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Allocate Object (ALCOBJ) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">allow copy data (ALWCPYDTA) parameter</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dstdta.htm#dstdta">processing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">ALWCPYDTA (allow copy data) parameter</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dstdta.htm#dstdta">processing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Apply Journaled Changes (APYJRNCHG) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="applyremote.htm#applyremote">apply remote (APYRMT) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li>APYJRNCHG (Apply Journaled Changes) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="ajob.htm#ajob">asynchronous job usage (ASYNCJ) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li>authority changes across node group
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cldf.htm#cldf">inconsistencies</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">authority errors</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_42" href="#IDX0_42">B</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>benefits
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="benefits.htm#benefits">DB2 Multisystem</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="related.htm#related">bibliography</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="broadcast.htm#broadcast">broadcast join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="broadcast.htm#broadcast">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_43" href="#IDX0_43">C</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cldf.htm#cldf">Change Logical File (CHGLF) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Change Logical File Member (CHGLFM) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Change Node Group Attributes (CHGNODGRPA) command <a href="nodework.htm#nodework">(1)</a>, <a href="chgnga.htm#chgnga">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Change Object Owner (CHGOBJOWN) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Change Physical File (CHGPF) command <a href="crtdf.htm#crtdf">(1)</a>, <a href="cldf.htm#cldf">(2)</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="custdd.htm#custdd">data distribution, customizing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Change Physical File Constraint (CHGPFCST) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Change Physical File Member (CHGPFM) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Change Query Attributes (CHGQRYA) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgqrya.htm#chgqrya">changes to</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CHGLF (Change Logical File) command</a>
|
||
|
|
</li>
|
||
|
|
<li>CHGLFM (Change Logical File Member) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CHGNODGRPA (Change Node Group Attributes) command <a href="nodework.htm#nodework">(1)</a>, <a href="chgnga.htm#chgnga">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CHGOBJOWN (Change Object Owner) command</a>
|
||
|
|
</li>
|
||
|
|
<li>CHGPF (Change Physical File) command <a href="crtdf.htm#crtdf">(1)</a>, <a href="cldf.htm#cldf">(2)</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="custdd.htm#custdd">data distribution, customizing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CHGPFCST (Change Physical File Constraint) command</a>
|
||
|
|
</li>
|
||
|
|
<li>CHGPFM (Change Physical File Member) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CHGQRYA (Change Query Attributes) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgqrya.htm#chgqrya">changes to</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Clear Physical File Member (CLRPFM) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CLRPFM (Clear Physical File Member) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="colocated.htm#collocated">collocated join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="colocated.htm#collocated">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>command, CL
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cldf.htm#cldf">Add Logical File Member (ADDLFM)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Physical File Constraint (ADDPFCST)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Physical File Member (ADDPFM)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Add Physical File Trigger (ADDPFTRG)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">Add RDB Directory Entries (ADDRDBDIRE)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDLFM (Add Logical File Member)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDPFCST (Add Physical File Constraint)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDPFM (Add Physical File Member)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ADDPFTRG (Add Physical File Trigger)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">ADDRDBDIRE (Add RDB Directory Entries)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ALCOBJ (Allocate Object)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Allocate Object (ALCOBJ)</a>
|
||
|
|
</li>
|
||
|
|
<li>Apply Journaled Changes (APYJRNCHG)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>APYJRNCHG (Apply Journaled Changes)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Change Logical File (CHGLF)</a>
|
||
|
|
</li>
|
||
|
|
<li>Change Logical File Member (CHGLFM)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Change Node Group Attributes (CHGNODGRPA) <a href="nodework.htm#nodework">(1)</a>, <a href="chgnga.htm#chgnga">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Change Object Owner (CHGOBJOWN)</a>
|
||
|
|
</li>
|
||
|
|
<li>Change Physical File (CHGPF) <a href="crtdf.htm#crtdf">(1)</a>, <a href="cldf.htm#cldf">(2)</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="custdd.htm#custdd">data distribution, customizing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Change Physical File Constraint (CHGPFCST)</a>
|
||
|
|
</li>
|
||
|
|
<li>Change Physical File Member (CHGPFM)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Change Query Attributes (CHGQRYA)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgqrya.htm#chgqrya">changes to</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CHGLF (Change Logical File)</a>
|
||
|
|
</li>
|
||
|
|
<li>CHGLFM (Change Logical File Member)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CHGNODGRPA (Change Node Group Attributes) <a href="nodework.htm#nodework">(1)</a>, <a href="chgnga.htm#chgnga">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CHGOBJOWN (Change Object Owner)</a>
|
||
|
|
</li>
|
||
|
|
<li>CHGPF (Change Physical File) <a href="crtdf.htm#crtdf">(1)</a>, <a href="cldf.htm#cldf">(2)</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="custdd.htm#custdd">data distribution, customizing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CHGPFCST (Change Physical File Constraint)</a>
|
||
|
|
</li>
|
||
|
|
<li>CHGPFM (Change Physical File Member)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">SHARE parameter not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CHGQRYA (Change Query Attributes)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgqrya.htm#chgqrya">changes to</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Clear Physical File Member (CLRPFM)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CLRPFM (Clear Physical File Member)</a>
|
||
|
|
</li>
|
||
|
|
<li>Copy (COPY) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>COPY (Copy) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Copy File (CPYF) <a href="cldf.htm#cldf">(1)</a>, <a href="cpdf.htm#cpdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>CPYF (Copy File) <a href="cldf.htm#cldf">(1)</a>, <a href="cpdf.htm#cpdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>Create Duplicate Object (CRTDUPOBJ)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Create Logical File (CRTLF)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">Create Node Group (CRTNODGRP)</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">changing data partitioning</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Create Physical File (CRTPF) <a href="crtngc.htm#crtngc">(1)</a>, <a href="crtdf.htm#crtdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>CRTDUPOBJ (Create Duplicate Object)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CRTLF (Create Logical File)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">CRTNODGRP (Create Node Group)</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">changing data partitioning</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CRTPF (Create Physical File) <a href="crtngc.htm#crtngc">(1)</a>, <a href="crtdf.htm#crtdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Deallocate Object (DLCOBJ)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Delete File (DLTF)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="deletenode.htm#deletenode">Delete Node Group (DLTNODGRP) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">Display File Description (DSPFD)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">Display Node Group (DSPNODGRP)</a>
|
||
|
|
</li>
|
||
|
|
<li>Display Object Description (DSPOBJD)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">Display Physical File Member (DSPPFM)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="clwork.htm#clwork">distributed file restrictions</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">DLCOBJ (Deallocate Object)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">DLTF (Delete File)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="deletenode.htm#deletenode">DLTNODGRP (Delete Node Group) command</a>
|
||
|
|
</li>
|
||
|
|
<li>DMPOBJ (Dump Object)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">DSPFD (Display File Description)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">DSPNODGRP (Display Node Group)</a>
|
||
|
|
</li>
|
||
|
|
<li>DSPOBJD (Display Object Description)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">DSPPFM (Display Physical File Member)</a>
|
||
|
|
</li>
|
||
|
|
<li>Dump Object (DMPOBJ)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>End Journal Access Path (ENDJRNAP)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">End Journal Physical File Changes (ENDJRNPF)</a>
|
||
|
|
</li>
|
||
|
|
<li>ENDJRNAP (End Journal Access Path)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ENDJRNPF (End Journal Physical File Changes)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Grant Object Authority (GRTOBJAUT)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">GRTOBJAUT (Grant Object Authority)</a>
|
||
|
|
</li>
|
||
|
|
<li>Initialize Physical File Member (INZPFM)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>INZPFM (Initialize Physical File Member)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>list of
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">commands not allowed to run with distributed files</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">commands that affect all pieces of distributed files</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">commands that only affect local pieces of distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Move Object (MOVOBJ)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>MOVOBJ (Move Object)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">Open Query File (OPNQRYF)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">OPNQRYF (Open Query File)</a>
|
||
|
|
</li>
|
||
|
|
<li>POSDBF (Position Database File)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Position Database File (POSDBF)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Remove Journaled Changes (RMVJRNCHG)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Remove Member (RMVM)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Remove Physical File Constraint (RMVPFCST)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Remove Physical File Trigger (RMVPFTRG)</a>
|
||
|
|
</li>
|
||
|
|
<li>Rename Library (RNMLIB) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Rename Member (RNMM)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Rename Object (RNMOBJ)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Reorganize Physical File Member (RGZPFM)</a>
|
||
|
|
</li>
|
||
|
|
<li>Restore Object (RSTOBJ)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Revoke Object Authority (RVKOBJAUT)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RGZPFM (Reorganize Physical File Member)</a>
|
||
|
|
</li>
|
||
|
|
<li>RMVJRNCHG (Remove Journaled Changes)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>RMVM (Remove Member)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RMVPFCST (Remove Physical File Constraint)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RMVPFTRG (Remove Physical File Trigger)</a>
|
||
|
|
</li>
|
||
|
|
<li>RNMLIB (Rename Library) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>RNMM (Rename Member)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RNMOBJ (Rename Object)</a>
|
||
|
|
</li>
|
||
|
|
<li>RSTOBJ (Restore Object)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RVKOBJAUT (Revoke Object Authority)</a>
|
||
|
|
</li>
|
||
|
|
<li>Save Object (SAVOBJ)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>SAVOBJ (Save Object)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Start Journal Access Path (STRJRNAP)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Start Journal Physical File (STRJRNPF)</a>
|
||
|
|
</li>
|
||
|
|
<li>STRJRNAP (Start Journal Access Path)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">STRJRNPF (Start Journal Physical File)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">Work with RDB Directory Entries (WRKRDBDIRE) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">WRKRDBDIRE (Work with RDB Directory Entries) command</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">commitment control</a>
|
||
|
|
</li>
|
||
|
|
<li>controlling
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="tempcontrol.htm#tempcontrol">temporary result writer</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">conversation, protected</a>
|
||
|
|
</li>
|
||
|
|
<li>coordinator node
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="spreg.htm#spreg">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Copy (COPY) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>COPY (Copy) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Copy File (CPYF) command</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cpdf.htm#cpdf">using with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CPYF (Copy File) command</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cpdf.htm#cpdf">using with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Create Duplicate Object (CRTDUPOBJ) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Create Logical File (CRTLF) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Create Node Group (CRTNODGRP) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">changing data partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Create Physical File (CRTPF) command <a href="crtngc.htm#crtngc">(1)</a>, <a href="crtdf.htm#crtdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>CREATE TABLE
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="createdisfile.htm#createdisfile">node group example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CRTDUPOBJ (Create Duplicate Object) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CRTLF (Create Logical File) command</a>
|
||
|
|
</li>
|
||
|
|
<li>CRTNODGRP (Create Node Group) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">changing data partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>CRTPF (Create Physical File) command <a href="crtngc.htm#crtngc">(1)</a>, <a href="crtdf.htm#crtdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_44" href="#IDX0_44">D</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>data distribution
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="custdd.htm#custdd">Change Physical File (CHGPF) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="custdd.htm#custdd">customizing</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">data integrity</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">data node</a>
|
||
|
|
</li>
|
||
|
|
<li>data partitioning attribute, changing
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgnga.htm#chgnga">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>data types
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="joins.htm#joins">that are partition compatible</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>database file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtdf.htm#crtdf">creating as a distributed file</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="intro.htm#intro">distributed across systems figure</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>database system
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="expanddb2.htm#expanddb2">using DB2 Multisystem to increase your system</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">Database to Node Number Correlation figure</a>
|
||
|
|
</li>
|
||
|
|
<li>DB2 Multisystem
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="benefits.htm#benefits">benefits</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="intro.htm#intro">installing</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="intro.htm#intro">introduction to</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="jourc.htm#jourc">journaling considerations</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Deallocate Object (DLCOBJ) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">default partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li>definition
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="spreg.htm#spreg">coordinator node</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">distributed file</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">hashing</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">node</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">node group</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">node group object</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="joins.htm#joins">partition compatible</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partition map</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partition number</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partitioned table</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partitioning file</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partitioning key</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">protected conversation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="intro.htm#intro">shared nothing cluster</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="optov.htm#optov">temporary result file</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">visibility node</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Delete File (DLTF) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Delete Node Group (DLTNODGRP) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="deletenode.htm#deletenode">using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="directed.htm#directed">directed join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="directed.htm#directed">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">Display File Description (DSPFD) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Display Node Group (DSPNODGRP) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dspng.htm#dspng">using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Display Node Group display
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dspng.htm#dspng">Database to Node Number Correlation figure</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">Partition Number to Node Number Correlation</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Display Object Description (DSPOBJD) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">Display Physical File Member (DSPPFM) command</a>
|
||
|
|
</li>
|
||
|
|
<li>DISTINCT clause
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="union.htm#union">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="union.htm#union">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>distributed file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>creating <a href="crtdf.htm#crtdf">(1)</a>, <a href="createdisfile.htm#createdisfile">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li>displaying
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">local records</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">remote data</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>introduction <a href="crtdf.htm#crtdf">(1)</a>, <a href="usedisfile.htm#usedisfile">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="restrict.htm#restrict">restrictions</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cpdf.htm#cpdf">using Copy File (CPYF) command with</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>distributed physical file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>creating
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="createdisfile.htm#createdisfile">example</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="createdisfile.htm#createdisfile">using Create Physical File (CRTPF) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="createdisfile.htm#createdisfile">using SQL CREATE TABLE statement</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>distributed query
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="optov.htm#optov">optimization overview</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="optov.htm#optov">temporary result file</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>distributed relational database network
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">defining local (*LOCAL) system</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">setting up</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">local (*LOCAL) system</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">DLCOBJ (Deallocate Object) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">DLTF (Delete File) command</a>
|
||
|
|
</li>
|
||
|
|
<li>DLTNODGRP (Delete Node Group) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="deletenode.htm#deletenode">using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>DMPOBJ (Dump Object) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">DSPFD (Display File Description) command</a>
|
||
|
|
</li>
|
||
|
|
<li>DSPNODGRP (Display Node Group) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dspng.htm#dspng">using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>DSPOBJD (Display Object Description) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">DSPPFM (Display Physical File Member) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Dump Object (DMPOBJ) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_45" href="#IDX0_45">E</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>End Journal Access Path (ENDJRNAP) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">End Journal Physical File Changes (ENDJRNPF) command</a>
|
||
|
|
</li>
|
||
|
|
<li>ENDJRNAP (End Journal Access Path) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">ENDJRNPF (End Journal Physical File Changes) command</a>
|
||
|
|
</li>
|
||
|
|
<li>example
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="broadcast.htm#broadcast">broadcast join</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="broadcast.htm#broadcast">broadcast join query</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="colocated.htm#collocated">collocated join</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="colocated.htm#collocated">collocated join query</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="createdisfile.htm#createdisfile">CREATE TABLE statement used to specify node group</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">creating node group with specific partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="chgnga.htm#chgnga">data partitioning attributes, changing</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="directed.htm#directed">directed join</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="directed.htm#directed">directed join query</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="createdisfile.htm#createdisfile">distributed physical file, creating</a>
|
||
|
|
</li>
|
||
|
|
<li>node group
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtngc.htm#crtngc">creating</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">creating with default partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="deletenode.htm#deletenode">deleting</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">displaying</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">performance improvement</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">repartitioned join</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">repartitioned join query</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">visibility node, using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_46" href="#IDX0_46">F</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dspng.htm#dspng">figure</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dspng.htm#dspng">Database to Node Number Correlation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="intro.htm#intro">distribution of database files</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">node group</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="odp.htm#odp">open data path (ODP)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">partition map</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">partitioning file</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>partitioning
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">from record (FROMRCD) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">FROMRCD (from record) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li>function
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>SQL
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rrn.htm#rrn">relative record numbering (RRN)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="spreg.htm#spreg">special registers</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_47" href="#IDX0_47">G</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cldf.htm#cldf">Grant Object Authority (GRTOBJAUT) command</a>
|
||
|
|
</li>
|
||
|
|
<li>grouping
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="grouping.htm#grouping">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="grouping.htm#grouping">optimization</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="groupjoin.htm#groupjoin">with joins</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>grouping, one-step
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="onestep.htm#onestep">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>grouping, two-step
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="twostep.htm#twostep">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">GRTOBJAUT (Grant Object Authority) command</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_48" href="#IDX0_48">H</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">hash algorithm</a>
|
||
|
|
</li>
|
||
|
|
<li>HASH scalar function
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="hashex.htm#hashex">for Open Query File (OPNQRYF) CL command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarhash.htm#scalarhash">for SQL</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>hashing
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_49" href="#IDX0_49">I</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>Initialize Physical File Member (INZPFM) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>introduction
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rzaf3c2-gen4.htm#RZAF3C2-gen4">node groups</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>INZPFM (Initialize Physical File Member) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_4A" href="#IDX0_4A">J</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>join
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="broadcast.htm#broadcast">broadcast</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="broadcast.htm#broadcast">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="colocated.htm#collocated">collocated</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="colocated.htm#collocated">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="directed.htm#directed">directed</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="directed.htm#directed">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="joins.htm#joins">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li>optimization <a href="joins.htm#joins">(1)</a>, <a href="joinopt.htm#joinopt">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">repartitioned</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="groupjoin.htm#groupjoin">with grouping</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>join field
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="partkeysjoin.htm#partkeysjoin">over partitioning keys</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>journaling
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="jourc.htm#jourc">considerations with DB2 Multisystem</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_4B" href="#IDX0_4B">K</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>key, partitioning
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_4C" href="#IDX0_4C">L</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>local (*LOCAL) system
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">defining in distributed relational database network</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>local record
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">displaying</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_4D" href="#IDX0_4D">M</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>map, partition
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">figure</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>merge
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">record ordering optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>message
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="debugms.htm#debugms">optimizer</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Move Object (MOVOBJ) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>MOVOBJ (Move Object) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_4E" href="#IDX0_4E">N</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="scali.htm#scali">network, adding systems to</a>
|
||
|
|
</li>
|
||
|
|
<li>node
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtngc.htm#crtngc">data</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">displaying</a>
|
||
|
|
</li>
|
||
|
|
<li>visibility
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtngc.htm#crtngc">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>node group
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">*NODGRP system object</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">authority change inconsistencies</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">changing</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgnga.htm#chgnga">data partitioning attributes examples</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">creating</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtngc.htm#crtngc">examples</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">with specific partitioning</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">default partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="deletenode.htm#deletenode">deleting</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="deletenode.htm#deletenode">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">displaying</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dspng.htm#dspng">example</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">information about</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">figure</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rzaf3c2-gen4.htm#RZAF3C2-gen4">introduction to</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>node group (NODGRP) parameter <a href="crtngc.htm#crtngc">(1)</a>, <a href="crtdf.htm#crtdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>node group commands
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">tasks to complete before using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>node group object
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>NODENAME scalar function
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodenameex.htm#nodenameex">for Open Query File (OPNQRYF) CL command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarnodename.htm#scalarnodename">for SQL</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>NODENUMBER scalar function
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodenumex.htm#nodenumex">for Open Query File (OPNQRYF) CL command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarnodenumber.htm#scalarnodenumber">for SQL</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>NODGRP (node group) parameter <a href="crtngc.htm#crtngc">(1)</a>, <a href="crtdf.htm#crtdf">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>null-capable fields
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="ption.htm#ption">in partitioning key</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>number
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>partition
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_4F" href="#IDX0_4F">O</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>ODP (open data path)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="odp.htm#odp">distributed</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="odp.htm#odp">figure</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="odp.htm#odp">local</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="odp.htm#odp">reusable</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="onestep.htm#onestep">one-step grouping</a>
|
||
|
|
</li>
|
||
|
|
<li>open data path (ODP)
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="odp.htm#odp">figure</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="odp.htm#odp">reusable</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">Open Query File (OPNQRYF) command</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="RZAF3C4-gen5.htm#RZAF3C4-gen5">scalar functions</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">OPNQRYF (Open Query File) command</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="RZAF3C4-gen5.htm#RZAF3C4-gen5">scalar functions</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>OptiConnect
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="benefits.htm#benefits">connectivity method</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>optimization
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="union.htm#union">DISTINCT clause</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="grouping.htm#grouping">grouping</a>
|
||
|
|
</li>
|
||
|
|
<li>join <a href="joins.htm#joins">(1)</a>, <a href="joinopt.htm#joinopt">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="optov.htm#optov">of distributed queries</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="onestep.htm#onestep">one-step grouping</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="optov.htm#optov">overview</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">record ordering</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">merge</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">sort</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="sfquery.htm#sfquery">single file query</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="twostep.htm#twostep">two-step grouping</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="union.htm#union">UNION clause</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>optimizer
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="debugms.htm#debugms">messages</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>ordering, record
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">optimization</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">merge</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">sort</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>overview
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="optov.htm#optov">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_50" href="#IDX0_50">P</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>partition compatible
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="joins.htm#joins">data types</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="joins.htm#joins">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>partition map
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">figure</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">partition number</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="dspng.htm#dspng">Partition Number to Node Number Correlation figure</a>
|
||
|
|
</li>
|
||
|
|
<li>PARTITION scalar function
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="scalarpart.htm#scalarpart">for Open Query File (OPNQRYF) CL command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarpart.htm#scalarpart">for SQL</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="partitionedtables.htm#partitionedtables">Partitioned tables</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="alterpt.htm#alterpt">altering</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="creatept.htm#creatept">creating</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="indexpt.htm#indexpt">indexes</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="partjournal.htm#partjournal">journaling</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="performancept.htm#performancept">performance</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="partrestrict.htm#partrestrict">restrictions</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="partsave.htm#partsave">save and restore</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">partitioning</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="planpart.htm#planpart">advantages of SMP</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="planpart.htm#planpart">considerations for setting up</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodework.htm#nodework">default partitioning</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="ption.htm#ption">keys</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="ption.htm#ption">map</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="ption.htm#ption">number</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="planpart.htm#planpart">planning</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>partitioning attributes, changing
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="chgnga.htm#chgnga">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>partitioning file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">file definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>partitioning file (PTNFILE) parameter <a href="nodework.htm#nodework">(1)</a>, <a href="crtngc.htm#crtngc">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li>partitioning file example
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtngc.htm#crtngc">figure</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>partitioning key
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="choosepart.htm#choosepart">choosing</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="basicterms.htm#basicterms">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="ption.htm#ption">null-capable fields</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="partkeysjoin.htm#partkeysjoin">over join fields</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtdf.htm#crtdf">partitioning key (PTNKEY) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="RZAF3C5-gen6.htm#RZAF3C5-gen6">performance</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">improvement</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">improving query processing</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="qqp.htm#qqp">query</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="summary.htm#summary">summary for queries</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">Symmetric Multiprocessing (SMP) enhancements</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="access.htm#access">plan, access</a>
|
||
|
|
</li>
|
||
|
|
<li>POSDBF (Position Database File) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Position Database File (POSDBF) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>processing
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="dstdta.htm#dstdta">allow copy data (ALWCPYDTA) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dstdta.htm#dstdta">ALWCPYDTA (allow copy data) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dstdta.htm#dstdta">distribute data (DSTDTA) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="dstdta.htm#dstdta">DSTDTA (distribute data) parameter</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>protected conversation
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">with commitment control</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>PTNFILE (partitioning file) parameter <a href="nodework.htm#nodework">(1)</a>, <a href="crtngc.htm#crtngc">(2)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtdf.htm#crtdf">PTNKEY (partitioning key) parameter</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_51" href="#IDX0_51">Q</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>query
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="broadcast.htm#broadcast">broadcast join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="broadcast.htm#broadcast">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="colocated.htm#collocated">collocated join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="colocated.htm#collocated">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="directed.htm#directed">directed join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="directed.htm#directed">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="joins.htm#joins">join implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="joins.htm#joins">join optimization</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="optov.htm#optov">optimization overview</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="qqp.htm#qqp">performance</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="summary.htm#summary">performance consideration summary</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">performance improvements</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">repartitioned join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="optov.htm#optov">temporary result file</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>query, single file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="sfquery.htm#sfquery">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="sfquery.htm#sfquery">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">query optimizer</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_52" href="#IDX0_52">R</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>record ordering
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">merge optimization</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">optimization</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">sort optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>redistribution issues
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="scali.htm#scali">when adding systems to network</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="related.htm#related">related printed information</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rrn.htm#rrn">relative record numbering (RRN) function</a>
|
||
|
|
</li>
|
||
|
|
<li>remote data
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">displaying</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">remote location name (RMTLOCNAME) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li>Remove Journaled Changes (RMVJRNCHG) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Remove Member (RMVM) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Remove Physical File Constraint (RMVPFCST) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Remove Physical File Trigger (RMVPFTRG) command</a>
|
||
|
|
</li>
|
||
|
|
<li>Rename Library (RNMLIB) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Rename Member (RNMM) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Rename Object (RNMOBJ) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Reorganize Physical File Member (RGZPFM) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">repartitioned join</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="repartitioned.htm#repartitioned">example</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Restore Object (RSTOBJ) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>restrictions
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">CL commands not allowed to run with distributed files</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">CL commands that affect all pieces of distributed files</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cllp.htm#cllp">CL commands that only affect local pieces of distributed files</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="restrict.htm#restrict">distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="odp.htm#odp">reusable open data path (ODP)</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Revoke Object Authority (RVKOBJAUT) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RGZPFM (Reorganize Physical File Member) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">RMTLOCNAME (remote location name) parameter</a>
|
||
|
|
</li>
|
||
|
|
<li>RMVJRNCHG (Remove Journaled Changes) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>RMVM (Remove Member) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RMVPFCST (Remove Physical File Constraint) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RMVPFTRG (Remove Physical File Trigger) command</a>
|
||
|
|
</li>
|
||
|
|
<li>RNMLIB (Rename Library) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>RNMM (Rename Member) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="clallow.htm#clallow">not allowed with distributed files</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RNMOBJ (Rename Object) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rrn.htm#rrn">RRN (relative record numbering) function</a>
|
||
|
|
</li>
|
||
|
|
<li>RSTOBJ (Restore Object) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">RVKOBJAUT (Revoke Object Authority) command</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_53" href="#IDX0_53">S</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>Save Object (SAVOBJ) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>SAVOBJ (Save Object) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="RZAF3C5-gen6.htm#RZAF3C5-gen6">scalability</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="RZAF3C4-gen5.htm#RZAF3C4-gen5">scalar function</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>Open Query File (OPNQRYF) CL command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="hashex.htm#hashex">HASH</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodenameex.htm#nodenameex">NODENAME</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="nodenumex.htm#nodenumex">NODENUMBER</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarpart.htm#scalarpart">PARTITION</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>SQL
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="scalarhash.htm#scalarhash">HASH</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarnodename.htm#scalarnodename">NODENAME</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarnodenumber.htm#scalarnodenumber">NODENUMBER</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="scalarpart.htm#scalarpart">PARTITION</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="intro.htm#intro">shared nothing cluster</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="intro.htm#intro">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>single file query
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="sfquery.htm#sfquery">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="sfquery.htm#sfquery">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">SMP (Symmetric Multiprocessing)</a>
|
||
|
|
</li>
|
||
|
|
<li>special register function
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="spreg.htm#spreg">for SQL</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>SQL
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="RZAF3C4-gen5.htm#RZAF3C4-gen5">scalar functions</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Start Journal Access Path (STRJRNAP) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">Start Journal Physical File (STRJRNPF) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">Start SQL (STRSQL) command</a>
|
||
|
|
</li>
|
||
|
|
<li>STRJRNAP (Start Journal Access Path) command
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="cllp.htm#cllp">affects local file pieces only</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="cldf.htm#cldf">STRJRNPF (Start Journal Physical File) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="rcdorder.htm#rcdorder">STRSQL (Start SQL) command</a>
|
||
|
|
</li>
|
||
|
|
<li>subquery
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="subquery.htm#subquery">description</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">Symmetric Multiprocessing (SMP)</a>
|
||
|
|
</li>
|
||
|
|
<li>system object
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="nodework.htm#nodework">*NODGRP</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>systems, adding to network
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="scali.htm#scali">redistribution issues</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_54" href="#IDX0_54">T</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>Table
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="partitionedtables.htm#partitionedtables">partitioning</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>temporary result file
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="optov.htm#optov">definition</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="tempresult.htm#tempresult">temporary result writer</a>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="tempad.htm#tempad">advantages of using</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="tempcontrol.htm#tempcontrol">controlling</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="tempdisad.htm#tempdisad">disadvantages of using</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li><a href="whyusedb2.htm#whyusedb2">two-phase commit protocols</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="twostep.htm#twostep">two-step grouping</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_55" href="#IDX0_55">U</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>UNION clause
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="union.htm#union">implementation</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="union.htm#union">optimization</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_56" href="#IDX0_56">V</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li>visibility node
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="crtngc.htm#crtngc">definition</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">example of how to use</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="crtngc.htm#crtngc">how to create</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<strong><a name="IDX1_57" href="#IDX0_57">W</a></strong>
|
||
|
|
<ul class="indexlist">
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">Work with RDB Directory Entries (WRKRDBDIRE) command</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="tempresult.htm#tempresult">writer, temp</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="tempresult.htm#tempresult">writer, temporary result</a>
|
||
|
|
</li>
|
||
|
|
<li><a href="prenodetask.htm#prenodetask">WRKRDBDIRE (Work with RDB Directory Entries) command</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</body></html>
|