Nonstop Database

HiRDB Version 9

Description

3020-6-450-50(E)


Contents

Notices
Preface

1. Overview
1.1 Characteristics of HiRDB
1.1.1 Overview of HiRDB systems
1.1.2 Advantages of using HiRDB
1.2 HiRDB system configuration
1.2.1 HiRDB single server configuration
1.2.2 HiRDB parallel server configuration
1.2.3 Multi-HiRDB configuration
1.3 Database access modes

2. Linking to HiRDB Option Program Products and Other HiRDB-Related Products
2.1 HiRDB option program products
2.1.1 HiRDB Advanced High Availability
2.1.2 HiRDB Staticizer Option (UNIX edition only)
2.1.3 HiRDB Non-Recover FES
2.1.4 HiRDB Disaster Recovery Light Edition (UNIX edition only)
2.1.5 HiRDB Accelerator
2.2 Linkage to data linkage products
2.2.1 Linkage to HiRDB Datareplicator and HiRDB Dataextractor
2.3 Linkage to OLTP products
2.3.1 OLTP products to which HiRDB can be linked
2.3.2 HiRDB XA library
2.3.3 Functions provided by the HiRDB XA library
2.3.4 System configuration
2.3.5 Registration of HiRDB in the transaction manager
2.4 Linkage to operation support products
2.4.1 HiRDB SQL Executer
2.4.2 HiRDB Control Manager
2.4.3 HiRDB SQL Tuning Advisor
2.4.4 JP1/Performance Management - Agent Option for HiRDB
2.4.5 JP1/Base
2.4.6 JP1/Integrated Management
2.4.7 JP1/Automatic Job Management System 3
2.4.8 JP1/NETM/Audit
2.5 Linkage with products that handle multimedia information
2.6 Linkage to Cosminexus

3. Database Logical Structure
3.1 RDAREAs
3.1.1 Types of RDAREAs
3.1.2 RDAREA creation
3.2 Schemas
3.3 Tables
3.3.1 Basic table structure
3.3.2 Table normalization
3.3.3 FIX attribute
3.3.4 Primary key
3.3.5 Cluster key
3.3.6 Suppress option
3.3.7 No-split option
3.3.8 Table row partitioning
3.3.9 Table matrix partitioning
3.3.10 Changing the partitioning storage conditions of a table
3.3.11 Falsification-prevention table
3.3.12 Tables used in numbering
3.3.13 Repetition columns
3.3.14 View table
3.3.15 Shared tables
3.3.16 Compressed tables
3.3.17 Temporary tables
3.4 Indexes
3.4.1 Basic structure of an index
3.4.2 Index row partitioning
3.4.3 Index page splitting
3.4.4 Exception key value
3.4.5 Defining an index for a table that contains data
3.4.6 Index key value no-lock
3.5 Expansion into an object relational database
3.5.1 Abstract data types
3.5.2 Subtypes and inheritance
3.5.3 Encapsulation

4. Database Physical Structure
4.1 Database physical structure
4.2 Segment design
4.3 Page design

5. Database Access Using SQL
5.1 Use of SQL in HiRDB
5.1.1 HiRDB SQL functions
5.1.2 SQL execution methods
5.2 Basic data manipulation
5.2.1 Cursor
5.2.2 Data retrieval
5.2.3 Data updating
5.2.4 Data deletion
5.2.5 Data insertion
5.2.6 Searching for specific data
5.2.7 Data operations
5.2.8 Data processing
5.2.9 Manipulation of data in a table containing an abstract data type
5.3 Stored procedures and stored functions
5.4 Java stored procedures and Java stored functions
5.4.1 Environments in which Java stored procedures and Java stored functions can be used
5.4.2 Characteristics of an external Java stored routine
5.4.3 System configuration (position of a Java virtual machine)
5.4.4 Executing external Java stored routines
5.4.5 External Java stored routine creation and execution procedure
5.5 C stored procedures and C stored functions
5.5.1 Characteristics of an external C stored routine
5.5.2 External C stored routine creation and execution procedure
5.6 Triggers
5.7 Integrity constraints
5.7.1 NOT NULL constraint
5.7.2 Uniqueness constraint
5.8 Referential constraints
5.9 Check constraints
5.10 Check pending status
5.11 Improving database access performance
5.11.1 Block transfer facility
5.11.2 Rapid grouping facility
5.11.3 Functions that use arrays
5.11.4 Holdable cursor
5.11.5 SQL optimization
5.12 Narrowed search
5.13 Automatic numbering facility
5.14 Accessing databases using DB access products
5.14.1 ODBC Driver
5.14.2 HiRDB OLE DB Provider
5.14.3 HiRDB.NET Data Provider
5.14.4 JDBC Driver
5.14.5 SQLJ

6. HiRDB Architecture
6.1 HiRDB environment setup
6.2 HiRDB file system areas
6.3 System files
6.3.1 System log files
6.3.2 Synchronization point dump files
6.3.3 Status files
6.3.4 System file components
6.4 Work table files
6.5 HiRDB system definitions
6.5.1 HiRDB system definitions for a HiRDB single server configuration
6.5.2 HiRDB system definitions for a HiRDB parallel server configuration
6.5.3 HiRDB system definition file creation
6.5.4 System reconfiguration command (pdchgconf command)
6.6 HiRDB startup and termination
6.6.1 Startup and termination modes
6.6.2 HiRDB automatic startup
6.6.3 Reduced activation (applicable to HiRDB parallel server configurations only)
6.7 Delayed rerun
6.8 Database access processing method
6.8.1 Global buffers
6.8.2 In-memory data processing
6.8.3 Prefetch facility
6.8.4 Asynchronous READ facility
6.8.5 Deferred write processing
6.8.6 Facility for parallel writes in deferred write processing
6.8.7 Incorporation during commit
6.8.8 LRU management method for global buffers
6.8.9 Accessing pages using the snapshot method
6.8.10 Global buffer pre-writing
6.8.11 Local buffers
6.8.12 BLOB data file output facility
6.8.13 Partial update or retrieval of BLOB or BINARY data
6.8.14 Locator facility
6.9 Transaction control
6.9.1 Connection to and disconnection from HiRDB
6.9.2 Multi-connection facility
6.9.3 Transaction startup and termination
6.9.4 Commit and rollback
6.9.5 UAP transaction management under OLTP environment
6.9.6 Automatic reconnect facility
6.10 Locking
6.10.1 Units of locking
6.10.2 Lock modes
6.10.3 Automatic locking by HiRDB
6.10.4 Changing the lock based on a user setting
6.10.5 Lock period
6.10.6 Deadlock
6.11 Operation without collecting a database update log

7. Database Management
7.1 Database recovery
7.1.1 Overview of database recovery
7.1.2 Times at which database can be recovered
7.2 Preparations for database errors
7.2.1 Making backups
7.2.2 Unloading system logs (creating unload log files)
7.2.3 Differential backup facility
7.2.4 Backup-hold
7.2.5 Reducing the time needed to make backups of user LOB RDAREAs (frozen update command)
7.2.6 NetBackup linkage facility
7.3 Reorganizing tables and indexes
7.3.1 Table reorganization
7.3.2 Index reorganization
7.4 Reusing used free pages and used free segments
7.4.1 Reusing used free pages
7.4.2 Reusing used free segments
7.5 Adding, expanding, and moving RDAREAs
7.5.1 Adding RDAREAs
7.5.2 Expanding an RDAREA
7.5.3 RDAREA automatic extension
7.5.4 Moving RDAREAs (HiRDB parallel server configurations only)
7.6 Space conversion facility
7.7 Facility for conversion to a decimal signed normalized number

8. Error-handling Facilities
8.1 System switchover facility
8.1.1 Overview of the system switchover facility
8.1.2 Operating the system switchover facility
8.1.3 System switchover facility configurations
8.1.4 System configuration examples
8.1.5 Functions that reduce system switchover time (user server hot standby and the rapid system switchover facility)
8.2 Recovery-unnecessary front-end servers
8.2.1 Overview of recovery-unnecessary front-end servers
8.2.2 Configuration example of a system that uses a recovery-unnecessary front-end server
8.3 Real Time SAN Replication (disaster recovery) (UNIX edition only)
8.3.1 Overview of Real Time SAN Replication
8.3.2 Prerequisite platforms and products
8.3.3 Methods of mirroring data to the remote site
8.3.4 All synchronous method
8.3.5 All asynchronous method
8.3.6 Hybrid method
8.3.7 Log-only synchronous method

9. Facilities Related to Security Measures
9.1 Security facility
9.1.1 User privileges
9.1.2 Operating the security facility
9.2 Security audit facility
9.2.1 Overview of the security audit facility
9.2.2 Audit events
9.3 Connection security facility
9.3.1 Overview of the connection security facility
9.3.2 Restrictions on password character strings
9.3.3 Restrictions on the number of consecutive certification failures

10. Plug-ins
10.1 Overview of HiRDB plug-ins
10.2 Applying a plug-in to a job
10.3 HiRDB plug-in facilities
10.3.1 HiRDB Text Search Plug-in
10.3.2 HiRDB Spatial Search Plug-in
10.3.3 HiRDB XML Extension
10.4 Preparations for using plug-ins in HiRDB
10.4.1 Setup and registration of a plug-in
10.4.2 Initialization of the registry facility
10.4.3 Table definition for plug-in usage
10.4.4 Delayed batch creation of plug-in index

Appendixes
A. Functional Differences Between HiRDB Versions on Different Platforms
B. Data Dictionary Tables
C. HiRDB Client and HiRDB Server Connectivity
D. List of Facilities That Are No Longer Supported
E. Glossary

Index