Executing DBM Commands

You execute a command using the command line tool Database Manager CLI (DBM command).

Prerequisites

You are logged on to the database as a database system administrator or DBM operator.

Procedure

Choose Administration in the context menu of the database.
Open the Command Line tab page.

Enter the DBM command.

Overview of All DBM Commands
DBM Command	Description
apropos	Searching for a DBM command
archive_stage	Creating a single archive of backup files (only for log backups)
archive_stage_repeat	Creating multiple archives of backup files (only for log backups)
auto_dbanalyzer	Automatically starting and stopping Database Analyzer
auto_extend	Extending the data area automatically
auto_load_systab	Updating the system tables automatically
auto_update_statistics	Updating the optimizer statistics automatically
autolog_cancel	Exiting an automatic log backup which has been interrupted
autolog_off	Deactivating the automatic log backup function
autolog_on	Activating automatic log backup function
autolog_show	Displaying the automatic log backup function
autorecover	Restoring the database automatically
backup_cancel	Canceling an interrupted backup
backup_cancel_req	DBM command used only by DBM client programs
backup_ext_ids_forget	Releasing the memory occupied by external backup IDs
backup_ext_ids_get	Retrieving external backup IDs
backup_ext_ids_getfromtool	Retrieving backup information stored in the backup tool
backup_ext_ids_list	Displaying the external backup IDs
backup_ext_ids_listnext	Scrolling through the external backup IDs
backup_history_append	Internal system command
backup_history_close	Closing the backup history
backup_history_date	Changing the date of the backup history
backup_history_list	Displaying the backup history
backup_history_listnext	Scrolling through the backup history
backup_history_open	Retrieving the backup history
backup_ignore	Continuing the backup without the data carrier last reported as full
backup_ignore_req	DBM command used only by DBM client programs
backup_replace	Specifying the succeeding data carrier for a backup action
backup_replace_req	DBM command used only by DBM client programs
backup_reply_available	DBM command used only by DBM client programs
backup_reply_receive	DBM command used only by DBM client programs
backup_req	DBM command used only by DBM client programs
backup_start	Backing up the database
backup_state	Displaying the current backup status
bye \| exit \| quit \| release	Exiting Database Manager CLI
db_activate	Initializing a database
db_activate RECOVER	Restoring and initializing a database
db_activate_req	DBM command used only by DBM client programs
db_addvolume	Adding volumes
db_admin	Transferring the database to the ADMIN operating status
db_clear	Deleting the runtime information after a database error
db_connect	Opening a database session
db_cons	Using the XCONS tool (database console)
db_create	Creating a database
db_deletevolume	Deleting a data volume
db_drop	Deleting the current database
db_enum	Displaying a list of all registered databases
db_execute	Executing an administration command or an SQL statement (displaying the complete result list)
db_executenice	Executing an administration command or an SQL statement (displaying the result record-by-record)
db_fetch	Scrolling through the results of an administration command or an SQL statement (displaying the complete result list)
db_fetchnice	Scrolling through the results of an administration command or an SQL statement (displaying the result record-by-record)
db_migratecatalog	DBM command used only by SAP applications
db_offline	Transferring the database to the OFFLINE operational state
db_online	Transferring the database to the ONLINE operational state
db_reg	Updating the registration of a database
db_reinstall	Resetting the database
db_release	Ending a database session
db_restart	Restarting the database
db_restartinfo	Displaying the restart information after importing a backup
db_speed	Displaying the database kernel variant
db_standby	Transferring the database to the STANDBY operational state
db_state	Displaying the operational state of the database
db_stop	Ending a database process
db_unreg	De-registering a database
dban_delete	Deleting the Database Analyzer log files
dban_start	Calling Database Analyzer
dban_state	Displaying the Database Analyzer function
dban_stop	Exiting Database Analyzer
dbm_configget	Displaying a configuration parameter of Database Manager
dbm_configset	Changing a configuration parameter of Database Manager
dbm_execute_serverprocess	Internal system command
dbm_getpath	Displaying the version-independent directories
dbm_getpid	Internal system command
dbm_listmemoryerror	Internal system command
dbm_next	Internal system command
dbm_shm_info	Displaying information about the shared memory
dbm_shm_reset	Resetting the shared memory
dbm_shm_unlock	Unlocking the shared memory
dbm_stop	Ending the DBM server process
dbm_trace	Starting and stopping the DBM server trace function
dbm_version	Displaying the software version
dbmevtdisp_internal_add	Internal system command
dbmevtdisp_internal_communication	Internal system command
dbmevtdisp_internal_delete	Internal system command
diag_histlist	Displaying the diagnosis history
diag_pack	Packing the database files
event_available	Displaying whether any events were triggered
event_delete	Deactivating an event
event_dispatcher	Managing the event dispatcher function
event_list	Displaying a list of active events
event_list_categories	Displaying event categories and their properties
event_receive	Displaying a triggered event
event_release	Ending an event session
event_set	Defining and activating an event
event_wait	Waiting for an event
exec_lcinit	Executing the liveCache initialization script
exec_nipingsrv	DBM command used only by SAP applications
exec_sdbinfo	DBM command used only by SAP applications
exit	Exiting Database Manager CLI
explain	Displaying the help text for a DBM command
file_backup	Backing up a database file
file_getfirst	Opening a database file
file_getlist	Displaying a list of database files
file_getnext	Scrolling through a database file
file_operation	Editing the log files of a database
file_restore	Restoring a database file
get_default	DBM command used only by DBM client programs
help	Displaying a list of DBM commands
hss_addstandby	Defining a standby database
hss_copyfile	Copying database files within a cluster
hss_enable	Defining a database as the master database
hss_execute	Executing DBM commands in a standby database
hss_getnodes	Displaying hot standby parameters
hss_removestandby	Deleting a standby database
info	Displaying the status information of the database
info_next	Scrolling through the status information of the database
inst_enum	Displaying a list of all registered versions of the database software
inst_info	DBM command used only by SAP applications
inst_reg	Registering a version of the database software
inst_unreg	Deleting registration of a database software version
load_lcapps	Loading the application libraries
load_r3tab	Loading SAP-specific tables
load_systab	Updating the system tables
load_tutorial	Loading the SQL tutorial files
medium_date	Displaying the change date of the template definition file
medium_delete	Deleting a backup template
medium_delete_nodistribute	Internal system command with hot standby configurations
medium_get	Displaying the data of the backup template
medium_getall	Displaying a list of all defined backup templates
medium_label	Displaying the backup information in the ONLINE or ADMIN operational state
medium_labeloffline	Displaying backup information in the OFFLINE operational state
medium_migrate	Adopting an existing template definition
medium_put	Defining or changing the properties of a backup template
medium_put_nodistribute	Internal system command with hot standby configurations
package_info	DBM command used only by SAP applications
param_abortsession	Ending a parameter session
param_addvolume	Changing volume parameters
param_checkall	Checking all database parameters
param_commitsession	Confirming changes to the database parameter file
param_copy	Copying a database parameter file
param_delvolume	Deleting volume parameters
param_directdel	Deleting a database parameter
param_directget	Displaying the value of a parameter in the database parameter file
param_directgetall	Displaying the value of all parameters in the database parameter file
param_directgetallnext	Scrolling through the parameter values in the database parameter file
param_directput	Changing a value directly in the database parameter file
param_extget	Displaying the individual data of a database parameter
param_extgetall	Displaying the data of all database parameters
param_extgetallnext	Scrolling through all database parameter data
param_getdefault	Displaying the system default (default value)
param_getexplain	Displaying the stored explanatory text
param_getfull	Displaying all the data of a database parameter
param_gethelp	Displaying the stored help text
param_gethistory	Opening the database parameter history
param_gethistorynext	Scrolling through the database parameter history
param_getproperties	Displaying all the properties of a database parameter
param_gettype	Displaying the data type of a database parameter
param_getvalue	Displaying the current value of a database parameter
param_getvolsall	Displaying the data of all volume parameters
param_getvolume	Displaying the data of an individual volume
param_init	Initializing the database parameters for a new database
param_put	Changing the values of database parameters
param_restore	Resetting the parameter file to a previous version
param_rmfile	Deleting the database parameter file
param_startsession	Opening a parameter session
param_versions	Displaying a list of parameter files
quit	Exiting Database Manager CLI
recover_cancel	Canceling an interrupted restore or a backup check
recover_cancel_req	DBM command used only by DBM client programs
recover_check	Checking a backup
recover_check_req	DBM command used only by DBM client programs
recover_config	Restoring the parameter file from a data backup
recover_ignore	Continuing a parallel restore or a backup check
recover_ignore_req	DBM command used only by DBM client programs
recover_replace	Specifying the succeeding data carrier for a restore operation or a backup check
recover_replace_req	DBM command used only by DBM client programs
recover_req	DBM command used only by DBM client programs
recover_start	Restoring the database
recover_state	Displaying the current status of a restore action
recover_state_check	Displaying the current status of a backup check
recover_volume	Restoring a damaged volume
release	Exiting Database Manager CLI
scheduler_activate_job	Activating a scheduler job
scheduler_create_job	Creating a scheduler job
scheduler_deactivate_job	Deactivating a scheduler job
scheduler_delete_job	Deleting a scheduler job
scheduler_list_jobs	Displaying a list of all scheduler jobs
scheduler_start	Starting the scheduler
scheduler_state	Displaying the function of the scheduler
scheduler_stop	Stopping the scheduler
service_connect	Opening a Sservice Session
service_release	Closing a service session
show	Displaying information about the database
show_list	Displaying the keywords for information about the database
show_next	Scrolling through information about the database
sql_connect	Opening an SQL Session
sql_execute	Executing an SQL statement (displaying the complete result list)
sql_executenice	Executing an SQL statement (displaying the result record-by-record)
sql_fetch	Scrolling through the results of an SQL statement (displaying the complete result list)
sql_fetchnice	Scrolling through the results of an SQL statement (displaying the result record-by-record)
sql_info	Displaying the structure of a result set
sql_recreateindex	Restoring a damaged index
sql_release	Ending an SQL session
sql_updatestat	Updating the optimizer statistics
sql_updatestat_per_systemtable	Updating the optimizer statistics as per system table `SYSUPDSTATWANTED`
trace_clear	Deleting the contents of the database trace
trace_flush	Creating the binary file of the database trace
trace_off	Deactivating the database trace
trace_on	Activating the database trace
trace_prot	Creating the text version of the database trace
trace_protopt	Displaying the command options for creating the text version of the database trace
trace_show	Displaying the logged activities of the database trace
user_create	Creating Database Manager operators
user_delete	Deleting Database Manager operators
user_get	Displaying the DBM operator properties
user_getall	Displaying a list of Database Manager operators
user_getrights	Displaying the server permissions
user_logon	Logging on to Database Manager
user_name_get	Displaying your current logon name in Database Manager
user_put	Changing the DBM operator properties
user_rename	Changing the name of a DBM operator
user_sap	Storing special users
user_sysdba	Transferring the data of the database system administrator to Database Manager
user_system	Logging on to the operating system

More Information

Documentation for the Database Manager CLI