Database Manager CLI: SAP DB 7.4
Functions of the Database Manager CLI
Operator Management in the Database Manager
Operator Properties
Operator Authorizations
Displaying Status Data: DBInfoRead
Executing the Program LOAD: ExecLoad
Executing Operating System Commands: SystemCmd
Performing Backups: Backup
Installation Management: InstallMgm
Loading the System Tables: LoadSysTab
Starting the Database Instance: DBStart
Stopping the Database Instance: DBStop
Managing DBM Operators: UserMgm
Restoring Backups: Recovery
Accessing Database Files (Reading Only): DBFileRead
Accessing Database Parameters (Checked Writing): ParamCheckWrite
Accessing Database Parameters (Reading and Writing): ParamFull
Accessing Database Parameters (Reading Only): ParamRead
Access to SQL Session: AccessSQL
Access to Utility Session: AccessUtility
Opening a DBM Server Session
Logging On to the Database Manager
Command Structure
Input Help
Comment: #
Local System Call: !
Linking Lines: /
Linking Lines: <
Options
Logging On to the XUSER Program: -ux
Displaying the Parameters for an XUSER Entry: -up
Display of XUSER Data: -ul
Opening a Service Session: -uSRV
Opening an SQL Session: -uSQL
Opening a Utility Session: -uUTL
Installation Directory of the Database Software: -R
Indicator as DBM Command: -c
Local Operation: -s
Deleting XUSER Data: -ud
Name of the Output File: -o
Name of Database Instance: -d
Name of the Log File: -t
Name of the Database Server: -n
Name of the Input Script: -i
Storing XUSER Data: -us
Version of the Database Manager: -V
XUSER Key: -uk
DBM Commands
Analyzing the Database Instance
Database Trace Functions
Overview of the Database Trace Commands
Displaying the Options for the Text Version of the Database Trac
Displaying the Logged Activities of the Database Trace
Deactivating the Database Trace
Creating the Text Version of the Database Trace
Accessing the Database Analyzer Program
Overview of the Commands for the Database Analyzer
Calling the Database Analyzer
Example of a Successful Call of the Database Analyzer
Example of an Error when Calling the Database Analyzer
Ending the Database Analyzer
Example of Ending the Database Analyzer Successfully
Examples of Errors when Ending the Database Analyzer
Determining the Status of the Database Analyzer
Example of Determining the Status Successfully
Example of an Error when Determining the Status
Accessing Database Files
Overview of the Commands for Accessing Database Files
Displaying the Diagnosis History
Editing Log Files of the Database Instance
Scrolling Through a Database File
List of the Database Files
Opening a Database File
Packing Database Files
Backing Up a Database File
Restoring a Database File
Logging On to the Operating System
Displaying the Version Information of the Database Manager
Executing the liveCache Initialization Script
Ending the Database Manager
Functions for Database Operation
Overview of the Commands for Database Operation
Updating Optimizer Statistics with the XPU Program
Displaying the Database Kernel Variant
Displaying the Operational State of the Database Instance
Displaying Information About the Database Instance
Using the Database Console
Scrolling in the Information About the Database Instance
Loading the System Tables
Loading SAP-Specific Tables
List of the Information About the Database Instance
Deleting Runtime Information After a Database Error
Restarting the Database Instance
Starting the Database Instance
Starting the LOAD Program
Starting the PythonLOAD Program
Stopping the Database Instance
Transferring to the ADMIN Operational State
Transferring to the OFFLINE Operational State
Transferring to the ONLINE Operational State
Installation and Registration Management
Overview of the Commands for Installation and Registration Manag
Displaying the Version-Independent Directories
Changing the Software Version of the Current Database Instance
Defining the Version-Independent Directories
List of All Registered Database Instances
List of All Registered Versions of the Database Software
Deleting the Current Database Instance
db_drop Command: Example
Deleting the Registration of a Variant of the Current Database I
Deleting the Registration of a Version of the Database Software
Creating a Database Instance
Kernel Variant -a | -auto
Kernel Variant -f | -fast
Kernel Variant -q | -quick
Kernel Variant -s | -slow
db_create Command: Example
Registering a Variant of the Current Database Instance
Registering a Version of the Database Software
Configuring the Database Manager
Displaying a Configuration Parameter of the Database Manager
Changing a Configuration Parameter of the Database Manager
Configuring Database Instances
Parameter Properties
Overview of the Commands for Configuring Database Instances
Terminating a Parameter Session
Changing the Value of a Database Parameter
param_put Command: Example
Changing Volume Parameters
Displaying All Data for a Database Parameter
param_getfull Command: Example
Displaying All Properties for a Database Parameter
Displaying All Parameters of the Current Database Parameter File
Displaying the Data for All Database Parameters
Displaying the Data for All Volume Parameters
Displaying the Data of an Individual Volume Parameter
Displaying the Current Value of a Database Parameter
Displaying the Data Type of a Database Parameter
Displaying the Stored Explanatory Text
Displaying the Stored Help Text
Displaying the System Default Value
Displaying a Value from the Database Parameter File
Displaying Individual Data for a Database Parameter
Confirming Changes to the Database Parameter File
Scrolling in the Database Parameter History
Changing a Value Directly in the Database Parameter File
Opening a Parameter Session
Adding a Volume
Initializing the Database Parameters for a New Database Instance
Copying a Database Parameter File
Correcting Parameters
List of the Available Parameter Files
Deleting the Database Parameter File
Deleting a Database Parameter
Deleting Volume Parameters
Opening the Database Parameter History
param_gethistory Command: Example
Checking All Database Parameters
Resetting the Parameter File to a Previous Version
List of the DBM Commands
Backing Up and Recovering Database Instances
Commands for Backup Media
Change Date of the Media Definition File
Defining or Changing a Backup Medium
medium_put Command: Examples
Displaying the Media Data
List of All Defined Backup Media
Deleting a Backup Medium
Transferring an Existing Media Definition
Commands for Backing Up and Archiving
Canceling the Automatic Log Backup
Displaying the Automatic Log Backup Function
Displaying the Current Backup Status
Archiving the Version Files of the Log Area
Creating a Single Archive of the Version Files
Creating Multiple Archives of the Version Files
Deactivating the Automatic Log Backup
Terminating an Interrupted Backup
Activating the Automatic Log Backup
Continuing the Backup Without the Medium Last Reported as Full
Backing Up to a Succeeding Medium
Backing Up the Database Instance
Backing Up with External Backup Tools
Commands for the Backup History
Change Data of the Backup History
Displaying the Backup History
Scrolling in the Backup History
Fetching the Backup History
Closing the Backup History
Commands for External Backup IDs
Displaying External Backup IDs
Scrolling in the External Backup IDs
Releasing the Memory Occupied by the External Backup IDs
Fetching External Backup IDs
Commands for Backup Information
Displaying the Backup Information in the Operational State OFFLI
Displaying the Backup Information in the Operational State ONLIN
Displaying the Current Status of a Backup Check
Checking a Backup
Commands for Restoring
Displaying Current Information About the Database Instance
Displaying the Current Restore Status
Terminating an Interrupted Restore or a Backup Check
Continuing the Parallel Restore or Backup Check
Recovering a Database Instance
Restoring the Parameter File from a Data Backup
Recreating a Damaged Index
Restoring with External Backup Tools
Restoring or Checking a Backup with a Succeeding Medium
Managing the DBM Operators
Changing DBM Operator Data
Creating DBM Operators
Displaying Operator Authorizations
user_getrights Command: Example
Displaying Operator Data
List of DBM Operators
Deleting DBM Operators
Accessing the Database Instance
Overview of Commands for Accessing the Database Instance
Access Using a Utility Session
Activating a New Database Instance
Displaying a Physical Database Page
Terminating a Utility Session
Opening a Utility Session
Writing a Physical Database Page
Transferring a Utility or SQL Command
Access Using an SQL Session
Updating the Optimizer Statistics
Displaying the Structure of a Result Set
Displaying Status Information for the Database Instance
Terminating an SQL Session
Scrolling in the Result Data
Scrolling in the Status Information of the Database Instance
Opening an SQL Session
Transferring an SQL Statement
Access Using a Service Session
Terminating a Service Session
Opening a Service Session
Access to Database Events
Activating a Database Event
Terminating a Database Event Session
Deactivating a Database Event
List of the Activated Database Events
Waiting for a Database Event
Overview of All DBM Commands
Reply Format
Operating Modes
Command Mode
Script Mode
Session Mode
Database Manager Files
Database Manager Log Files
Database Manager Configuration Files
Overview of All DBM Commands