230 lines
16 KiB
HTML
230 lines
16 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="reference" />
|
|
<meta name="DC.Title" content="Related information" />
|
|
<meta name="abstract" content="Listed here are the IBM Redbooks (in PDF format), Web sites, and information center topics that relate to DB2 Universal Database for iSeries. You can view or print any of the PDFs." />
|
|
<meta name="description" content="Listed here are the IBM Redbooks (in PDF format), Web sites, and information center topics that relate to DB2 Universal Database for iSeries. You can view or print any of the PDFs." />
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2004, 2006" />
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2004, 2006" />
|
|
<meta name="DC.Format" content="XHTML" />
|
|
<meta name="DC.Identifier" content="rzatdadd.dita" />
|
|
<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>Related information</title>
|
|
</head>
|
|
<body id="rzatdadd.dita"><a name="rzatdadd.dita"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Related information</h1>
|
|
<div><p>Listed here are the IBM<sup>®</sup> Redbooks™ (in PDF format), Web sites,
|
|
and information center topics that relate to DB2 Universal Database™ for iSeries™.
|
|
You can view or print any of the PDFs.</p>
|
|
<div class="section"><div class="p">In addition to the <a href="../rzahg/rzahgdb.htm">DB2<sup>®</sup> UDB
|
|
for iSeries</a> topic,
|
|
you can read the following topics: <ul><li><a href="#rzatdadd.dita__ictopics">iSeries Information Center topics</a></li>
|
|
<li><a href="#rzatdadd.dita__redbooks">Redbooks</a></li>
|
|
<li><a href="#rzatdadd.dita__webrelated">Web sites</a></li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="rzatdadd.dita__ictopics"><a name="rzatdadd.dita__ictopics"><!-- --></a><h4 class="sectiontitle">iSeries Information Center topics</h4><div class="p">You
|
|
can find database-related information in the following iSeries Information Center topics:<ul><li><a href="../rzalw/rzalwoverview.htm">Availability roadmap</a> <p>This
|
|
topic explains the measurement of how often your data and applications are
|
|
ready for you to access when you need them.</p>
|
|
</li>
|
|
<li><a href="../rzahg/rzahgbackup.htm">Backup and recovery</a><p>This
|
|
topic contains information about how to plan a backup and recovery strategy,
|
|
how to set up disk protection for your data, how to back up your system, and
|
|
how to control your system shutdown in the event of a failure.</p>
|
|
</li>
|
|
<li><a href="../dm/rbal3kickoff.htm">Database file management</a><p>This topic covers traditional file management. File management
|
|
is the part of the i5/OS™ operating system that controls the storing and
|
|
accessing of traditional file objects (*FILE objects in the QSYS.LIB library)
|
|
on the iSeries server.</p>
|
|
</li>
|
|
<li><a href="../experience/oraclemigabstract.htm">Oracle
|
|
migration experience report</a> <p>This experience report describes the
|
|
process of migrating an Oracle database to DB2 UDB for iSeries using the Oracle Migration Toolkit
|
|
(MTK).</p>
|
|
</li>
|
|
<li><a href="../rzahg/rzahgicprog2.htm">Programming</a><div class="p">This
|
|
topic contains reference information about application programming interfaces
|
|
(APIs) and CL commands used for database functions.<ul><li><a href="../apiref/api.htm">Application programming interfaces
|
|
(APIs)</a></li>
|
|
<li><a href="../rbam6/rbam6clmain.htm">Control language (CL)</a></li>
|
|
<li><a href="../rzakc/kickoff.htm">DDS for display files</a></li>
|
|
<li><a href="../rzakd/kickoff.htm">DDS for printer files</a></li>
|
|
<li><a href="../rzake/kickoff.htm">DDS for ICF files</a></li>
|
|
</ul>
|
|
</div>
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="rzatdadd.dita__redbooks"><a name="rzatdadd.dita__redbooks"><!-- --></a><h4 class="sectiontitle">Redbooks</h4><ul><li><a href="http://www.redbooks.ibm.com/abstracts/sg245746.html" target="_blank">A DB2 Enterprise Query Environment - Build it with QMF™ for Windows<sup>®</sup>!,
|
|
SG24-5746-00</a><img src="rbpdf.gif" alt="Link to PDF" /> <p>This
|
|
redbook helps you design and carry out a solution to build an Enterprise Query
|
|
Environment using QMF for Windows. It discusses specifics for
|
|
three typical users of this product: database administrators, application
|
|
developers, and end-users. It describes the WWW functionality and other specifics
|
|
of the product, such as its capabilities for Business-to-Business and Customer-to-Business
|
|
applications. The information provided particularly applies to Version 6,
|
|
Release 1 Refresh of QMF for Windows, Program Number 5655-DB2, for
|
|
use with the Windows NT<sup>®</sup> Operating System.</p>
|
|
</li>
|
|
<li><a href="http://www.redbooks.ibm.com/abstracts/sg244249.html" target="_blank">Advanced Functions and Administration on DB2
|
|
Universal Database™ for iSeries, SG24-4249-03 </a><img src="rbpdf.gif" alt="Link to PDF" /><p>This redbook is unique in its
|
|
detailed coverage of DB2 UDB for iSeries advanced functions. It is intended
|
|
for programmers, analysts, and database designers who intend to develop applications
|
|
for the DB2 UDB
|
|
for iSeries relational
|
|
database system, which is integrated into the operating system available on
|
|
the iSeries server.
|
|
The purpose of the redbook is to provide suggestions, guidelines and practical
|
|
examples about when and how the advanced functions offered by DB2 UDB for iSeries can
|
|
be effectively used.</p>
|
|
</li>
|
|
<li><a href="http://www.redbooks.ibm.com/abstracts/sg245183.html" target="_blank">A Fast Path to AS/400<sup>®</sup> Client/Server Using AS/400 OLE
|
|
DB Support, SG24-5183-00 </a><img src="rbpdf.gif" alt="Link to PDF" /> <p>If you have ever wanted to develop the Microsoft<sup>®</sup> Windows programs that work with the iSeries system,
|
|
you will want to learn about the iSeries OLE DB support. It provides a
|
|
tremendous improvement over previously used techniques. Two of the key considerations
|
|
that the iSeries OLE
|
|
DB support addresses are ease of application development while still providing
|
|
acceptable performance. This redbook gives a broad understanding of the OLE
|
|
DB architecture and how it can be used to access iSeries resources.</p>
|
|
</li>
|
|
<li><a href="http://www.redbooks.ibm.com/abstracts/sg245189.html" target="_blank">AS/400 Remote Journal Function for High Availability
|
|
and Data Replication, SG24-5189-00</a><img src="rbpdf.gif" alt="Link to PDF" /> <p>This redbook provides suggestions, guidelines,
|
|
and practical examples about when and how to efficiently use the remote journal
|
|
function provided by the i5/OS operating system. The book is intended for system
|
|
administrators, high availability specialists, and independent software vendors
|
|
(ISVs). It specifically focuses on their needs to implement a high availability
|
|
solution for the iSeries server.
|
|
However, before reading this book, you must be familiar with journal function
|
|
concepts.</p>
|
|
</li>
|
|
<li><a href="http://www.redbooks.ibm.com/abstracts/sg245485.html" target="_blank">Cross-Platform DB2 Stored Procedures: Building and Debugging,
|
|
SG24-5485-01</a><img src="rbpdf.gif" alt="Link to PDF" /><p>This
|
|
redbook is intended for DB2 application developers who are familiar with Structured
|
|
Query Language (SQL) and stored procedures, and who want to learn about developing
|
|
stored procedures in the SQL Procedures language, as well as using and exploring
|
|
the Stored Procedure Builder (SPB). This redbook particularly applies to Version
|
|
6 of DB2 UDB
|
|
Server for OS/390<sup>®</sup>,
|
|
for iSeries,
|
|
and for distributed platforms, Version 5 of DB2 Server for OS/390, and other current versions and
|
|
releases of IBM products.</p>
|
|
</li>
|
|
<li><a href="http://www.redbooks.ibm.com/abstracts/sg245409.html" target="_blank">DB2 UDB for AS/400 Object Relational Support, SG24-5409-00</a><img src="rbpdf.gif" alt="Link to PDF" /><p>Learn to efficiently use Universal
|
|
Database (UDB) functions provided by the iSeries database with the suggestions,
|
|
guidelines, and examples in this redbook. This redbook is intended for programmers,
|
|
analysts, and database administrators. It focuses on the need to take the
|
|
database applications beyond traditional numeric and character data to images,
|
|
video, voice, and complex documents. By reading this redbook, you gain a broad
|
|
understanding of DB2 UDB for iSeries implementation that you can use
|
|
for building a new generation of multimedia and Web-enabled database applications.</p>
|
|
</li>
|
|
<li><img src="./delta.gif" alt="Start of change" /><a href="http://www.redbooks.ibm.com/abstracts/sg246092.html?Open" target="_blank">DB2
|
|
Universal Database for iSeries Administration: The Graphical Way on V5R3,
|
|
SG24-6092-00</a><img src="rbpdf.gif" alt="Link to PDF" /><p>This
|
|
redbook presents an overview of all V5R2 iSeries Navigator functions to manage
|
|
and administer DB2 UDB
|
|
for iSeries.
|
|
It serves as a companion guide for the database administrator to use DB2 UDB for iSeries.
|
|
This redbook includes the latest announced features in V5R3 that iSeries Navigator
|
|
provides for the database administrator of DB2 UDB for iSeries.</p>
|
|
<img src="./deltaend.gif" alt="End of change" /></li>
|
|
<li><img src="./delta.gif" alt="Start of change" /><a href="http://www.redbooks.ibm.com/abstracts/sg246440.html?Open" target="_blank">Integrating DB2 Universal Database for iSeries with Microsoft ADO
|
|
.NET, SG24-6440-00</a><img src="rbpdf.gif" alt="Link to PDF" /><p>This
|
|
redbook shows customers how to use ADO.NET effectively to harness the power
|
|
of DB2 UDB
|
|
for iSeries,
|
|
showing examples, best practices, pitfalls, and comparisons between the different
|
|
ADO.NET providers.</p>
|
|
<img src="./deltaend.gif" alt="End of change" /></li>
|
|
<li><img src="./delta.gif" alt="Start of change" /><a href="http://www.redbooks.ibm.com/abstracts/sg246393.html?Open" target="_blank">Modernizing IBM eServer™ iSeries Application Data Access - A Roadmap
|
|
Cornerstone, SG24-6393-00</a><img src="rbpdf.gif" alt="Link to PDF" /><p>Many customers are in the process of modernizing their database
|
|
definition and database access. This redbook will help you understand how
|
|
to reverse engineer a DDS-created database and provides you with tips and
|
|
techniques for modernizing applications to use SQL as the database access
|
|
method.</p>
|
|
<img src="./deltaend.gif" alt="End of change" /></li>
|
|
<li><img src="./delta.gif" alt="Start of change" /><a href="http://www.redbooks.ibm.com/abstracts/sg246503.html?Open " target="_blank">Stored Procedures, Triggers and User Defined Functions on DB2
|
|
Universal Database for iSeries, SG24-6503-01 </a><img src="rbpdf.gif" alt="Link to PDF" /> <p>This redbook includes the latest announced features
|
|
in V5R1 and V5R2 on stored procedures, triggers and user-defined functions.
|
|
You will find suggestions, guidelines, and practical examples about how to
|
|
effectively develop DB2 UDB for iSeries stored procedures, triggers and
|
|
user-defined functions.</p>
|
|
<img src="./deltaend.gif" alt="End of change" /></li>
|
|
<li><a href="http://www.redbooks.ibm.com/abstracts/redp0502.html" target="_blank">Using AS/400 Database Monitor and Visual Explain to Identify
|
|
and Tune SQL Queries, REDP0502</a><img src="rbpdf.gif" alt="Link to PDF" /><p>The purpose of this redbook is to help you understand the basics
|
|
of identifying and tuning the performance of Structured Query Language (SQL)
|
|
statements using DB2
|
|
Universal Database for AS/400. DB2 UDB for AS/400 provides a comprehensive set of
|
|
tools for helping technical analysts tune SQL queries. The Database Monitor
|
|
(DB Monitor) and Operations Navigator Visual Explain are both described in
|
|
this redbook.</p>
|
|
<p>This redbook presents a series of tips and techniques
|
|
based on DB Monitor and Visual Explain that can be used to demonstrate how
|
|
to get the most out of both DB2 UDB for AS/400 and query optimizer when using
|
|
SQL. You must be aware that usage of DB Monitor is technically demanding. IBM offers
|
|
Learning Services courses on database tools and analysis to help you.</p>
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
<div class="section" id="rzatdadd.dita__webrelated"><a name="rzatdadd.dita__webrelated"><!-- --></a><h4 class="sectiontitle">Web sites</h4><ul><li><a href="http://www-1.ibm.com/servers/enable/site/db2/iseries/start.html" target="_blank">Browse resources DB2 UDB for iSeries</a><img src="www.gif" alt="Link outside information center" /><p>This site provides information to help you fully
|
|
leverage DB2 UDB
|
|
for iSeries,
|
|
including the self-study courses you can take over the Internet.</p>
|
|
</li>
|
|
<li><img src="./delta.gif" alt="Start of change" /><a href="http://www-1.ibm.com/servers/eserver/iseries/db2/ddqb.html" target="_blank">Data Discovery and Query Builder</a><img src="www.gif" alt="Link outside information center" /><p>The IBM Data Discovery and Query Builder product
|
|
makes time-intensive, costly and complex searches simple. Making use of industry-leading
|
|
Web serving and data storage technologies such as WebSphere<sup>®</sup> and DB2 Universal Database,
|
|
Data Discovery and Query Builder is a Web-based framework that helps users
|
|
query broad categories of data and identify correlations. By giving users
|
|
the ability to construct complex queries without complex languages or user
|
|
interfaces, Data Discovery and Query Builder lets users spend more time analyzing
|
|
and identifying correlations between and within data sets rather than manually
|
|
searching through records or requiring the intervention of a database administrator.</p>
|
|
<img src="./deltaend.gif" alt="End of change" /></li>
|
|
<li><a href="http://www.iseries.ibm.com/db2" target="_blank">DB2
|
|
Universal Database for iSeries home page</a><img src="www.gif" alt="Link outside information center" /><p>This site offers information about iSeries products,
|
|
tips, and concepts. These pages are being updated constantly; turn to this
|
|
resource for the latest information. To reach the DB2 UDB for iSeries pages, click the Products link
|
|
and then click the DB2 UDB for iSeries link.</p>
|
|
</li>
|
|
<li><a href="http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html" target="_blank">The SQL Reference for Cross-Platform Development</a><img src="www.gif" alt="Link outside information center" /><p>This site
|
|
enables you to develop SQL applications that are portable across the DB2 UDB Family,
|
|
including DB2
|
|
Universal Database for z/OS<sup>®</sup> and OS/390 Version 7, DB2 UDB for iSeries Version 5 Release 2, and DB2
|
|
Universal Database for Linux<sup>®</sup>, UNIX<sup>®</sup>, and Windows Version 8.1.</p>
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
<div class="section"><h4 class="sectiontitle">Saving PDF files</h4><div class="p">To save a PDF on your workstation
|
|
for viewing or printing:<ol><li>Right-click the PDF in your browser (right-click the link above).</li>
|
|
<li><img src="./delta.gif" alt="Start of change" />Click the option that saves the PDF locally.<img src="./deltaend.gif" alt="End of change" /></li>
|
|
<li>Navigate to the directory in which you want to save the PDF.</li>
|
|
<li>Click <span class="uicontrol">Save</span>.</li>
|
|
</ol>
|
|
</div>
|
|
</div>
|
|
<div class="section"><h4 class="sectiontitle">Downloading Adobe Reader</h4><p><img src="./delta.gif" alt="Start of change" />You need Adobe
|
|
Reader installed on your system to view or print these PDFs. You can download
|
|
a free copy from the <a href="http://www.adobe.com/products/acrobat/readstep.html" target="_blank">Adobe Web site</a> (www.adobe.com/products/acrobat/readstep.html)<img src="www.gif" alt="Link outside information center" />.<img src="./deltaend.gif" alt="End of change" /></p>
|
|
</div>
|
|
</div>
|
|
<div></div>
|
|
</body>
|
|
</html> |