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
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 Volumes
Displaying, Changing, and Deleting Volumes
Displaying and Changing Database Parameters
Changing Database Parameters for Volumes
Changing Log Settings
Setting Up a Master Instance (Hot Standby)
Adding a Standby Instance (Hot Standby)
Activating, Deactivating, or Deleting Indexes
Defining MapChar Sets
Displaying, Changing and Deleting MapChar Sets
Updating the Statistics Information
Loading Example Data for Tutorial
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
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
-0: 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
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 Media
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
Example: How to Create and Configure a Database Instance
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 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
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