57 lines
4.5 KiB
HTML
57 lines
4.5 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="General DB2 UDB for iSeries performance considerations" />
|
||
|
|
<meta name="abstract" content="As you code your applications, there are some general tips that can help you optimize performance." />
|
||
|
|
<meta name="description" content="As you code your applications, there are some general tips that can help you optimize performance." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqkickoff.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="longobjnames.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="precompileopts.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="ipuc.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="vardatatypes.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="genconsid" />
|
||
|
|
<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>General DB2 UDB for iSeries performance
|
||
|
|
considerations</title>
|
||
|
|
</head>
|
||
|
|
<body id="genconsid"><a name="genconsid"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">General <span class="keyword">DB2<sup>®</sup> UDB for iSeries™</span> performance
|
||
|
|
considerations</h1>
|
||
|
|
<div><p>As you code your applications, there are some general tips that
|
||
|
|
can help you optimize performance.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="longobjnames.htm">Effects on database performance when using long object names</a></strong><br />
|
||
|
|
Long object names are converted internally to system object names when used in SQL statements. This conversion can have some performance impacts.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="precompileopts.htm">Effects of precompile options on database performance</a></strong><br />
|
||
|
|
Several precompile options are available for creating SQL programs with improved performance. They are only options because using them may impact the function of the application. For this reason, the default value for these parameters is the value that will ensure successful migration of applications from prior releases. However, you can improve performance by specifying other options.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="ipuc.htm">Effects of the ALWCPYDTA parameter on database performance</a></strong><br />
|
||
|
|
Some complex queries can perform better by using a sort or hashing method to evaluate the query instead of using or creating an index.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="vardatatypes.htm">Tips for using VARCHAR and VARGRAPHIC data types in databases</a></strong><br />
|
||
|
|
Variable-length column (VARCHAR or VARGRAPHIC) support allows you to define any number of columns in a table as variable length. If you use VARCHAR or VARGRAPHIC support, the size of a table can typically be reduced.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzajqkickoff.htm" title="The goal of database performance tuning is to minimize the response time of your queries and to make the best use of your server's resources by minimizing network traffic, disk I/O, and CPU time. This goal can only be achieved by understanding the logical and physical structure of your data, understanding the applications used on your server, and understanding how the many conflicting uses of your database may impact database performance.">Performance and query optimization</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|