Syntax documentationOverview of All DBM Commands Locate this document in the navigation structure

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_recreate_bad_index

Recreating bad indexes 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 operational state

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

service_register

Registering the service database in the system

service_release

Closing a service session

service_unregister

Unregistering the service database in the system

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

user_delete

Deleting a DBM operator

user_get

Displaying a DBM operator's properties

user_getall

Displaying a list of DBM 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 a DBM operator's 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