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 Advanced Partitioning Option

2.1.3 HiRDB LDAP Option

2.1.4 HiRDB External Data Access

2.1.5 HiRDB Non-Recover FES

2.2 Linkage to data linkage products

2.2.1 Linkage to HiRDB Datareplicator and HiRDB Dataextractor

2.2.2 Linkage to HiRDB Adapter for XML

2.3 Linkage to directory server products

2.3.1 Overview of the Directory Server linkage facility

2.3.2 Directory servers to which HiRDB can be linked

2.3.3 Capabilities provided by the Directory Server linkage facility

2.3.4 Prerequisite products

2.4 Linkage to OLTP products

2.4.1 OLTP products to which HiRDB can be linked

2.4.2 HiRDB XA library

2.4.3 Functions provided by the HiRDB XA library

2.4.4 System configuration

2.4.5 Registration of HiRDB in the transaction manager

2.5 Linkage to operation support products

2.5.1 HiRDB SQL Executer

2.5.2 HiRDB Control Manager

2.5.3 HiRDB SQL Tuning Advisor

2.5.4 JP1/Performance Management - Agent Option for HiRDB

2.5.5 JP1/Base

2.5.6 JP1/Integrated Management

2.5.7 JP1/Automatic Job Management System 2

2.6 Linkage to data mining products

2.7 Linkage to products that handle multimedia information

2.8 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.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 Characteristics of a Java stored routine

5.4.2 System configuration (position of a Java virtual machine)

5.4.3 Execution of Java stored routines

5.4.4 Java stored routine creation and execution procedure

5.5 Triggers

5.6 Integrity constraints

5.6.1 NOT NULL constraint

5.6.2 Uniqueness constraint

5.7 Referential constraints

5.8 Check constraints

5.9 Check pending status

5.10 Improving database access performance

5.10.1 Block transfer facility

5.10.2 Rapid grouping facility

5.10.3 Functions that use arrays

5.10.4 Holdable cursor

5.10.5 SQL optimization

5.11 Narrowed search

5.12 Accessing databases using DB access products

5.12.1 ODBC Driver

5.12.2 HiRDB OLE DB Provider

5.12.3 HiRDB.NET Data Provider

5.12.4 JDBC Driver

5.12.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

6.5.2 HiRDB system definitions for a HiRDB/Parallel Server

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 only)

6.7 Delayed rerun

6.8 Database access processing method

6.8.1 Global buffers

6.8.2 Prefetch facility

6.8.3 Asynchronous READ facility

6.8.4 Deferred write processing

6.8.5 Facility for parallel writes in deferred write processing

6.8.6 Incorporation during commit

6.8.7 LRU management method for global buffers

6.8.8 Accessing pages using the snapshot method

6.8.9 Global buffer pre-writing

6.8.10 Local buffers

6.8.11 BLOB data file output facility

6.8.12 BLOB and BINARY data addition update and partial extraction facility

6.8.13 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 Creating an unload log file (unloading system log)

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 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 Monitor mode and server mode

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

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 Image Search Plug-in

10.3.3 HiRDB File Link

10.3.4 HiRDB Spatial Search Plug-in

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

11. 64-Bit-Mode HiRDB

11.1 Overview

11.2 Functions not available in 64-bit-mode HiRDB

11.3 Differences between 32- and 64-bit modes

11.3.1 Differences in HiRDB system definition

11.3.2 Differences in client environment definition

11.3.3 64-bit-mode HiRDB client support range

11.4 Migrating from 32-bit mode to 64-bit mode

Appendixes

A. Functional Differences Between HiRDB Versions on Different Platforms

B. Data Dictionary Tables

C. HiRDB Client and HiRDB Server Connectivity

D. Glossary

Index

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.