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_extend

Extending the data area automatically

auto_update_statistics

Updating the optimizer statistics automatically

autolog_cancel

Canceling automatic log backup

autolog_off

Deactivating automatic log backup

autolog_on

Activating automatic log backup

autolog_show

Displaying the automatic log backup function

autorecover

Restoring the database instance 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

Getting external backup IDs

backup_ext_ids_getfromtool

Getting 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

Change date of the backup history

backup_history_list

Displaying the backup history

backup_history_listnext

Scrolling through the backup history

backup_history_open

Getting the backup history

backup_ignore

Continuing 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 instance

backup_state

Displaying the current backup status

bye | exit | quit | release

Exiting the Database Manager CLI

db_activate

Initializing a database instance

db_activate RECOVER

Restoring and initializing a database instance

db_activate_req

DBM command used only by DBM client programs

db_addvolume

Adding volumes

db_admin

Transferring to the ADMIN operating status

db_clear

Deleting 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 Instance

db_deletevolume

Deleting a data volume

db_drop

Deleting the current database instance

db_enum

Displaying a list of all registered database instances

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 to the OFFLINE operational state

db_online

Transferring to the ONLINE operational state

db_reg

Updating the registration of a database instance

db_reinstall

Resetting the database instance

db_release

Ending a database session

db_restart

Restarting the database instance

db_restartinfo

Displaying the restart information after importing a backup

db_speed

Displaying the database kernel variant

db_standby

Transferring to the STANDBY operational state

db_state

Displaying the operational state of the database instance

db_stop

Ending a database process

dban_delete

Deleting the Database Analyzer log files

dban_start

Calling the Database Analyzer

dban_state

Displaying the function of the Database Analyzer

dban_stop

Exiting the Database Analyzer

dbm_configget

Displaying a configuration parameter of the Database Manager

dbm_configset

Changing a configuration parameter of the 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_setpath

DBM command used only by the software installation program

dbm_shm_info

Displaying information about the shared memory

dbm_shm_reset

Resetting the shared memory

dbm_shm_unlock

Unlocking the shared memory

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_list

Displaying a list of events and their statuses

event_list_categories

Displaying a list of event categories

event_receive

Displaying a triggered event

event_release

Ending an event session

event_set

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 the 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 instance

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 instance

hss_copyfile

Copying database files in the cluster

hss_enable

Defining a database instance as the master instance

hss_execute

Executing DBM commands in a standby instance

hss_getnodes

Displaying the hot standby parameters

hss_removestandby

Deleting a standby instance

info

Displaying status information of the database instance

info_next

Scrolling through the status information of the database instance

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 the version of the database software

inst_unreg

Deleting the registration of a database software version

load_lcapps

Loading the application libraries

load_r3tab

Loading the SAP-specific tables

load_systab

Loading 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 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 from a parameter of the database parameter file

param_directgetall

Displaying the value of all parameters from 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 individual data of a database parameter

param_extgetall

Displaying the data of all database parameters

param_extgetallnext

Scrolling through the database parameter data

param_getdefault

Displaying the system default (default value)

param_getexplain

Displaying the stored explanatory text

param_getfull

Displaying all 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 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 instance

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 the 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 checking of a backup

recover_replace_req

DBM command used only by DBM client programs

recover_req

DBM command used only by DBM client programs

recover_start

Restoring Database Instances

recover_state

Displaying the current status of a restore action

recover_state_check

Displaying current status of a backup check

recover_volume

Restoring a damaged volume

release

Exiting the 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 service session

service_release

Closing a service session

show

Displaying information about the database instance

show_list

Displaying the keywords for information about the database instance

show_next

Scrolling through the information about the database instance

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 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 authorizations of a DBM operator

user_logon

Logging on to the Database Manager

user_put

Changing the DBM operator properties

user_rename

Changing the name of a DBM operator

user_sap

Storing the data of special users

user_sysdba

Transferring the data of the database system administrator to the Database Manager

user_system

Logging on to the operating system