192 lines
12 KiB
HTML
192 lines
12 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="PRTSQLINF message reference" />
|
||
|
|
<meta name="abstract" content="The following are the messages returned from PRTSQLINF." />
|
||
|
|
<meta name="description" content="The following are the messages returned from PRTSQLINF." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqmsgref.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql400a.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql400b.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql400c.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql400d.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql400e.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4001.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4002.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4003.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4004.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4005.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4006.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4007.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4008.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4009.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql401a.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql401b.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql401c.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql401d.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql401e.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql401f.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4010.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4011.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4012.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4013.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4014.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4015.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4016.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4017.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4018.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4019.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql402a.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql402b.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql402c.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql402d.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4020.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4021.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4022.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4023.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4024.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4025.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4026.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4027.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4028.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4029.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4030.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4031.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4032.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4033.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4034.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="sql4035.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="prtsqlinfmsg" />
|
||
|
|
<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>PRTSQLINF message reference</title>
|
||
|
|
</head>
|
||
|
|
<body id="prtsqlinfmsg"><a name="prtsqlinfmsg"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1"><span class="cmdname">PRTSQLINF</span> message reference</h1>
|
||
|
|
<div><p>The following are the messages returned from <span class="cmdname">PRTSQLINF</span>.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="sql400a.htm">SQL400A - Temporary distributed result file &1 was created to contain join result</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql400b.htm">SQL400B - Temporary distributed result file &1 was created to contain join result</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql400c.htm">SQL400C - Optimizer debug messages for distributed query step &1 and &2 follow</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql400d.htm">SQL400D - GROUP BY processing generated</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql400e.htm">SQL400E - Temporary distributed result file &1 was created while processing distributed subquery</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4001.htm">SQL4001 - Temporary result created</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4002.htm">SQL4002 - Reusable ODP sort used</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4003.htm">SQL4003 - UNION</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4004.htm">SQL4004 - SUBQUERY</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4005.htm">SQL4005 - Query optimizer timed out for table &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4006.htm">SQL4006 - All indexes considered for table &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4007.htm">SQL4007 - Query implementation for join position &1 table &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4008.htm">SQL4008 - Index &1 used for table &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4009.htm">SQL4009 - Index created for table &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql401a.htm">SQL401A - Processing grouping criteria for query containing a distributed table</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql401b.htm">SQL401B - Temporary distributed result table &1 was created while processing grouping criteria</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql401c.htm">SQL401C - Performing distributed join for query</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql401d.htm">SQL401D - Temporary distributed result table &1 was created because table &2 was directed</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql401e.htm">SQL401E - Temporary distributed result table &1 was created because table &2 was broadcast</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql401f.htm">SQL401F - Table &1 used in distributed join</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4010.htm">SQL4010 - Table scan access for table &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4011.htm">SQL4011 - Index scan-key row positioning used on table &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4012.htm">SQL4012 - Index created from index &1 for table &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4013.htm">SQL4013 - Access plan has not been built</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4014.htm">SQL4014 - &1 join column pair(s) are used for this join position</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4015.htm">SQL4015 - From-column &1.&2, to-column &3.&4, join operator &5, join predicate &6</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4016.htm">SQL4016 - Subselects processed as join query</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4017.htm">SQL4017 - Host variables implemented as reusable ODP</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4018.htm">SQL4018 - Host variables implemented as non-reusable ODP</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4019.htm">SQL4019 - Host variables implemented as file management row positioning reusable ODP</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql402a.htm">SQL402A - Hashing algorithm used to process join</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql402b.htm">SQL402B - Table &1 used in hash join step &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql402c.htm">SQL402C - Temporary table created for hash join results</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql402d.htm">SQL402D - Query attributes overridden from query options file &2 in library &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4020.htm">SQL4020 - Estimated query run time is &1 seconds</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4021.htm">SQL4021 - Access plan last saved on &1 at &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4022.htm">SQL4022 - Access plan was saved with SRVQRY attributes active</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4023.htm">SQL4023 - Parallel table prefetch used</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4024.htm">SQL4024 - Parallel index preload access method used</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4025.htm">SQL4025 - Parallel table preload access method used</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4026.htm">SQL4026 - Index only access used on table number &1</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4027.htm">SQL4027 - Access plan was saved with DB2 UDB Symmetric Multiprocessing installed on the system</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4028.htm">SQL4028 - The query contains a distributed table</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4029.htm">SQL4029 - Hashing algorithm used to process the grouping</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4030.htm">SQL4030 - &1 tasks specified for parallel scan on table &2.</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4031.htm">SQL4031 - &1 tasks specified for parallel index create over table &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4032.htm">SQL4032 - Index &1 used for bitmap processing of table &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4033.htm">SQL4033 - &1 tasks specified for parallel bitmap create using &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4034.htm">SQL4034 - Multiple join classes used to process join</a></strong><br />
|
||
|
|
</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="sql4035.htm">SQL4035 - Table &1 used in join class &2</a></strong><br />
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzajqmsgref.htm" title="See the following for query optimizer message reference:">Query optimizer messages reference</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|