Toggle navigation
SAP XRPM and SAP PPM Library
Tools
dbm_execute_serverprocess
Use
This DBM command is an internal system command.
It is not documented at present.
Tools
Database Manager GUI
Calling the Database Manager GUI
Screen Areas of the Database Manager GUI
Creating a Database Instance
Creating a Database Instance: Desktop PC/Laptop
Creating a Database Instance: Custom
Creating a Database Instance: My Templates
Initializing an Existing Database Instance
Database Instance Management
Managing the List of Database Instances
Connection to the DBM Server
Starting (Restarting) the Database Instance
Stopping the Database Instance (Shutdown)
Monitoring the Operational State
Closing a Database Session Manually
Creating, Displaying and Deleting Volumes
Changing Volume Properties
Displaying and Changing Database Parameters
Changing Database Parameters for Volumes
Switching on/off Automatic Extension of the Data Area
Changing Log Settings
Setting Up a Master Instance (Hot Standby)
Adding a Standby Instance (Hot Standby)
Activating, Deactivating, or Deleting Indexes
Creating, Displaying, Changing and Deleting Mapchar Sets
Updating the Statistics Information
Loading Demo Data
Deleting a Database Instance
Managing the Database System Administrator
Changing the DBM Operator Properties of the Database System Admi
Changing the Password of the Database System Administrator
Changing the Server Authorizations of the Database System Admini
Changing the SQL User Properties of the Database System Administ
Managing Database Manager Operators
Creating, Changing, or Deleting a Database Manager Operator
Changing the DBM Operator Properties
Changing the Password of a Database Manager Operator
Changing the Server Authorizations
Managing Database Users
Creating/Changing/Deleting a Database User
Changing the SQL User Properties of a Database User
Changing the Password of a Database User
Creating/Changing/Deleting a Synchronization User
Backup
Backup Wizard
Managing the Backup Templates
Backup Template for a Single Data Carrier
Backup Template for a Group of Parallel Data Carriers
Changing Backup Templates
Deleting Backup Templates
Backup Procedures
Backing Up to a Single Data Carrier
Backing Up to a Group of Parallel Data Carriers
Backups with Automatic Tape Loaders
Backups to Manually Changed Data Carriers (Succeeding Data Carri
Backups with Backup Tools from Other Providers
Activating and Deactivating Automatic Log Backup
Restoring
Recovery Wizard
Restoring the Last Backup in the Backup History
Restoring a Backup from the Backup History
Restoring Without a Backup History
Continuing an Interrupted Restore
Restoring with Automatic Tape Loaders
Restoring with Backup Tools from Other Providers
Restoring After Initializing a Database Instance
Restoring the Indexes after a Database Restore
Restoring a Mirrored Log Volume
Freezing the Data Area (Snapshots)
Creating a Snapshot
Reverting to the Snapshot
Deleting the Snapshot
Displaying Information
Displaying the Backup History
Displaying Cache Information
Displaying Data Area Information
Displaying Database Activities
Displaying Database Parameters
Displaying Database Sessions
Displaying Log Area Information
Displaying System Tables
Options for Diagnosing Problems
Checking Backups
Displaying and Deleting Database Analyzer Information
Checking Database Servers
Reading Log Files
Checking Database Structures
Using the Database Trace
Displaying OMS Caches
Displaying OMS Class Containers
Activating the OMS Monitor
Updating the Database Software
Updating the System Tables
Using the SQL Studio
Using the Database Manager CLI
Database Manager CLI
How the Database Manager CLI Works
Calling the Database Manager CLI
DBM Options
-c: Indicate as DBM Command
-d: Name of the Database Instance
-e: Activating Encryption
-i | -ic | is | ics: Name of the Input Script
-n: Name of the Database Computer
-o: Name of the Output File
-R: Installation Directory of the Database Software:
-t: Name of the Log File
-uSQL: Opening an SQL Session
-uSRV: Opening a Service Session
-uUTL: Opening a Utility Session
-du: Deleting XUSER Entries
-uk: User Key
-us: Creating or Changing XUSER Entries
-ux: Logging On to the XUSER Program
-ul: Displaying XUSER Data
DBM Commands
Operating Modes in the Database Manager
Input Help
Comment: #
Local System Call: !
Linking Lines: /
Linking Lines: <
Reply Format
Command Reference for Working with the Database Manager CLI
Database Manager Help
Other Commands for Database Manager Help
Software Installation
Other Commands for Software Installation
Creating and Deleting Database Instances
Other Commands for Creating and Deleting Database Instances
Configuring Database Instances
Other Commands for Configuring Volumes
Commands for Changing Database Parameters
Controlling Database Instances
Other Commands for Controlling Database Instances
Backing Up and Restoring Database Instances
Other Commands for Backup Templates
Other Commands for Backups
Other Commands for Information on Backups
Other Commands for Data Recovery
Managing Database Manager Operators
Other Commands for Managing Database Manager Operators
Analyzing the Database Instance
Commands for the Database Trace Function
Commands for Accessing Database Files
Commands for Using the Database Analyzer
Accessing the Database Instance using SQL
Other Commands Accessing the Database Instance Using SQL
Optimizing SQL Access to the Database Instance
Using Database Events
Other Commands for Using Database Events
Using the Scheduler
Other Commands for Using the Scheduler
Managing Hot Standby Systems
Commands for Managing Hot Standby Systems
Database Manager Settings
Other Commands for the Database Manager Settings
Overview of All DBM Commands
apropos
archive_stage
archive_stage_repeat
auto_extend
auto_update_statistics
autolog_cancel
autolog_off
autolog_on
autolog_show
autorecover
backup_cancel
backup_cancel_req
backup_ext_ids_forget
backup_ext_ids_get
backup_ext_ids_getfromtool
backup_ext_ids_list
backup_ext_ids_listnext
backup_history_append
backup_history_close
backup_history_date
backup_history_list
backup_history_listnext
backup_history_open
backup_ignore
backup_ignore_req
backup_replace
backup_replace_req
backup_reply_available
backup_reply_receive
backup_req
backup_start
backup_state
bye | exit | quit | release
db_activate
db_activate RECOVER
db_activate_req
db_addvolume
db_admin
db_clear
db_connect
db_cons
db_create
db_deletevolume
db_drop
db_enum
db_execute
db_executenice
db_fetch
db_fetchnice
db_migratecatalog
db_offline
db_online
db_reg
db_reinstall
db_release
db_restart
db_restartinfo
db_speed
db_standby
db_state
db_stop
dban_delete
dban_start
dban_state
dban_stop
dbm_configget
dbm_configset
dbm_execute_serverprocess
dbm_getpath
dbm_getpid
dbm_listmemoryerror
dbm_next
dbm_setpath
dbm_shm_info
dbm_shm_reset
dbm_shm_unlock
dbm_version
dbmevtdisp_internal_add
dbmevtdisp_internal_communication
dbmevtdisp_internal_delete
diag_histlist
diag_pack
event_available
event_delete
event_list
event_list_categories
event_receive
event_release
event_set
event_wait
exec_lcinit
exec_nipingsrv
exec_sdbinfo
explain
file_backup
file_getfirst
file_getlist
file_getnext
file_operation
file_restore
get_default
help
hss_addstandby
hss_copyfile
hss_enable
hss_execute
hss_getnodes
hss_removestandby
info
info_next
inst_enum
inst_info
inst_reg
inst_unreg
load_lcapps
load_r3tab
load_systab
load_tutorial
medium_date
medium_delete
medium_delete_nodistribute
medium_get
medium_getall
medium_label
medium_labeloffline
medium_migrate
medium_put
medium_put_nodistribute
package_info
param_abortsession
param_addvolume
param_checkall
param_commitsession
param_copy
param_delvolume
param_directdel
param_directget
param_directgetall
param_directgetallnext
param_directput
param_extget
param_extgetall
param_extgetallnext
param_getdefault
param_getexplain
param_getfull
param_gethelp
param_gethistory
param_gethistorynext
param_getproperties
param_gettype
param_getvalue
param_getvolsall
param_getvolume
param_init
param_put
param_restore
param_rmfile
param_startsession
param_versions
recover_cancel
recover_cancel_req
recover_check
recover_check_req
recover_config
recover_ignore
recover_ignore_req
recover_replace
recover_replace_req
recover_req
recover_start
recover_state
recover_state_check
recover_volume
scheduler_activate_job
scheduler_create_job
scheduler_deactivate_job
scheduler_delete_job
scheduler_list_jobs
scheduler_start
scheduler_state
scheduler_stop
service_connect
service_release
show
show_list
show_next
sql_connect
sql_execute
sql_executenice
sql_fetch
sql_fetchnice
sql_info
sql_recreateindex
sql_release
sql_updatestat
sql_updatestat_per_systemtable
trace_clear
trace_flush
trace_off
trace_on
trace_prot
trace_protopt
trace_show
user_create
user_delete
user_get
user_getall
user_getrights
user_logon
user_put
Server Authorizations
Access SQL: Access to SQL Session
AccessUtility: Access to Utility Session
Backup: Performing Backups
DBFile Read: Accessing Database Files (Reading Only)
DBInfoRead: Displaying Status Information
DB Start: Starting the Database Instance
DBStop: Stopping the Database Instance
ExecLoad: Executing the Loader program:
InstallMgm: Installation Management
LoadSysTab: Loading the System Tables
ParamCheckWrite: Accessing Database Parameters (Checked Writing)
PAccessing Database Parameters (Reading and Writing): ParamFull
ParamRead: Accessing Database Parameters (Reading Only)
Recovery: Restoring Backups
SchedulerMgm: Managing the Scheduler
Scheduling: Scheduling DBM Commands
SharedMemoryAdmin: Managing the Shared Memory
SystemCmd: Executing Operating System Commands
UserMgm: Managing Database Manager Operators
user_rename
user_sap
user_sysdba
user_system
Database Analyzer
Calling the Database Analyzer
Options
Configuration File
Log Files
Messages
Avg user cmd exec time for task
Avg user suspend time for task
Avg User Wait Time For Task
Catalog Cache Hitrate
Collision Rate
Data Cache Hit Rate
Data volume filling level
Deletes/Updates
Free User Tasks
Lock List Escalations
Log Area Filling Level
Log Queue Overflows
Log write time
Max Log Queue Filling
Number of Cached History Pages
Number of Physical Reads
Number of physical writes
Number of Physical Writes of Temporary Pages
OMS Cache Hit Rate
OMS Heap Collisions
OMS Heap Utilization
OMS History Cache Hit Rate
OMS Terminates
OMS version is old
OMS Version is Unloaded
Optimizer Strategies
Out of Memory Exceptions
Parse Activities
Physical Reads for User Task
Selects and Fetches
Table scans
User Task Blocked in State
User Task Physical Writes
Loader
Calling the Loader
Call Options of the Loader CLI
Transport Mode
Command File Mode
Command File
Session Mode
Options for Establishing a Connection
Options for Input and Output
Options for Determining Version Information
Commands and SQL Statements
Creating a Database Session: Commands
AUTOCOMMIT Command
SET Command
SQLMODE Command
USE DB Command
USE SCHEMA Command
USE SCHEMAMAP Command
CREATE/DROP SCHEMAMAP Statement
USE USER Command
Exporting: Commands
EXPORT DB Command
EXPORT USER Command
EXPORT SCHEMA Command
EXPORT TABLE Command
EXPORT COLUMNS Command
Importing: Commands
IMPORT DB Command
IMPORT USER Command
IMPORT SCHEMA Command
IMPORT TABLE Command
Performance Improvement in the IMPORT TABLE
IMPORT COLUMNS Command
UPDATE COLUMNS Command
Data
Data Stream
Position Description
Data Format
Code Specification
CSV, FWV, FWV BINARY
PAGES, RECORDS
Data Carrier Type
Column Description
Data Types
Importing Constants and Special Constants
Selecting Data Records
Output Column
Table Name
Dates
Time Specifications
Time Stamp Specifications
NULL Value Representation
Transformation
Exporting and Importing Using Backup Tools from Other Providers
Importing and Exporting LONG Values
Exporting LONG Values
Importing LONG Values
Restarting
Log Functions
Log File
Transformation History
Additional Log Functions (package_spec)
System Tables
CODEPAGE
MAPSCHEMANAMES
TRANSFORMATIONMODEL
TRANSFORMATIONMONITOR
TRANSFORMATIONPACKAGES
TRANSFORMATIONRESOURCES
TRANSFORMATIONSTATISTICS
TRANSFORMATIONSTEPS
Syntax Rules: Arranged Alphabetically
autocommit_command
backup_tool_spec
bool_spec
catalog_data_instream_part_spec
catalog_data_outstream_part_spec
catalog_data_instream_table_spec
catalog_data_outstream_table_spec
catalog_instream_spec
catalog_outstream_spec
code_page_spec
code_spec
column_assignment
column_dataformat_spec
column_function
column_id
column_name
column_spec
compare_operator
condition
configuration_spec
csv_format_spec
data_instream_column_spec
data_instream_columns_spec
data_instream_part_spec
data_instream_table_spec
data_outstream_column_spec
data_outstream_part_spec
data_outstream_table_spec
database_spec
date_spec
delimiter
delimiter_spec
duplicates_clause
ebid_spec
exclude_include
export_column_spec
export_columns_command
export_command
export_db_command
export_lobcolumn_spec
export_schema_command
export_table_command
export_user_command
field_assignment
field_format_spec
field_function
field_spec
field_type
fwv_format_spec
if_condition
import_column_spec
import_columns_command
import_command
import_db_command
import_lobcolumn_spec
import_schema_command
import_table_command
import_user_command
instream_columnformat_spec
instream_csv_spec
instream_ddl_spec
instream_fwv_spec
instream_lob_spec
instream_pages_spec
instream_records_spec
instream_tableformat_spec
int_spec
isolation_level_spec
lob_code_spec
map_column_field
map_field_column
map_schema_spec
mediumtype_spec
noheader_spec
null_assign
null_condition
null_spec
number_spec
numerical_functions
order_clause
outstream_columnformat_spec
outstream_csv_spec
outstream_ddl_spec
outstream_fwv_spec
outstream_lob_spec
outstream_pages_spec
outstream_records_spec
outstream_tableformat_spec
package_spec
records_format_spec
remark_command
restart_spec
restore_spec
round_or_trunc_spec
scale_spec
schema_name
schema_map_name
schema_to_schema
select_expression
separator
separator_spec
sequence_number
set_column_spec
set_command
simple_condition
sql_mode
sql_mode_command
standard_code_spec
standard_date_mask
standard_time_mask
standard_timestamp_mask
start_spec
table_dataformat_spec
table_name
time_spec
timestamp_spec
update_column_spec
update_columns_command
usage_spec
use_database_command
use_schema_command
use_schema_map_command
use_user_command
user_spec
Syntax Rules Arranged Semantically
Terms: Overview
Key Words: Overview
SQL Studio (GUI)
Starting SQL Studio
Opening a Database Session
Recent Sessions List
SQL Studio Screen Areas
User Settings
Unicode Support
Catalog Manager
SQL Studio Objects
Exporting a Database Object Definition
Tables
Creating a Database Table
Defining Columns
Defining Constraints
Defining Foreign Key Dependencies
Defining Miscellaneous Information
Creating a View Table
Creating a Synonym
Displaying the Definition of a Table
Changing the Definition of a Database Table
Displaying the Content of a Table
Using a Table in Dialogs or Definitions
Renaming a Table
Deleting all Rows in a Table
Dropping a Table
Indexes
Creating an Index
Displaying the Definition of an Index
Dropping an Index
Number Sequences
Creating a Sequence
Displaying the Definition of a Sequence
Deleting a Sequence
Users
Database procedures
Triggers
SQL Dialog
Creating and Executing SQL Statements
Keyword List
Setting Parameters for SQL Statements
Importing and Exporting SQL Statements
Form Dialog
Executing a Form Dialog
Selecting Data Records Using Search Conditions
Changing Data Records
Inserting Data Records
Deleting a Data Record
Importing and Exporting LONG Columns
Visual Query Dialog
Creating and Executing a Visual Query
Linking Table Columns with Joins
Entering Search Conditions
Setting Parameters for Search Conditions
Defining the Result View
Result Tables
Adjusting the Result View
Saving a Result
Status Window
Ending the Database Session
Web SQL Studio
Calling Web SQL Studio
Logging on to a Database Instance
Screen Areas in Web SQL Studio
Executing SQL statements
Opening WebDAV Repositories
Saving SQL Statements
Editing Saved SQL Statements
Displaying the Software Version of Web SQL Studio
Closing Web SQL Studio
SQLCLI
Logging on to a Database Instance
Executing Commands
Multiple Row Mode
Command Buffer
Editing Commands in an External File
Batch File
Redirecting a Result to a File
Executing SQL Statements
Executing Database Procedures
Requesting Information About the Database Catalog
Executing Shell Commands
Exiting the SQLCLI
Overview of the Call Options
Overview of the SQLCLI Commands
Synchronization Manager
Technical System Landscape
Message Server
Synchronization Manager GUI
Synchronization Services
Synchronization Ports
Data Model
Example: Data Model
Configuration
Configuring Java Paths
Configuring the Synchronization Manager GUI
Configuring Database Instances
Configuring the Message Server
Configuring Synchronizations
Defining Replication Tables
Defining Replication Units
Activating and Deactivating Replication Units
Initializing Client Tables
Configuring Synchronization Services
Starting the Synchronization Manager GUI
Logging on to a Database Instance
Starting and Stopping the Message Server
Logging On To the Message Server
Synchronization
Starting and Stopping Synchronization Services
Utilities
Event Dispatcher
Commissioning the Event Dispatcher
Configuration for the Event Dispatcher
Special Events of the Event Dispatcher
Overview of Event Dispatcher Commands
add
delete
list
start
state
stop
version
XCONS
Displaying Information about the Database Instance
XUSER
Using a User Key when Logging On to a Database Instance
Creating or Changing XUSER Entries
Displaying Data for XUSER Entries
Deleting XUSER Entries
XUSER Options
Importing XUSER Entries from a File
X Server
Starting the X Server
Stopping the X Server
Ports and Protocols of the X Server