DBM Command

DBM commands are commands for managing databases. To use DBM commands, log on to Database Manager CLI or Database Studio as database system administrator or as a DBM operator.

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

Database Manager CLI documentation

Database Studio, Executing DBM Commands

Database Administration in CCMS, Database Manager (CLI)