HITACHI Inspire The Next

For Windows Systems

Nonstop Database

HiRDB Version 9

System Definition

3020-6-453-40(E)


Contents

Notices
Preface
1. Overview
1.1 For users of a HiRDB/Single Server
1.1.1 HiRDB system definition types
1.1.2 HiRDB system definition creation procedure
1.1.3 HiRDB system definition file structure
1.1.4 Relationships among HiRDB system definitions
1.1.5 Procedure for modifying the HiRDB system definitions (excluding the UAP environment definition)
1.1.6 Adding or modifying the UAP environment definition
1.2 For users of a HiRDB/Parallel Server
1.2.1 HiRDB system definition types
1.2.2 HiRDB system definition creation procedure
1.2.3 HiRDB system definition file structure
1.2.4 Relationships among HiRDB system definitions
1.2.5 Procedure for modifying the HiRDB system definitions (excluding UAP environment definition)
1.2.6 Adding or modifying the UAP environment definition
1.2.7 Creating a HiRDB system definition when using the standby-less system switchover (effects distributed) facility
1.3 Coding format of HiRDB system definitions
1.4 List of operands
1.4.1 Operands with modifiable specifications
1.4.2 Operand priorities
1.5 Operands whose default value depends on the version and operands that are no longer needed
2. System Common Definition
2.1 Operand formats
2.2 Operand explanations
2.2.1 Operands related to the system structure
2.2.2 Operands related to maximum concurrent executions
2.2.3 Operands related to HiRDB startup
2.2.4 Operands related to reduced activation
2.2.5 Operands related to HiRDB processing
2.2.6 Operands related to full recovery processing
2.2.7 Operands related to transaction decision processing
2.2.8 Operands related to the SQL specifications
2.2.9 Operands related to SQL optimization
2.2.10 Operands related to narrowed retrieval
2.2.11 Operands related to system monitoring
2.2.12 Operands related to SQL runtime warning output facility
2.2.13 Operands related to the facility for output of extended SQL error information
2.2.14 Operands related to the SQL reserved word deletion facility
2.2.15 Operands related to command execution from SQL
2.2.16 Operands related to detailed SQLSTATE values
2.2.17 Operands related to lock
2.2.18 Operands related to buffers
2.2.19 Operands related to shared memory
2.2.20 Operands related to message log files
2.2.21 Operands related to statistical information
2.2.22 Operands related to RPC trace information
2.2.23 Operands related to performance trace information
2.2.24 Operands related to troubleshooting information
2.2.25 Operands related to RDAREAs
2.2.26 Operands related to global buffers
2.2.27 Operands related to in-memory data processing
2.2.28 Operands related to table or index reservation count
2.2.29 Operands related to referential and check constraints
2.2.30 Operands related to temporary tables
2.2.31 Operands related to HiRDB file system areas
2.2.32 Operands related to the facility for predicting reorganization time
2.2.33 Operands related to security
2.2.34 Operands related to the system switchover facility
2.2.35 Operands related to HiRDB Datareplicator
2.2.36 Operands related to linkage to JP1
2.2.37 Operands related to OLTP
2.2.38 Operands related to version upgrade
2.2.39 Operands related to communication processing
2.2.40 Operands related to Java
2.2.41 Operands related to external C stored routines
2.2.42 Operands related to character encoding
2.2.43 Operands related to date and time
2.2.44 Operands related to unit structure
2.2.45 Operands related to server structure
2.2.46 Operands related to the global buffers
2.2.47 Operands related to HA groups
2.2.48 Operands related to statistical information
2.2.49 Operands related to a client group
2.2.50 Operands related to plug-ins
2.2.51 Operands related to shared memory
2.2.52 Operands related to date and time
2.2.53 Operands related to the message output suppression facility
3. Unit Control Information Definition
3.1 Operand formats
3.2 Operand explanations
3.2.1 Operands related to system structure
3.2.2 Operands related to maximum concurrent executions
3.2.3 Operands related to HiRDB processing
3.2.4 Operands related to full recovery processing
3.2.5 Operands related to transaction decision processing
3.2.6 Operands related to system monitoring
3.2.7 Operands related to SQL runtime warning output facility
3.2.8 Operands related to the facility for output of extended SQL error information
3.2.9 Operands related to lock
3.2.10 Operands related to buffers
3.2.11 Operands related to shared memory
3.2.12 Operands related to statistical information
3.2.13 Operands related to RPC trace information
3.2.14 Operands related to performance trace information
3.2.15 Operands related to troubleshooting information
3.2.16 Operands related to global buffers
3.2.17 Operands related to unit status files
3.2.18 Operands related to unit status files (when an error occurs)
3.2.19 Operands related to security
3.2.20 Operands related to the system switchover facility
3.2.21 Operands related to HiRDB Datareplicator
3.2.22 Operands related to communication processing
3.2.23 Operands related to Java
3.2.24 Operands related to external C stored routines
3.2.25 Operands related to modifying the directory for work file output
3.2.26 Operands related to shared memory
4. Server Common Definition
4.1 Operand formats
4.2 Operand explanations
4.2.1 Operands related to processes
4.2.2 Operands related to work tables
4.2.3 Operands related to system monitoring
4.2.4 Operands related to lock
4.2.5 Operands related to buffers
4.2.6 Operands related to shared memory
4.2.7 Operands related to RPC trace information
4.2.8 Operands related to troubleshooting information
4.2.9 Operands related to global buffers
4.2.10 Operands related to temporary tables
4.2.11 Operands related to security
4.2.12 Operands related to Java
4.2.13 Operands related to system log files
4.2.14 Operands related to synchronization point dump files
4.2.15 Operands related to server status files (when an error occurs)
4.2.16 Operands related to the BES connection holding facility
5. Single Server Definition
5.1 Operand formats
5.2 Operand explanations
5.2.1 Operands related to processes
5.2.2 Operands related to work tables
5.2.3 Operands related to system monitoring
5.2.4 Operands related to SQL runtime warning output facility
5.2.5 Operand related to the facility for output of extended SQL error information
5.2.6 Operands related to lock
5.2.7 Operands related to buffers
5.2.8 Operands related to shared memory
5.2.9 Operands related to RPC trace information
5.2.10 Operands related to troubleshooting information
5.2.11 Operands related to global buffers
5.2.12 Operands related to temporary tables
5.2.13 Operands related to security
5.2.14 Operands related to delayed batch creation of plug-in index
5.2.15 Operands related to Java
5.2.16 Operands related to system log files
5.2.17 Operands related to synchronization point dump files
5.2.18 Operands related to server status files
5.2.19 Operands related to server status files (when an error occurs)
5.2.20 Operands related to work table files
5.2.21 Operands related to system log file configuration
5.2.22 Operands related to synchronization point dump file configuration
5.2.23 Operands related to Plug-ins
6. Front-End Server Definition
6.1 Operand formats
6.2 Operand explanations
6.2.1 Operands related to processes
6.2.2 Operands related to SQL optimization
6.2.3 Operands related to system monitoring
6.2.4 Operands related to SQL runtime warning output facility
6.2.5 Operand related to the facility for output of extended SQL error information
6.2.6 Operands related to lock
6.2.7 Operands related to buffers
6.2.8 Operands related to RPC trace information
6.2.9 Operands related to troubleshooting information
6.2.10 Operands related to security
6.2.11 Operands related to Java
6.2.12 Operands related to system log files
6.2.13 Operands related to synchronization point dump files
6.2.14 Operands related to server status files
6.2.15 Operands related to server status files (when an error occurs)
6.2.16 Operands related to system log file configuration
6.2.17 Operands related to synchronization point dump file configuration
6.2.18 Operands related to Plug-ins
7. Dictionary Server Definition
7.1 Operand formats
7.2 Operand explanations
7.2.1 Operands related to processes
7.2.2 Operands related to work tables
7.2.3 Operands related to system monitoring
7.2.4 Operands related to lock
7.2.5 Operands related to buffers
7.2.6 Operands related to shared memory
7.2.7 Operands related to the RPC trace information
7.2.8 Operands related to troubleshooting information
7.2.9 Operands related to global buffers
7.2.10 Operands related to Java
7.2.11 Operands related to system log files
7.2.12 Operands related to synchronization point dump files
7.2.13 Operands related to server status files
7.2.14 Operands related to server status files (when an error occurs)
7.2.15 Operands related to work table files
7.2.16 Operands related to system log file configuration
7.2.17 Operands related to synchronization point dump file configuration
7.2.18 Operands related to Plug-ins
8. Back-End Server Definition
8.1 Operand formats
8.2 Operand explanations
8.2.1 Operands related to processes
8.2.2 Operands related to work tables
8.2.3 Operands related to system monitoring
8.2.4 Operands related to lock
8.2.5 Operands related to buffers
8.2.6 Operands related to shared memory
8.2.7 Operands related to the RPC trace information
8.2.8 Operands related to troubleshooting information
8.2.9 Operands related to global buffers
8.2.10 Operands related to temporary tables
8.2.11 Operands related to delayed batch creation of plug-in index
8.2.12 Operands related to Java
8.2.13 Operands related to system log files
8.2.14 Operands related to synchronization point dump files
8.2.15 Operands related to server status files
8.2.16 Operands related to server status files (when an error occurs)
8.2.17 Operands related to the BES connection holding facility
8.2.18 Operands related to the work table files
8.2.19 Operands related to system log file configuration
8.2.20 Operands related to synchronization point dump file configuration
8.2.21 Operands related to Plug-ins
9. UAP Environment Definition
9.1 Operand formats
9.2 Operand explanations
Appendixes
A. Operand Specification Values
B. Examples of Definitions
B.1 HiRDB/Single Server
B.2 HiRDB/Single Server: system switchover facility being used
B.3 HiRDB/Parallel Server
B.4 HiRDB/Parallel Server: when the standby system switchover facility is used
B.5 HiRDB/Parallel Server: when the standby-less system switchover (1:1) facility is used
C. Formulas for Determining Operand Specification Values
C.1 Formulas for determining size of statistics log file (pd_stj_file_size)
C.2 Formulas for determining size of SQL object buffer (pd_sql_object_cache_size)
C.3 Formulas for determining size of view analysis information buffers (pd_view_def_cache_size)
C.4 Formulas for determining size of table definition information buffer (pd_table_def_cache_size)
C.5 Formula for determining total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt)
C.6 Formulas for determining size of routine definition information buffer (pd_routine_def_cache_size)
D. Determining the Number of Locked Resources
D.1 Definition SQLs
D.2 Data manipulation SQLs
D.3 Control SQL
D.4 Utilities and commands
E. Operands Checked by the pdconfchk Command
F. List of Operands That Can Be Specified When Using the Standby-less System Switchover (Effects Distributed) Facility (Unit Control Information Definition)
Index