<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Runtime Configuration</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="ibm-db2.installation.html">Installation</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ibm-db2.resources.html">Resource Types</a></div>
<div class="up"><a href="ibm-db2.setup.html">Installing/Configuring</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="ibm-db2.configuration" class="section">
<h2 class="title">Runtime Configuration</h2>
<p class="simpara">
The behaviour of these functions is affected by settings in <var class="filename">php.ini</var>.
</p>
<p class="para">
<table class="doctable table">
<caption><strong>ibm_db2 Configure Options</strong></caption>
<thead>
<tr>
<th>Name</th>
<th>Default</th>
<th>Changeable</th>
<th>Changelog</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><a href="ibm-db2.configuration.html#ini.ibm-db2.binmode" class="link">ibm_db2.binmode</a></td>
<td>"1"</td>
<td>PHP_INI_ALL</td>
<td class="empty"> </td>
</tr>
<tr>
<td><a href="ibm-db2.configuration.html#ini.ibm-db2.i5-all-pconnect" class="link">ibm_db2.i5_all_pconnect</a></td>
<td>"0"</td>
<td>PHP_INI_SYSTEM</td>
<td>Available since ibm_db2 1.6.5.</td>
</tr>
<tr>
<td><a href="ibm-db2.configuration.html#ini.ibm-db2.i5-allow-commit" class="link">ibm_db2.i5_allow_commit</a></td>
<td>"0"</td>
<td>PHP_INI_SYSTEM</td>
<td>Available since ibm_db2 1.4.9.</td>
</tr>
<tr>
<td><a href="ibm-db2.configuration.html#ini.ibm-db2.i5-dbcs-alloc" class="link">ibm_db2.i5_dbcs_alloc</a></td>
<td>"0"</td>
<td>PHP_INI_SYSTEM</td>
<td>Available since ibm_db2 1.5.0.</td>
</tr>
<tr>
<td><a href="ibm-db2.configuration.html#ini.ibm-db2.instance-name" class="link">ibm_db2.instance_name</a></td>
<td>NULL</td>
<td>PHP_INI_SYSTEM</td>
<td>Available since ibm_db2 1.0.2.</td>
</tr>
<tr>
<td><a href="ibm-db2.configuration.html#ini.ibm-db2.i5-ignore-userid" class="link">ibm_db2.i5_ignore_userid</a></td>
<td>"0"</td>
<td>PHP_INI_SYSTEM</td>
<td>Available since ibm_db2 1.8.0.</td>
</tr>
</tbody>
</table>
</p>
<p class="para">Here's a short explanation of
the configuration directives.</p>
<p class="para">
<dl>
<dt id="ini.ibm-db2.binmode">
<span class="term">
<em><code class="parameter">ibm_db2.binmode</code></em>
<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>
</span>
<dd>
<p class="para">
This option controls the mode used for converting to and from binary
data in the PHP application.
<ul class="itemizedlist">
<li class="listitem">
<p class="para">
1 (DB2_BINARY)
</p>
</li>
<li class="listitem">
<p class="para">
2 (DB2_CONVERT)
</p>
</li>
<li class="listitem">
<p class="para">
3 (DB2_PASSTHRU)
</p>
</li>
</ul>
</p>
</dd>
</dt>
<dt id="ini.ibm-db2.i5-all-pconnect">
<span class="term">
<em><code class="parameter">ibm_db2.i5_all_pconnect</code></em>
<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>
</span>
<dd>
<p class="para">
This option overrides i5 <span class="function"><a href="function.db2-connect.html" class="function">db2_connect()</a></span> full open and close in the PHP
application. When <em><code class="parameter">ibm_db2.i5_all_pconnect</code></em> = 1, all db2 connections
become persistent ( <span class="function"><a href="function.db2-pconnect.html" class="function">db2_pconnect()</a></span>). On i5/OS, <span class="function"><a href="function.db2-pconnect.html" class="function">db2_pconnect()</a></span> performs
dramatically better with lower machine stress over <span class="function"><a href="function.db2-connect.html" class="function">db2_connect()</a></span>. This
is a convenience override of <span class="function"><a href="function.db2-connect.html" class="function">db2_connect()</a></span> to evoke <span class="function"><a href="function.db2-pconnect.html" class="function">db2_pconnect()</a></span> without
PHP source code changes.
<ul class="itemizedlist">
<li class="listitem">
<p class="para">
0 <span class="function"><a href="function.db2-connect.html" class="function">db2_connect()</a></span> default full open and close
</p>
</li>
<li class="listitem">
<p class="para">
1 <span class="function"><a href="function.db2-connect.html" class="function">db2_connect()</a></span> override to <span class="function"><a href="function.db2-pconnect.html" class="function">db2_pconnect()</a></span> for persistent connection only
</p>
</li>
</ul>
</p>
</dd>
</dt>
<dt id="ini.ibm-db2.i5-allow-commit">
<span class="term">
<em><code class="parameter">ibm_db2.i5_allow_commit</code></em>
<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>
</span>
<dd>
<p class="para">
This option controls the commit mode used for i5 schema collections
in the PHP application.
<ul class="itemizedlist">
<li class="listitem">
<p class="para">
0 no commit (see <em><code class="parameter">i5_commit</code></em> for override)
</p>
</li>
<li class="listitem">
<p class="para">
1 allow commit (see <em><code class="parameter">i5_commit</code></em> for override)
</p>
</li>
</ul>
</p>
</dd>
</dt>
<dt id="ini.ibm-db2.i5-dbcs-alloc">
<span class="term">
<em><code class="parameter">ibm_db2.i5_dbcs_alloc</code></em>
<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>
</span>
<dd>
<p class="para">
This option controls the internal ibm_db2 allocation scheme
for large DBCS column buffers.
<ul class="itemizedlist">
<li class="listitem">
<p class="para">
0 no expanded allocations (see <em><code class="parameter">i5_dbcs_alloc</code></em> for override)
</p>
</li>
<li class="listitem">
<p class="para">
1 use expanded allocations (see <em><code class="parameter">i5_dbcs_alloc</code></em> for override)
</p>
</li>
</ul>
</p>
</dd>
</dt>
<dt id="ini.ibm-db2.instance-name">
<span class="term">
<em><code class="parameter">ibm_db2.instance_name</code></em>
<span class="type"><a href="language.types.string.html" class="type string">string</a></span>
</span>
<dd>
<p class="para">
On Linux and UNIX operating systems, this option defines the name of the
instance to use for cataloged database connections. If this option is set,
its value overrides the DB2INSTANCE environment variable setting.
</p>
<p class="para">
This option is ignored on Windows operating systems.
</p>
</dd>
</dt>
<dt id="ini.ibm-db2.i5-ignore-userid">
<span class="term">
<em><code class="parameter">ibm_db2.i5_ignore_userid</code></em>
<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>
</span>
<dd>
<p class="para">
This option overrides i5 db2_(p)connect userid and password in the PHP
application. When <em><code class="parameter">ibm_db2.i5_ignore_userid</code></em> = 1,
all db2 (p)connections become null userid and null password. Therefore
Apache jobs connect with the current profile (NOBODY). Use of this override
is only for simple DB2 based websites that never require profile switching
and therefore can avoid all overhead of server mode additional QSQSRVR jobs.
This is a convenience override of db2_(p)connect to set the userid and password
values to null without PHP source code changes. This override can be used in
combination with <em><code class="parameter">ibm_db2.i5_all_pconnect</code></em> = 1.
<ul class="itemizedlist">
<li class="listitem">
<p class="para">
0 db2_(p)connect with specified userid and password
</p>
</li>
<li class="listitem">
<p class="para">
1 db2_(p)connect override connect with null userid and null password
</p>
</li>
</ul>
</p>
</dd>
</dt>
</dl>
</p>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="ibm-db2.installation.html">Installation</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ibm-db2.resources.html">Resource Types</a></div>
<div class="up"><a href="ibm-db2.setup.html">Installing/Configuring</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
