Related information

 

Listed here are the information center topic collections, IBM^® Redbooks™ (in PDF format), and Web sites that relate to DB2 Universal Database™ for iSeries™ (DB2^® UDB for iSeries). You can view or print any of the PDFs.

 

i5/OS Information Center topic collections

You can find database-related information in the following information center topic collections:

• Availability roadmap

  This topic collection explains the measurement of how often your data and applications are ready for you to access when you need them.

• Backup and recovery

  This topic collection 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.

• Database file management

  This topic collection 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).

• Database migration experience report

  This experience report describes the process of migrating competing database products to DB2 UDB for iSeries using the IBM Migration Toolkit (MTK).

• ProgrammingThis category contains reference information about application programming interfaces (APIs), control language (CL) commands, and data description specifications (DDS) that are used for database functions.

  • Application programming interfaces

  • Control language

  • DDS for display files

  • DDS for printer files

  • DDS for ICF files

 

IBM Redbooks

• A DB2 Enterprise Query Environment - Build it with QMF for Windows!, SG24-5746-00

  

  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^® operating system.

• Advanced Functions and Administration on DB2 Universal Database for iSeries, SG24-4249-03

  

  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. The purpose of the redbook is to provide suggestions, guidelines and practical examples for when and how the advanced functions offered by DB2 UDB for iSeries can be effectively used.

• A Fast Path to AS/400^® Client/Server Using AS/400 OLE DB Support, SG24-5183-00

  

  If you want to develop Microsoft^® Windows programs that work with the AS/400 systems, you might want to learn about the AS/400 OLE DB support. It provides a tremendous improvement over previously used techniques. Two of the key considerations that the AS/400 OLE DB support addresses are ease of application development while providing acceptable performance. This redbook gives a broad understanding of the OLE DB architecture and how it can be used to access AS/400 resources.

• AS/400 Remote Journal Function for High Availability and Data Replication, SG24-5189-00

  

  This redbook provides suggestions, guidelines, and practical examples for when and how to efficiently use the remote journal function provided by Operating System/400^® (OS/400^®). 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 their systems. However, before reading this book, be familiar with the journal function concepts.

• DB2 UDB for AS/400 Object Relational Support, SG24-5409-00

  

  This redbook provides suggestions, guidelines, and examples for efficiently using DB2 UDB for iSeries functions. The book 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.

• DB2 Universal Database for iSeries Administration: The Graphical Way on V5R3, SG24-6092-00

  

  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.

• Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET, SG24-6440-00

  

  This redbook instructs customers on how to use ADO.NET effectively to harness the power of DB2 UDB for iSeries. The book also shows examples, best practices, pitfalls, and comparisons among different ADO.NET providers.

• Modernizing IBM eServer™ iSeries Application Data Access - A Roadmap Cornerstone, SG24-6393-00

  

  Many customers are in the process of modernizing their database definition and database access. This redbook helps you understand how to reverse engineer a DDS-created database and provides tips and techniques for modernizing applications to use SQL as the database access method.

• Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries, SG24-6503-01

  

  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 for effectively developing DB2 UDB for iSeries stored procedures, triggers, and user-defined functions.

• Using AS/400 Database Monitor and Visual Explain to Identify and Tune SQL Queries, REDP0502

  

  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.

  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.

 

Web sites

• Browse resources DB2 UDB for iSeries

  

  This Web site provides information to help you fully leverage DB2 UDB for iSeries, including the self-study courses you can take over the Internet.

• Data Discovery and Query Builder

  

  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^® 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 allows users to 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.

• DB2 Universal Database for iSeries home page

  

  This Web site offers the latest information about DB2 Universal Database for iSeries.

• The SQL Reference for Cross-Platform Development

  

  This Web site enables you to develop SQL applications that are portable across the DB2 UDB family, including DB2 Universal Database for z/OS^® and OS/390^® Version 7, DB2 UDB for iSeries Version 5 Release 2, and DB2 Universal Database for Linux^®, UNIX^®, and Windows Version 8.1.

 

Saving PDF files

To save a PDF on your workstation for viewing or printing:

1. Right-click the PDF in your browser (right-click the link above).

2. Click the option that saves the PDF locally.

3. Navigate to the directory in which you want to save the PDF.

4. Click Save.

 

Downloading Adobe Reader

You need Adobe Reader installed on your system to view or print these PDFs. You can download a free copy from the Adobe Web site (www.adobe.com/products/acrobat/readstep.html)

.