139 lines
11 KiB
HTML
139 lines
11 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="User FAQs" />
|
|||
|
|
<meta name="abstract" content="This topic collection concentrates on describing iSeries support for distributed relational databases in a network of iSeries servers (a like environment)." />
|
|||
|
|
<meta name="description" content="This topic collection concentrates on describing iSeries support for distributed relational databases in a network of iSeries servers (a like environment)." />
|
|||
|
|
<meta name="DC.subject" content="cross-platform DRDB notes, DRDB, cross-platform, notes, cross-platform DRDB" />
|
|||
|
|
<meta name="keywords" content="cross-platform DRDB notes, DRDB, cross-platform, notes, cross-platform DRDB" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1kickoff.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1apennonconversion.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1apendixqccsid.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1apenccsidconversion.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1sql5048n.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1faqjournal.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1ques2.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1faqinterpsqlcode.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1faqwhere.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1faquselibrarylist.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1faquserofdb2connspecify.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1norows.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="db2connect.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="conscroll.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1othertips.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1serversupport.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="rbal1xplat" />
|
|||
|
|
<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>User FAQs</title>
|
|||
|
|
</head>
|
|||
|
|
<body id="rbal1xplat"><a name="rbal1xplat"><!-- --></a>
|
|||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|||
|
|
<h1 class="topictitle1">User FAQs</h1>
|
|||
|
|
<div><p>This topic collection concentrates on describing <span class="keyword">iSeries™</span> support
|
|||
|
|
for distributed relational databases in a network of <span class="keyword">iSeries server</span>s
|
|||
|
|
(a <em>like</em> environment).</p>
|
|||
|
|
<p>Many distributed relational database implementations exist in a network
|
|||
|
|
of different DRDA-supporting platforms. This topic collection provides a list
|
|||
|
|
of tips and techniques you might need to consider when using the <span class="keyword">iSeries server</span> in an <em>unlike</em> DRDA<sup>®</sup> environment.</p>
|
|||
|
|
<p>This topic collection describes some conditions you need to consider when
|
|||
|
|
working with another specific IBM<sup>®</sup> product. It is not intended to be a
|
|||
|
|
comprehensive list. Many problems or conditions like the ones described here
|
|||
|
|
depend significantly on your application. You can get more information about
|
|||
|
|
the differences between the various IBM platforms from the <cite>IBM SQL Reference
|
|||
|
|
Volume 2</cite>, SC26-8416, or the <cite>DRDA Application Programming Guide</cite>,
|
|||
|
|
SC26-4773.</p>
|
|||
|
|
</div>
|
|||
|
|
<div>
|
|||
|
|
<ul class="ullinks">
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1apennonconversion.htm">Connect to a distributed relational database</a></strong><br />
|
|||
|
|
When you connect from a non-iSeries application requester (AR)
|
|||
|
|
to a DB2
|
|||
|
|
Universal Database™ for iSeries application server (AS), columns tagged with
|
|||
|
|
CCSID 65535 are not converted. If the files that contain these columns do
|
|||
|
|
not contain any columns that have a CCSID explicitly identified, the CCSID
|
|||
|
|
of all character columns can be changed to another CCSID value. To change
|
|||
|
|
the CCSID, use the <span class="cmdname">Change Physical File (CHGPF)</span> command.
|
|||
|
|
If you have logical files built over the physical file, follow the directions
|
|||
|
|
given in the recovery topic of the error message (CPD322D) that you get.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1apendixqccsid.htm">iSeries system value QCCSID</a></strong><br />
|
|||
|
|
The <span class="keyword">iSeries server</span> is
|
|||
|
|
shipped with a QCCSID system value set to 65535.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1apenccsidconversion.htm">CCSID conversion considerations for DB2 Universal Database for z/OS and DB2 Universal Database server for VM database managers</a></strong><br />
|
|||
|
|
One of the differences between a <span class="keyword">DB2 Universal Database™ for iSeries</span> and
|
|||
|
|
other DB2<sup>®</sup> databases
|
|||
|
|
is that the iSeries system
|
|||
|
|
supports a larger set of CCSIDs. This can lead to errors when the other database
|
|||
|
|
managers attempt to perform character conversion on the data (SQLCODE –332
|
|||
|
|
and SQLSTATE 57017).</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1sql5048n.htm">Why am I getting a SQL5048N message when I attempt to connect from DB2 Universal Database for Linux, UNIX and Windows?</a></strong><br />
|
|||
|
|
The definition of message SQL5048N states that the release level of the database client is not supported by the release level of the database server. However, the message can sometimes be misleading.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1faqjournal.htm">Do iSeries files have to be journaled?</a></strong><br />
|
|||
|
|
Journaling is not required if the client application is using an
|
|||
|
|
isolation level of no-commit (NC) or uncommitted read (UR), and if the <span class="keyword">DB2<sup>®</sup> UDB SQL</span> function determines that the
|
|||
|
|
query data can be blocked. In that case commitment control is not enabled,
|
|||
|
|
which makes journaling unnecessary.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1ques2.htm">When will query data be blocked for better performance?</a></strong><br />
|
|||
|
|
The query data will be blocked if none of these conditions are true.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1faqinterpsqlcode.htm">How do you interpret an SQLCODE and the associated tokens reported in a DBM SQL0969N error message?</a></strong><br />
|
|||
|
|
The client support used with <span>DB2
|
|||
|
|
Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup></span> returns message SQL0969N
|
|||
|
|
when reporting host SQLCODEs and tokens for which it has no equivalent code.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1faqwhere.htm">How can the host variable type in WHERE clauses affect performance?</a></strong><br />
|
|||
|
|
One potential source of performance degradation on an iSeries server
|
|||
|
|
is the client's use in a C program of a floating point variable for a comparison
|
|||
|
|
in the WHERE clause of a SELECT statement.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1faquselibrarylist.htm">Can I use a library list for resolving unqualified table and view names?</a></strong><br />
|
|||
|
|
The iSeries server
|
|||
|
|
supports a limited capability to use the operating system naming option when
|
|||
|
|
accessing <span class="keyword">DB2 Universal Database™ for iSeries</span> data from
|
|||
|
|
a non-iSeries DRDA client
|
|||
|
|
program such as those that use the <span>DB2 Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup></span> product.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1faquserofdb2connspecify.htm">Can a user of DB2 Universal Database for Linux, UNIX and Windows specify that the NLSS sort sequence table of the DRDA job on the iSeries server be used instead of the usual EBCDIC sequence?</a></strong><br />
|
|||
|
|
The iSeries server
|
|||
|
|
recognizes a generic bind option that allows one who prepares a program to
|
|||
|
|
be run from DB2
|
|||
|
|
Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup> or any other client that supports
|
|||
|
|
generic bind options to request that the iSeries server use the NLSS sort sequence
|
|||
|
|
associated with the server job in which the client's request is run.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1norows.htm">Why are no rows returned when I perform a query?</a></strong><br />
|
|||
|
|
One potential cause of this problem is a failure to add an entry
|
|||
|
|
for the <span class="keyword">iSeries server</span> in the DB2
|
|||
|
|
Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup> Database Communication Services
|
|||
|
|
Directory.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="db2connect.htm">What level of DB2 Universal Database for Linux, UNIX, Windows is required to interact with DB2 Universal Database for iSeries?</a></strong><br />
|
|||
|
|
These Fix Packs are required for interaction.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="conscroll.htm">How can I get scrollable cursor support enabled from DB2 Universal Database for Linux, Unix and Windows Version 8 to the iSeries?</a></strong><br />
|
|||
|
|
You must be using FixPak 4 or later on the client.</li>
|
|||
|
|
<li class="ulchildlink"><strong><a href="rbal1othertips.htm">Other tips for interoperating in unlike environments</a></strong><br />
|
|||
|
|
This topic collection provides additional information for using DB2
|
|||
|
|
Universal Database™ for iSeries with DB2 Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup>.
|
|||
|
|
These tips were developed from experiences testing with the products on an OS/2<sup>®</sup> platform,
|
|||
|
|
but it is believed that they apply to all environments to which they have
|
|||
|
|
been ported.</li>
|
|||
|
|
</ul>
|
|||
|
|
|
|||
|
|
<div class="familylinks">
|
|||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1kickoff.htm" title="Distributed database programming describes the distributed relational database management portion of the i5/OS licensed program. Distributed relational database management provides applications with access to data that is external to the applications and typically located across a network of computers.">Distributed database programming</a></div>
|
|||
|
|
</div>
|
|||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
|||
|
|
<div><a href="rbal1serversupport.htm" title="The default CCSID for a job on the iSeries server is specified using the Change Job (CHGJOB) command.">iSeries server support</a></div>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</body>
|
|||
|
|
</html>
|