Database Manager GUI: SAP DB 7.4

Calling the Database Manager GUI

Executing Commands in the Database Manager GUI

Creating or Initializing a Database Instance

Managing Database Manager Operators

Changing Operator Passwords

Changing the Operator Authorizations

Assigning Authorizations for Operating System Users

Managing Database Instances

Terminating an Operator Session

Activating and Deactivating Indexes

Updating the Statistics Information

Changing the Log Mode

Changing the Log Mode from SINGLE to DUAL

Changing the Log Mode from DUAL to SINGLE

Changing Volume Parameters

Creating MapChar Sets

DefiningVolumes

Displaying and Changing the Current Database Parameters

Displaying, Changing, and Deleting Mapchar Sets

Defining Volume Parameters

Closing a Database Session Manually

Registering Database Instances

Closing a Parameter Session

Starting the Database Instance (Restart)

Stopping the Database Instance (Shutdown)

Monitoring the Operational State

Connection to the DBM Server

Backing Up Data

Managing the Backup Media

Defining a Single Backup Medium

Defining a Group of Parallel Backup Media

Changing Backup Media

Deleting Backup Media

Backup Processes

Activating and Deactivating the Automatic Log Backup

Backing Up to a Single Backup Medium

Backing Up to a Group of Parallel Backup Media

Backups with Automatic Tape Loaders

Backing Up with External Backup Tools

Backups with Manually Changed Media

Restoring Data

Continuing an Interrupted Restore

Restoring a Backup from the Backup History

Restoring the Indexes After a Database Restore

Restoring the Last Complete Data Backup

Restoring an Existing Database Instance

Restoring a Mirrored Volume

Restoring from Automatic Tape Loaders

Restoring with External Backup Tools

Restoring Without a Backup History

Displaying Information

Displaying User Sessions

Displaying Cache Information

Displaying Data Area Information

Displaying Read and Write Operations

Displaying Log Area and Log Writer Information

Displaying the Backup History

Displaying Locks and Lock Requests

Displaying Versions

Options for Diagnosing Problems

Activating the Database Trace Function

Activating the Event Monitor

Using the Command Line Version of the Program

Checking the Logical Consistency of the Volumes

Displaying OMS Caches

Displaying OMS Class Containers

Activating the OMS Monitor

Checking the Physical Consistency of a Backup

Reading Database Files

Checking the Server of a Database Instance

Installing an Update of the Database Software

Updating the System Tables

Accessing the SQL Studio Program

Screen Areas of the Database Manager GUI