HITACHI Inspire The Next

For UNIX Systems

Nonstop Database

HiRDB Version 9

System Definition

3000-6-453-50(E)


Contents

Notices
Preface
1. Overview
1.1 For users of a HiRDB single server configuration
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 configuration
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.2.8 Sharing of HiRDB system definition files
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
1.5.1 Changes in HiRDB system definitions depending on the version and revision
1.5.2 Changes in HiRDB system definitions in versions earlier than 09-50
1.5.3 Operands whose default value differs between 32-bit mode and 64-bit mode
1.6 Database sizes that can be defined by default values
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 searches
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 the facility for predicting reorganization time
2.2.32 Operands related to security
2.2.33 Operands related to the system switchover facility
2.2.34 Operands related to HiRDB Datareplicator
2.2.35 Operands related to linkage to JP1
2.2.36 Operands related to Real Time SAN Replication
2.2.37 Operands related to the inner replica facility
2.2.38 Operands related to OLTP
2.2.39 Operands related to version upgrade
2.2.40 Operands related to communication processing
2.2.41 Operands related to Java
2.2.42 Operands related to external C stored routines
2.2.43 Operands related to character encoding
2.2.44 Operand related to user authentication
2.2.45 Operands related to unit structure
2.2.46 Operands related to server structure
2.2.47 Operands related to the global buffers
2.2.48 Operands related to HA groups
2.2.49 Operands related to statistical information
2.2.50 Operands related to a client group
2.2.51 Operands related to plug-ins
2.2.52 Operands related to Real Time SAN Replication
2.2.53 Operands related to shared memory
2.2.54 Operands related to date and time
2.2.55 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 startup
3.2.4 Operands related to HiRDB processing
3.2.5 Operands related to full recovery processing
3.2.6 Operands related to transaction decision processing
3.2.7 Operands related to system monitoring
3.2.8 Operands related to SQL runtime warning output facility
3.2.9 Operands related to the facility for output of extended SQL error information
3.2.10 Operands related to lock
3.2.11 Operands related to buffers
3.2.12 Operands related to shared memory
3.2.13 Operands related to statistical information
3.2.14 Operands related to RPC trace information
3.2.15 Operands related to performance trace information
3.2.16 Operands related to troubleshooting information
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
3.2.27 Operands related to sharing of HiRDB system definition files
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 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
10. Operands that Must Be Examined If Compatibility Mode Is To Be Applied
10.1 List of operands
10.2 Operand formats
10.3 Operand explanations
10.3.1 Operands related to maximum concurrent executions
10.3.2 Operands related to HiRDB processing
10.3.3 Operands related to transaction decision processing
10.3.4 Operands related to SQL specifications
10.3.5 Operands related to SQL optimization
10.3.6 Operands related to temporary tables
10.3.7 Operands related to communication processing
10.3.8 Operands related to date and time
10.3.9 Operands related to unit status files (when an error occurs)
10.3.10 Operands related to server status files (when an error occurs)
10.3.11 Operands related to system log files
10.4 Operands checkable by the pdconfchk command
10.5 Operands specifiable under each OS
Appendixes
A. Operand Specification Values
B. Examples of Definitions
B.1 HiRDB single server configuration
B.2 HiRDB single server configuration: with utility special unit
B.3 HiRDB single server configuration: system switchover facility being used
B.4 HiRDB parallel server configuration
B.5 HiRDB parallel server configuration: when the standby system switchover facility is used
B.6 HiRDB parallel server configuration: 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. Operands Specifiable Under Each OS
G. List of Operands That Can Be Specified When Using the Standby-less System Switchover (Effects Distributed) Facility (Unit Control Information Definition)
Index