Database Administration

From InterBase

InterBase provides both GUI and command-line tools for managing databases and servers. You can perform database administration on databases residing on Local InterBase or InterBase Server with IBConsole, a Windows application running on a client PC. You can also use command-line database administration utilities on the server.

IBConsole and command-line tools enable the database administrator to:

  • Manage server security
  • Back up and restore a database
  • Perform database maintenance
  • View database and lock manager statistics

You can find more information on server security later in this chapter, and later chapters describe individual tasks you can accomplish with IBConsole and the command-line tools.

Managing Server Security

InterBase maintains a list of user names and passwords in a security database. The security database allows clients to connect to an InterBase database on a server if a user name and password supplied by the client match a valid user name and password combination in the InterBase security database (admin.ib by default), on the server.

Note: Starting with version XE7 InterBase implements stronger password protection on InterBase databases. See Implementing Stronger Password Protection.

You can add and delete user names and modify a user’s parameters, such as password and user ID.

For information about managing server security, see Database User Management.

Backing Up and Restoring Databases

You can backup and restore a database using IBConsole or command-line gbak. A backup can run concurrently with other processes accessing the database because it does not require exclusive access to the database.

Database backup and restoration can also be used for:

  • Erasing obsolete versions of database records
  • Changing the database page size
  • Changing the database from single-file to multifile
  • Transferring a database from one operating system to another
  • Backing up only a database’s metadata to recreate an empty database

For information about database backup and recovery, see About InterBase backup and restore options.

Maintaining a Database

You can prepare a database for shutdown and perform database maintenance using either IBConsole or the command-line utilities. If a database incurs minor problems, such as an operating system write error, these tools enable you to sweep a database without taking the database off-line.

Some of the tasks that are part of database maintenance are:

  • Sweeping a database
  • Shutting down the database to provide exclusive access to it
  • Validating table fragments
  • Preparing a corrupt database for backup
  • Resolving transactions “in limbo” from a two-phase commit
  • Validating and repairing the database structure

For information about database maintenance, see Database Configuration and Maintenance.

Viewing Statistics

You can monitor the status of a database by viewing statistics from the database header page, and an analysis of tables and indexes. For more information, see Database Statistics and Connection Monitoring.