Database administration

 

DB2^® UDB for iSeries™ provides various methods for setting up and managing databases.

• Altering and managing database objects
  DB2 UDB for iSeries 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 file interface.

• Ensuring data integrity
  DB2 UDB for iSeries 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 UDB for iSeries and copying data to another system.

• Managing journals
  You can use journal management to audit database activities on your system, as well as recovering database changes.

• 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 triggers and constraints
  You can use triggers or constraints to manage data in your database tables.

• Writing DB2 programs
  DB2 UDB for iSeries provides various methods for writing applications that access or update data.

 

Parent topic:

Administration