Entering content frame

Syntax documentation Overview of All DBM Commands Locate the document in the library 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_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