Database administration

Db2® for i provides various methods for setting up and managing databases.

Accessing data through client interfaces
You can access Db2 for i data through client interfaces on the server, such as the Java Database Connectivity (JDBC) driver, the Open Database Connectivity (ODBC) driver, IBM i Portable Application Solutions Environment (IBM i PASE), OLE DB Provider, .Net Provider, Net.Data®, or Distributed Relational Database Architecture™ (DRDA).
Altering and managing database objects
Db2 for i provides both Structured Query Language (SQL) and system methods for altering and managing database objects.
Creating database objects
The first step in developing your database is to create the objects that hold your data. You can create tables, views, and indexes with SQL. You can also create physical and logical files using the traditional system interface.
Ensuring data integrity
Db2 for i provides several integrity measures, such as constraints, trigger programs, and commitment control.
Importing and exporting data between systems
Importing data is the process of retrieving data from external sources, while exporting data is the process of extracting data from Db2 for i and copying data to another system.
Working with multiple databases
The system provides a system database (identified as SYSBAS) and the ability to work with one or more user databases.
Working with system-period temporal tables
Defining a system-period temporal table allows you to maintain historical versions of the table's rows. A system-period temporal table stores current versions of your data and uses its associated history table to store prior versions of rows that were updated or deleted.
Working with triggers and constraints
You can use triggers or constraints to manage data in your database tables.
Writing DB2 programs
Db2 for i provides various methods for writing applications that access or update data.

Parent topic: Database administration

Related concepts

Journal management