HITACHI Inspire The Next

For Windows Systems

Scalable Database Server

HiRDB Version 8

System Definition

3020-6-353(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 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 Operands whose specification values can be changed
2.3 Operand explanations
2.3.1 Operands related to the system structure
2.3.2 Operands related to maximum concurrent executions
2.3.3 Operands related to HiRDB startup
2.3.4 Operands related to reduced activation
2.3.5 Operands related to HiRDB processing
2.3.6 Operands related to full recovery processing
2.3.7 Operands related to transaction decision processing
2.3.8 Operands related to SQL optimization
2.3.9 Operands related to narrowed retrieval
2.3.10 Operands related to system monitoring
2.3.11 Operands related to SQL runtime warning output facility
2.3.12 Operands related to the facility for output of extended SQL error information
2.3.13 Operands related to the SQL reserved word deletion facility
2.3.14 Operands related to lock
2.3.15 Operands related to buffers
2.3.16 Operands related to message log files
2.3.17 Operands related to statistical information
2.3.18 Operands related to RPC trace information
2.3.19 Operands related to troubleshooting information
2.3.20 Operands related to RDAREAs
2.3.21 Operands related to global buffers
2.3.22 Operands related to table or index reservation count
2.3.23 Operands related to referential and check constraints
2.3.24 Operands related to HiRDB file system areas
2.3.25 Operands related to the facility for predicting reorganization time
2.3.26 Operands related to security audit facility
2.3.27 Operands related to the system switchover facility
2.3.28 Operands related to HiRDB Datareplicator
2.3.29 Operands related to linkage to JP1
2.3.30 Operands related to Directory Server linkage facility
2.3.31 Operands related to HiRDB External Data Access facility
2.3.32 Operands related to OLTP
2.3.33 Operands related to version upgrade
2.3.34 Operands related to communication processing
2.3.35 Operands related to JavaTM
2.3.36 Operands related to unit structure
2.3.37 Operands related to server structure
2.3.38 Operands related to the global buffers
2.3.39 Operands related to HA groups
2.3.40 Operands related to statistical information
2.3.41 Operands related to a client group
2.3.42 Operands related to plug-ins
2.3.43 Operands related to shared memory
2.3.44 Operands related to date and time
2.3.45 Operands related to the message output suppression facility
2.3.46 Operands related to character encoding
3. Unit Control Information Definition
3.1 Operand formats
3.2 Operands whose specification values can be changed
3.3 Operand explanations
3.3.1 Operands related to system structure
3.3.2 Operands related to maximum concurrent executions
3.3.3 Operands related to HiRDB processing
3.3.4 Operands related to full recovery processing
3.3.5 Operands related to system monitoring
3.3.6 Operands related to SQL runtime warning output facility
3.3.7 Operands related to the facility for output of extended SQL error information
3.3.8 Operands related to lock
3.3.9 Operands related to statistical information
3.3.10 Operands related to RPC trace information
3.3.11 Operands related to troubleshooting information
3.3.12 Operands related to global buffers
3.3.13 Operands related to unit status files
3.3.14 Operands related to unit status files (when an error occurs)
3.3.15 Operands related to security audit facility
3.3.16 Operands related to the system switchover facility
3.3.17 Operands related to HiRDB Datareplicator
3.3.18 Operands related to communication processing
3.3.19 Operands related to Java
3.3.20 Operands related to shared memory
4. Server Common Definition
4.1 Operand formats
4.2 Operands whose specification values can be changed
4.3 Operand explanations
4.3.1 Operands related to processes
4.3.2 Operands related to work tables
4.3.3 Operands related to system monitoring
4.3.4 Operands related to lock
4.3.5 Operands related to buffers
4.3.6 Operands related to shared memory
4.3.7 Operands related to RPC trace information
4.3.8 Operands related to troubleshooting information
4.3.9 Operands related to global buffers
4.3.10 Operands related to the security audit facility
4.3.11 Operands related to Java
4.3.12 Operands related to system log files
4.3.13 Operands related to synchronization point dump files
4.3.14 Operands related to server status files (when an error occurs)
4.3.15 Operands related to the BES connection holding facility
5. Single Server Definition
5.1 Operand formats
5.2 Operands whose specification values can be changed
5.3 Operand explanations
5.3.1 Operands related to processes
5.3.2 Operands related to work tables
5.3.3 Operands related to system monitoring
5.3.4 Operands related to SQL runtime warning output facility
5.3.5 Operand related to the facility for output of extended SQL error information
5.3.6 Operands related to lock
5.3.7 Operands related to buffers
5.3.8 Operands related to shared memory
5.3.9 Operands related to RPC trace information
5.3.10 Operands related to troubleshooting information
5.3.11 Operands related to global buffers
5.3.12 Operands related to the security audit facility
5.3.13 Operands related to delayed batch creation of plug-in index
5.3.14 Operands related to Java
5.3.15 Operands related to system log files
5.3.16 Operands related to synchronization point dump files
5.3.17 Operands related to server status files
5.3.18 Operands related to server status files (when an error occurs)
5.3.19 Operands related to work table files
5.3.20 Operands related to system log file configuration
5.3.21 Operands related to synchronization point dump file configuration
5.3.22 Operands related to Plug-ins
6. Front-End Server Definition
6.1 Operand formats
6.2 Operands whose specification values can be changed
6.3 Operand explanations
6.3.1 Operands related to processes
6.3.2 Operands related to SQL optimization
6.3.3 Operands related to system monitoring
6.3.4 Operands related to SQL runtime warning output facility
6.3.5 Operand related to the facility for output of extended SQL error information
6.3.6 Operands related to lock
6.3.7 Operands related to buffers
6.3.8 Operands related to RPC trace information
6.3.9 Operands related to troubleshooting information
6.3.10 Operands related to the security audit facility
6.3.11 Operands related to Java
6.3.12 Operands related to system log files
6.3.13 Operands related to synchronization point dump files
6.3.14 Operands related to server status files
6.3.15 Operands related to server status files (when an error occurs)
6.3.16 Operands related to system log file configuration
6.3.17 Operands related to synchronization point dump file configuration
6.3.18 Operands related to Plug-ins
6.3.19 Operands related to HiRDB External Data Access facility
7. Dictionary Server Definition
7.1 Operand formats
7.2 Operands whose specification values can be changed
7.3 Operand explanations
7.3.1 Operands related to processes
7.3.2 Operands related to work tables
7.3.3 Operands related to system monitoring
7.3.4 Operands related to lock
7.3.5 Operands related to buffers
7.3.6 Operands related to shared memory
7.3.7 Operands related to the RPC trace information
7.3.8 Operands related to troubleshooting information
7.3.9 Operands related to global buffers
7.3.10 Operands related to Java
7.3.11 Operands related to system log files
7.3.12 Operands related to synchronization point dump files
7.3.13 Operands related to server status files
7.3.14 Operands related to server status files (when an error occurs)
7.3.15 Operands related to work table files
7.3.16 Operands related to system log file configuration
7.3.17 Operands related to synchronization point dump file configuration
7.3.18 Operands related to Plug-ins
8. Back-End Server Definition
8.1 Operand formats
8.2 Operands whose specification values can be changed
8.3 Operand explanations
8.3.1 Operands related to processes
8.3.2 Operands related to work tables
8.3.3 Operands related to system monitoring
8.3.4 Operands related to lock
8.3.5 Operands related to buffers
8.3.6 Operands related to shared memory
8.3.7 Operands related to the RPC trace information
8.3.8 Operands related to troubleshooting information
8.3.9 Operands related to global buffers
8.3.10 Operands related to delayed batch creation of plug-in index
8.3.11 Operands related to Java
8.3.12 Operands related to HiRDB External Data Access facility
8.3.13 Operands related to system log files
8.3.14 Operands related to synchronization point dump files
8.3.15 Operands related to server status files
8.3.16 Operands related to server status files (when an error occurs)
8.3.17 Operands related to the BES connection holding facility
8.3.18 Operands related to the work table files
8.3.19 Operands related to system log file configuration
8.3.20 Operands related to synchronization point dump file configuration
8.3.21 Operands related to Plug-ins
8.3.22 Operands related to HiRDB External Data Access facility (environment variables)
9. UAP Environment Definition
9.1 Operand formats
9.2 Operand explanations
10. Foreign Server Information Definition (When a Foreign Server Is HiRDB)
10.1 Operand formats
10.2 Operand explanations
10.2.1 Operands related to connection to and disconnection from a foreign server
10.2.2 Operands related to foreign server error information
10.2.3 Operands related to foreign server interface trace information
10.2.4 Operands related to FETCH
10.2.5 Operands related to connection to a foreign server
10.2.6 Operands related to the database update log
10.2.7 Operands related to client group
10.2.8 Operands related to communication processing
10.2.9 Operands related to system monitoring
10.2.10 Operands related to troubleshooting information
10.2.11 Operands related to lock
10.2.12 Operands related to inner replica facility
10.2.13 Operands related to SQL optimization
10.2.14 Operands related to the facility for output of extended SQL error information
10.2.15 Operands related to the BES connection holding facility
10.2.16 Operand related to the system switchover facility
10.3 Notes
11. Foreign Server Information Definition (When a Foreign Server Is XDM/RD E2)
11.1 Operand formats
11.2 Operand explanations
11.2.1 Operands related to connection to and disconnection from a foreign server
11.2.2 Operands related to foreign server error information
11.2.3 Operands related to foreign server interface trace information
11.2.4 Operands related to connection to a foreign server
11.2.5 Operands related to system monitoring
11.2.6 Operands related to troubleshooting information
11.2.7 Operands related to data transfer
11.3 Client environment definitions with fixed values that are applied to a foreign server (XDM/RD E2)
12. Foreign Server Information Definition (When a Foreign Server Is ORACLE)
12.1 Operand formats
12.2 Operand explanations
12.2.1 Operands related to connection to and disconnection from a foreign server
12.2.2 Operands related to foreign server error information
12.2.3 Operands related to foreign server interface trace information
12.2.4 Operands related to FETCH
12.2.5 Operands related to troubleshooting information
12.2.6 Operands related to lock
12.2.7 Operands related to DESCRIBE statement
12.2.8 Operands related to connection to a foreign server
13. Hub Optimization Information Definition
13.1 Operand formats
13.2 Operand explanations
13.3 Notes
13.4 Recommended values for various foreign servers
Appendixes
A. List of Operands
B. Operand Specification Values
C. Examples of Definitions
C.1 Example 1 (HiRDB/Single Server)
C.2 Example 2 (HiRDB/Single Server: system switchover facility being used)
C.3 Example 3 (HiRDB/Parallel Server)
C.4 Example 4 (HiRDB/Parallel Server: when the standby system switchover facility is used)
C.5 Example 5 (HiRDB/Parallel Server: when the standby-less system switchover (1:1) facility is used)
C.6 Example 6 (when the HiRDB External Data Access facility is used)
D. Formulas for Determining Operand Specification Values
D.1 Formulas for determining size of statistics log file (pd_stj_file_size)
D.2 Formulas for determining size of SQL object buffer (pd_sql_object_cache_size)
D.3 Formulas for determining size of table definition information buffer (pd_table_def_cache_size)
D.4 Formula for determining total number of tables and RDAREAs per server locked with UNTIL DISCONNECT specified (pd_lck_until_disconnect_cnt)
D.5 Formulas for determining size of routine definition information buffer (pd_routine_def_cache_size)
E. Determining the Number of Locked Resources
E.1 Definition SQLs
E.2 Data manipulation SQLs
E.3 Control SQL
E.4 Utilities and commands
F. Operands Checked by the pdconfchk Command
G. List of Operands That Can Be Specified When Using the Standby-less System Switchover (Effects Distributed) Facility (Unit Control Information Definition)
Index