media/image13.png

A single-user interactive session is one in which only a single user can interact with a database.

There are a number of administration tasks that require exclusive access to a database, such as:

  • Schema changes
  • Roll-forward recovery of a database
  • Rebuilding of indexes
  • Truncation of the BI files
  • Converting a database from an older version of OpenEdge to a newer version

In addition, if your environment allows you to have regular downtime for database maintenance tasks, there are a number of tasks you may want to perform in single-user mode, such as:

  • Offline dumping and loading of data
  • Offline bulk loading of a database
  • Offline backup and restoring of a database
  • Offline adding files to the database
  • Offline enablement of after-imaging
  • Offline enablement of automatic AI file management