Database

 

Welcome to DB2 Universal Database(TM) for iSeries(TM) information. This information enables you to take advantage of the DB2 Universal Database (UDB) for iSeries database to access and manage server data through an application or a user interface.

As well as providing access to and protection for your data, DB2 UDB for iSeries provides advanced functions such as referential integrity and parallel database processing.

Printable PDFs
Use the Printable PDFs topic to access DB2 manuals in HTML or in PDF format for printing.

Database overview
Database overview contains information to get you started with database, including a general description of DB2 UDB for iSeries, common terminology, and tutorials for database access methods.

Database information finder
Use the Database information finder to quickly find DB2 and SQL information and examples.

Administration
Administrative topics provide the key "how-to" information for DB2 UDB for iSeries. Included in Administration are commitment control, database backup and recovery, distributed database administration, queries and reports, security, and methods for working with database objects and data.

Commitment control
Commitment control is a function that ensures data integrity. It allows you to define and process a group of changes to resources, such as database files or tables, as a transaction. Commitment control ensures that either the entire group of individual changes occurs on all systems that participate or that none of the changes occurs.

Database performance and query optimization
Maximize database and SQL performance with the information contained in this topic.

Programming
See resources for database, SQL, and embedded SQL programming.

Reference
Find SQL and distributed data reference information. You can also use the Database information finder to quickly find database and SQL information and examples.

Troubleshooting
Here are the solutions to common questions and problems for DB2 Universal Database for iSeries (DB2 UDB for iSeries).

Related information
Find links to database resources outside the i5/OS(TM) Information Center.