ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzaha_5.4.0.1/rzahajvmprops.htm

80 lines
5.4 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="JVM Properties for JDBC" />
<meta name="abstract" content="Some settings used by the native JDBC driver cannot be set using a connection property. These settings must be set for the JVM in which the native JDBC driver is running. These settings are used for all connections created by the native JDBC driver." />
<meta name="description" content="Some settings used by the native JDBC driver cannot be set using a connection property. These settings must be set for the JVM in which the native JDBC driver is running. These settings are used for all connections created by the native JDBC driver." />
<meta name="DC.Relation" scheme="URI" content="jdbc.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rzahajvmprops" />
<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>JVM Properties for JDBC</title>
</head>
<body id="rzahajvmprops"><a name="rzahajvmprops"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">JVM Properties for JDBC</h1>
<div><p>Some settings used by the native JDBC driver cannot be set using
a connection property. These settings must be set for the JVM in which the
native JDBC driver is running. These settings are used for all connections
created by the native JDBC driver.</p>
<p>The native driver recognizes the following JVM properties:</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr><th align="left" valign="top" id="d0e21">Property</th>
<th align="left" valign="top" id="d0e23">Values</th>
<th align="left" valign="top" id="d0e25">Meaning</th>
</tr>
</thead>
<tbody><tr><td valign="top" headers="d0e21 ">jdbc.db2.job.sort.sequence</td>
<td valign="top" headers="d0e23 ">default value = *HEX</td>
<td valign="top" headers="d0e25 ">Setting this property to true causes the native JDBC driver to use
the Job Sort Sequence of the user that starts the job instead of using the
default value of *HEX. Setting it to anything else or leaving it unset will
cause JDBC to continue to use the default of *HEX. Take careful note of what
this means. When JDBC connections pass in different user profiles on connection
requests, the sort sequence of the user profile that starts the server is
used for all of the connections. This is an environment attribute that is
set at startup time, not a dynamic connection attribute.</td>
</tr>
<tr><td valign="top" headers="d0e21 ">jdbc.db2.trace</td>
<td valign="top" headers="d0e23 ">1 or error = Trace error information 2 or info = Trace information
and error information 3 or verbose = Trace verbose, information, and error
information 4 or all or true = Trace all possible information</td>
<td valign="top" headers="d0e25 ">This property turns on tracing for the JDBC driver. It should be used
when reporting a problem. </td>
</tr>
<tr><td valign="top" headers="d0e21 ">jdbc.db2.trace.config</td>
<td valign="top" headers="d0e23 ">stdout = Trace information is sent to stdout (default value) usrtrc
= Trace information is sent to a user trace. The CL command Dump User Trace
Buffer (DMPUSRTRC) can be used to obtain the trace information. file://&lt;pathtofile&gt;
= Trace information is send to a file. If the file name contains "%j", the
"%j" will be replaced by the job name. An example of &lt;pathtofile&gt; is
/tmp/jdbc.%j.trace.txt.</td>
<td valign="top" headers="d0e25 ">This property is used to specify where the output of the trace should
go.</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="jdbc.htm" title="The IBM Developer Kit for Java JDBC driver, also known as the &#34;native&#34; driver, provides programmatic access to iSeries database files. Using the Java Database Connectivity (JDBC) API, applications written in the Java language can access JDBC database functions with embedded Structured Query Language (SQL), run SQL statements, retrieve results, and propagate changes back to the database. The JDBC API can also be used to interact with multiple data sources in a distributed, heterogeneous environment.">Access your iSeries database with the IBM Developer Kit for Java JDBC driver</a></div>
</div>
</div>
</body>
</html>