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
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.