30 lines
1.9 KiB
HTML
30 lines
1.9 KiB
HTML
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
||
|
|
<html>
|
||
|
|
<head>
|
||
|
|
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
|
||
|
|
<LINK rel="stylesheet" type="text/css" href="../../../rzahg/ic.css">
|
||
|
|
|
||
|
|
<title>Database tuning parameters</title>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<BODY>
|
||
|
|
<!-- Java sync-link -->
|
||
|
|
<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>
|
||
|
|
|
||
|
|
<h4><a name="prftunedb"></a>Database tuning parameters</h4>
|
||
|
|
|
||
|
|
<p>For tuning information for DB2 UDB for iSeries, see these resources:</p>
|
||
|
|
<ul>
|
||
|
|
<li><p><a href="../../../rzajq/rzajqkickoff.htm">Query performance and query optimization</a> in the <em>Database</em> topic.</p></li>
|
||
|
|
<li><p>Chapter 4 of the Performance Capabilities Reference. Links to several editions of the Performance Capabilities Reference are listed in the <a href="http://www.ibm.com/servers/eserver/iseries/perfmgmt/resource.htm" target="_blank">Performance Management Resource Library</a>. <img src="www.gif" width="18" height="15" alt="Link outside Information Center" border="0"></p></li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<p>You might also want to adjust the QSQSRVR prestart job settings for your system. On iSeries, QSQSRVR jobs process Java database access (JDBC). By default, five QSQSRVR jobs are initially active. When fewer than two QSQSRVR jobs are unused, two more jobs are created. An application that establishes a large number of database connections over a short period of time may be able to create connections more quickly if these values are increased. To increase the initial number of jobs, threshold, and additional number of jobs values, run this command on an CL command line:</p>
|
||
|
|
<pre>CHGPJE SBSD(QSYS/QSYSWRK) PGM(QSYS/QSQSRVR)</pre>
|
||
|
|
<p>Do not start more QSQSRVR jobs than your application requires, because there is some overhead associated with having QSQSRVR jobs active, even if they are not being used.</p>
|
||
|
|
|
||
|
|
<p>If you use a different database, refer to that product's documentation.</p>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|