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 |