65 lines
3.2 KiB
HTML
65 lines
3.2 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>Configure connection pooling</title>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<BODY>
|
||
|
|
<!-- Java sync-link -->
|
||
|
|
<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>
|
||
|
|
|
||
|
|
<h4><a name="connpool"></a>Configure connection pooling</h4>
|
||
|
|
|
||
|
|
<p>Connection pooling creates a pool of database connections that your applications can use to connect to the database, and can reduce the amount of resources dedicated to establishing and maintaining database connections. Because Web applications typically make more connections to a database than other applications, connection pooling is well suited to Web applications.</p>
|
||
|
|
|
||
|
|
<ul>
|
||
|
|
<li><a href="#acconnpool">Use the administrative console to configure connection pooling</a></li>
|
||
|
|
<li><a href="#wsaconnpool">Use wsadmin to configure connection pooling</a></li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<p><strong><a name="acconnpool">Use the administrative console to configure connection pooling</a></strong></p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li><a href="acstart.htm">Start the administrative console</a>.</li>
|
||
|
|
<li>Expand <strong>Resources</strong> and click <strong>JDBC Providers</strong>.</li>
|
||
|
|
<li>Click the name of the JDBC provider that is associated with the data source for which you want to configure connection pooling.</li>
|
||
|
|
<li>Click <strong>Data Sources</strong>.</li>
|
||
|
|
<li>On the Data Sources page, click the name of the data source for which you want to configure connection pooling.</li>
|
||
|
|
<li>Click <strong>Connection Pool</strong>.</li>
|
||
|
|
<li>On the Connection Pools page, configure connection pooling settings.</li>
|
||
|
|
<li>Click <strong>Apply</strong> or <strong>OK</strong>.</li>
|
||
|
|
<li><a href="acsave.htm">Save the application server configuration</a>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p><strong><a name="wsaconnpool">Use wsadmin to configure connection pooling</a></strong></p>
|
||
|
|
|
||
|
|
<p>To configure connection pooling with wsadmin, follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li><p>On the CL command line, run the STRQSH (Start Qshell) command.</p></li>
|
||
|
|
|
||
|
|
<li><p>Run the cd command to change to the directory that contains the wsadmin tool:</p>
|
||
|
|
<pre>cd /QIBM/ProdData/WebASE/ASE5/bin</pre></li>
|
||
|
|
|
||
|
|
<li><p><a href="wsarun.htm#start">Start wsadmin</a>.</p></li>
|
||
|
|
|
||
|
|
<li><p>At the wsadmin prompt, run this command to identify the parent ID:</p>
|
||
|
|
<pre>set newds [$AdminConfig getid
|
||
|
|
/Cell:<em>myCell</em>/Node:<em>myNode</em>/Server:<em>myAppSvr</em>/
|
||
|
|
JDBCProvider:<em>JDBC1</em>/DataSource:<em>DS1</em>/]</pre>
|
||
|
|
<p>where <em>myCell</em> is the name of the cell that contains your application server, <em>myNode</em> is the name of the node that contains your application server, <em>myAppSvr</em> is the name of your application server, <em>JDBC1</em> is the name of your JDBC provider, and <em>DS1</em> is the name of your the data source for which you want to create a connection pool.</p></li>
|
||
|
|
<p><strong>Note:</strong> This command has been wrapped for display purposes.</p></li>
|
||
|
|
|
||
|
|
<li><p>Run this command to create a new connection pool:</p>
|
||
|
|
<pre>$AdminConfig create ConnectionPool $newds {}</pre></li>
|
||
|
|
|
||
|
|
<li><p>Run this command to save your changes:</p>
|
||
|
|
<pre>$AdminConfig save</pre></li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|