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