Tools
Database Manager GUI
Calling the Database Manager GUI
Screen Areas of the Database Manager GUI
Creating a Database Instance
Templates for Database Instances
Initializing an Existing Database Instance
Database Instance Administration
Monitoring the Operational State
Managing the List of Database Instances
Displaying and Changing Database Parameters
Closing a Database Session Manually
Activating, Deactivating, or Deleting Indexes
Changing Log Settings
Defining MapChar Sets
Displaying, Changing and Deleting MapChar Sets
Setting Up a Master Instance (Hot Standby)
Starting (Restarting) the Database Instance
Adding a Standby Instance (Hot Standby)
Updating the Statistics Information
Stopping the Database Instance (Shutdown)
Connection to the DBM Server
Creating Volumes
Displaying, Changing, and Deleting Volumes
Changing Database Parameters for Volumes
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
Backup
Backup Wizard
Managing the Backup Media
Creating a Single Backup Medium
Creating a Group of Parallel Backup Media
Changing Backup Media
Deleting Backup Media
Backup Procedures
Backing Up to a Single Backup Medium
Backing Up to a Group of Parallel Backup Media
Backups with Automatic Tape Loaders
Backups with Manually Changed Media (Succeeding Medium)
Backups with Backup Tools from Other Providers
Activating and Deactivating Automatic Log Backup
Restore
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 Database 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
Functions of the Database Manager CLI
Calling the Database Manager CLI
DBM Options
Indicate as DBM Command: -c
Name of Database Instance: -d
Verschlüsselung aktivieren: -e
Name of the Input Script: -i | -ic
Name of the Database Server: -n
Name of the Output File: -o
Installation Directory of the Database Software: -R
Name of the Log File: -t
Opening an SQL Session: -uSQL
Opening a Service Session: -uSRV
Eröffnen einer Utility-Sitzung: -uUTL
Deleting XUSER Entries: -ud
XUSER Key: -uk
Creating or Changing XUSER Entries: -us
Logging On to the XUSER Program: -ux
Displaying XUSER Data: -ul
DBM Commands
Input Help
Comment: #
Local System Call: !
Linking Lines: /
Linking Lines: <
Reply Format
Working with the Database Manager CLI
Hilfe zum Database Manager
Weitere Kommandos für die Hilfe zum Database Manager
Softwareinstallation
Weitere Kommandos zur Softwareinstallation
Anlegen und Löschen der Datenbankinstanz
Weitere Kommandos für das Anlegen und Löschen der Datenbankinsta
Konfigurieren der Datenbankinstanz
Weitere Kommandos für das Konfigurieren der Volumes
Kommandos für das Ändern der Datenbankparameter
Controlling Database Instances
Weitere Kommandos für das Steuern der Datenbankinstanz
Sichern und Wiederherstellen der Datenbankinstanz
Weitere Kommandos für Medien
Weitere Kommandos zum Sichern
Weitere Kommandos zu Informationen über Sicherungen
Weitere Kommandos zum Wiederherstellen
Verwalten der Database Manager-Benutzer
Weitere Kommandos zum Verwalten der Database Manager-Benutzer
Analysieren der Datenbankinstanz
Kommandos für die Datenbank-Trace-Funktion
Kommandos für den Zugriff auf Datenbankdateien
Kommandos für die Verwendung des Database Analyzer
SQL-Zugriffe auf die Datenbankinstanz
Weitere Kommandos für SQL-Zugriffe auf die Datenbankinstanz
Optimieren von SQL-Zugriffen auf die Datenbankinstanz
Nutzen von Events der Datenbankinstanz
Weitere Kommandos für das Nutzen von Events der Datenbankinstanz
Verwenden des Scheduler
Weitere Kommandos für das Verwenden des Scheduler
Verwalten von Hot-Standby-Systemen
Kommandos für das Verwalten von Hot-Standby-Systemen
Einstellungen des Database Manager
Weitere Kommandos zu den Einstellungen des Database Manager
Overview of All DBM Commands
apropos
Creating a Single Archive of the Version Files
Creating Multiple Archives of the Version Files
Extending the Data Area Automatically
auto_update_statistics
Canceling the Automatic Log Backup
Deactivating the Automatic Log Backup
Activating the Automatic Log Backup
Displaying the Automatic Log Backup Function
autorecover
Terminating an Interrupted Backup
backup_cancel_req
Releasing the Memory Occupied by the External Backup IDs
Retrieving the External Backup IDs
backup_ext_ids_getfromtool
Displaying the External Backup IDs
Scrolling in the External Backup IDs
Closing the Backup History
Displaying the Change Date of the Backup History
Displaying the Backup History
Scrolling in the Backup History
Fetching the Backup History
Continuing the Backup Without the Medium Last Reported as Full
backup_ignore_req
Backing Up to a Succeeding Medium
backup_replace_req
backup_reply_available
backup_reply_receive
backup_req
Backing Up the Database Instance
Displaying the Current Backup Status
Exiting the Database Manager CLI
Activating a New Database Instance
Recovering a Database Instance with Initialization
db_activate_req
Adding Volumes
Transferring to the ADMIN Operational State
Deleting Runtime Information After a Database Error
db_connect
Using the XCONS Tool (Database Console)
Creating a Database Instance
Example: Creating and Configuring a Database Instance
db_deletevolume
Deleting the Current Database Instance
Displaying a List of All Registered Database Instances
Executing a Database Statement
db_executenice
Scrolling in the Result Data
db_fetchnice
db_migratecatalog
Transferring to the OFFLINE Operational State
Transferring to the ONLINE Operational State
Changing the Software Version of the Current Database Instance
db_reinstall
Ending a Database Session
Restarting the Database Instance
Displaying Current Information About the Database Instance
Displaying the Database Kernel Variant
Transferring to the STANDBY Operational State
Displaying the Operational State of the Database Instance
db_stop
dban_delete
Calling the Database Analyzer
Determining the Status of the Database Analyzer
Ending the Database Analyzer
Displaying a Configuration Parameter of the Database Manager
Changing a Configuration Parameter of the Database Manager
dbm_execute_serverprocess
Displaying the Version-Independent Directories
dbm_getpid
dbm_listmemoryerror
dbm_next
dbm_setpath
dbm_shm_info
dbm_shm_reset
dbm_shm_unlock
Displaying the Version Information
dbmevtdisp_internal_add
dbmevtdisp_internal_communication
dbmevtdisp_internal_delete
Displaying the Diagnosis History
Packing Database Files
event_available
Deactivating an Event
Displaying the List of Events and Statuses
event_list_categories
event_receive
Ending an Event Session
Activating an Event
Waiting for an Event
Executing the liveCache Initialization Script
exec_nipingsrv
exec_sdbinfo
explain
Backing Up a Database File
Opening a Database File
Displaying a List of the Database Files
Scrolling Through a Database File
Editing Log Files of the Database Instance
Restoring a Database File
get_default
Displaying a List of the DBM Commands
Defining a Standby Component
hss_copyfile
Defining the Database Instance as a Master Component
Executing DBM Commands on a Standby Component
Displaying the Hot Standby Parameters
Deleting a Standby Component
Displaying Status Information for the Database Instance
Scrolling in the Status Information of the Database Instance
Creating a List of All Registered Versions of the DB Software
inst_info
Registering a Version of the Database Software
Deleting Registration of a Database Software Version
load_lcapps
Loading SAP-Specific Tables
Loading the System Tables
load_tutorial
Displaying the Change Date for the Media Definition File
Deleting a Backup Medium
medium_delete_nodistribute
Displaying the Media Data
Displaying a List of All Defined Backup Media
Displaying Backup Info in Operational State ONLINE or ADMIN
Displaying the Backup Information in OFFLINE Operational State
Transferring an Existing Media Definition
Creating or Changing a Backup Medium
medium_put_nodistribute
package_info
Terminating a Parameter Session
Changing Volume Parameters
Checking All Database Parameters
Confirming Changes to the Database Parameter File
Copying a Database Parameter File
Deleting Volume Parameters
Deleting a Database Parameter
Displaying a Value from the Database Parameter File
Displaying All Parameters of the Current Database Parameter File
Scrolling In the Parameters in the Current DB Parameter File
Changing a Value Directly in the Database Parameter File
Displaying Individual Data for a Database Parameter
Displaying the Data for All Database Parameters
Scrolling Through the Database Parameter Data
Displaying the System Default Value
Displaying the Stored Explanatory Text
Displaying All Data for a Database Parameter
Displaying the Stored Help Text
Opening the Database Parameter History
Scrolling in the Database Parameter History
Displaying All Properties for a Database Parameter
Displaying the Data Type of a Database Parameter
Displaying the Current Value of a Database Parameter
Displaying the Data for All Volume Parameters
Displaying the Data of an Individual Volume Parameter
Initializing the Database Parameters for a New Database Instance
Changing the Value of a Database Parameter
Resetting the Parameter File to a Previous Version
Deleting the Database Parameter File
Opening a Parameter Session
Displaying a List of the Parameter Files
Terminating an Interrupted Restore or a Backup Check
recover_cancel_req
Checking a Backup
Restoring the Parameter File from a Data Backup
Continuing the Parallel Restore or Backup Check
recover_ignore_req
Restoring or Checking a Backup with a Succeeding Medium
recover_replace_req
recover_req
Recovering a Database Instance
Displaying the Current Restore Status
Displaying the Current Status of a Backup Check
Recovering a Damaged Volume
Activating a Scheduler Job
Creating a Scheduler Job
Deactivating a Scheduler Job
Deleting a Scheduler Job
Displaying a List of All Scheduler Jobs
Starting the Scheduler
Displaying the Operational State of the Scheduler
Stopping the Scheduler
Opening a Service Session
Ending a Service Session
Displaying Information About the Database Instance
Displaying the Keywords for Information About the Database Insta
Scrolling in the Information About the Database Instance
sql_connect
sql_execute
sql_executenice
sql_fetch
sql_fetchnice
sql_info
Recreating a Damaged Index
sql_release
Updating the Optimizer Statistics
sql_updatestat_per_systemtable
Deleting the Contents of the Database Trace
trace_flush
Deactivating the Database Trace
Activating the Database Trace
Creating the Text Version of the Database Trace
Displaying Command Options for Text Version of Database Trace
Displaying the Logged Activities of the Database Trace
Creating DBM Operators
Deleting DBM Operators
Displaying User Data
Displaying a List of DBM Operators
Displaying the Server Authorizations
Logging On to the Database Manager
Changing the DBM Operator Data
Server Authorizations
Access to Database Session: AccessAdmin
Access to SQL Session: AccessSQL
Accessing a Utility Session: AccessUtility
Performing Backups: Backup
Accessing Database Files (Reading Only): DBFileRead
Displaying Status Information: DBInfoRead
Starting the Database Instance: DBStart
Stopping the Database Instance: DBStop
Executing the Program LOAD: ExecLoad
Installation Management: InstallMgm
Loading the System Tables: LoadSysTab
Accessing Database Parameters (Checked Writing): ParamCheckWrite
Accessing Database Parameters (Reading and Writing): ParamFull
Accessing Database Parameters (Reading Only): ParamRead
Restoring Backups: Recovery
Managing the Scheduler: SchedulerMgm
Scheduling DBM Commands: Scheduling
SharedMemoryAdmin: Verwalten des Shared-Memory
Executing Operating System Commands: SystemCmd
Managing DBM Operators: UserMgm
Storing Special Users
user_sysdba
Logging On to the Operating System
Database Analyzer
Calling 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
Transport Mode: Options
Transport Mode: Examples
Command File Mode
Command File
Session Mode
Options for Establishing a Connection
Options for Input and Output
Options for Determining Version Information
Call with the Java Interface of the Loader
Commands and SQL Statements
Creating a Database Session: Commands
AUTOCOMMIT Command
SET Command
SQLMODE Command
USE SCHEMA Command
USE SERVERDB Command
USE USER Command
Exporting: Commands
EXPORT DB Commands
EXPORT USER Commands
EXPORT SCHEMA Commands
EXPORT TABLE Commands
EXPORT COLUMNS Commands
Importing: Commands
IMPORT DB Commands
IMPORT USER Commands
IMPORT SCHEMA Commands
IMPORT TABLE Commands
IMPORT COLUMNS Commands
UPDATE COLUMNS Commands
Exporting and Importing: Syntax Elements
Transformation
Data
Data Stream
Data Types
Data Formats
COMPRESSED, FORMATTED, FORMATTED BINARY
Medium
Table Description
Column Description
Output Column
Importing Constants and Special Constants
Selecting Data Records
Position Description
Code Specification
Dates
Times
Time Stamp Specifications
Exporting and Importing Using Backup Tools from Other Providers
Importing and Exporting LONG Values
Restart
Log Functions
Log File
System Tables
CODEPAGE
TRANSFORMATIONMODEL
TRANSFORMATIONMONITOR
TRANSFORMATIONPACKAGES
TRANSFORMATIONRESOURCES
TRANSFORMATIONSTATISTICS
TRANSFORMATIONSTEPS
Syntax Rules: Overview
autocommit_command
bool_spec
catalog_instream_spec
catalog_outstream_spec
code_page_spec
code_spec
column_assignment
column_descriptor
column_id
column_id_spec
column_names
compare_operator
condition
configuration_instream_spec
database_name_statement
data_instream_spec
data_outstream_spec
date_spec
delimiter_spec
duplicates_clause
ebid_spec
export_columns_command
export_command
field_format
field_pos
format_spec
generate_spec
if_condition
import_columns_command
import_command
import_table_spec_command
instream_spec
int_spec
isolation_level_spec
lit_column_spec
load_column_spec
longfile_code_spec
longfile_spec
mediumtype_spec
noheader_spec
null_assign
null_condition
null_spec
number_spec
numerical_functions
order_clause
output_column
output_column_list
outstream_spec
package_outstream_spec
part_spec
remark_command
restart
round_or_trunc_spec
scale_spec
schema_spec
select_expression
separator_spec
sequence_number
set_column_spec
set_command
simple_column_spec
simple_condition
sql_mode
sql_mode_command
standard_code_spec
standard_date_mask
standard_time_mask
standard_timestamp_mask
stream_extract
stream_format_spec
table_name
table_spec
time_spec
timestamp_spec
update_columns_command
usage_spec
use_schema_command
use_serverdb_command
use_user_command
Terms: Overview
Key Words: Overview
SQL Studio (GUI)
Starting SQL Studio
Opening a Database Session
Recent Sessions List
SQL Studio Screen Areas
User Settings
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
Trigger
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
Logging Off from the Database
Web SQL Studio
Starting Web SQL Studio
Opening a Database Session
Screen Areas
Creating an SQL statement
Setting Parameters for an SQL Statement
Saving an SQL Statement
Editing a Saved SQL Statement
Executing an SQL Statement
Exporting and Importing SQL Statements
Ending 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
Exporting 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
Variables and Examples
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
Special Events of the Event Dispatcher
Configuring Event Dispatchers
Automating an Administration Task Using an Event Dispatcher
Example: Log Backup After the LOGABOVELIMIT Event
Example: E-Mail Notification After the DATABASEFULL Event
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