Preface

This manual describes the system definitions for HiRDB Version 9, a nonstop database server program product.

Intended readers

This manual is intended for users who will construct and/or operate a relational database system using HiRDB Version 9 (hereafter referred to as HiRDB).

The manual assumes that you have the following:

Please read the HiRDB Version 9 Description manual before reading this manual.

Organization of this manual

This manual is organized into the following chapters and appendixes:

1. Overview of HiRDB System Construction
Chapter 1 describes the HiRDB system construction procedure, organization of the HiRDB files, and upgrading procedure.
2. Installation
Chapter 2 describes tasks that are required before and after installation, and explains the procedures for installing and uninstalling HiRDB. It also provides notes concerning the installation of option program products.
This chapter also explains how to register and remove exceptions in the Windows Firewall Exceptions list.
3. Setting Up an Environment Using the Simple Setup Tool
Chapter 3 describes use of the simple setup tool for environment setup for a HiRDB system.
4. Setting Up an Environment Using Commands
Chapter 4 describes the procedure for setting up the HiRDB environment using commands.
5. Setting Up the Plug-in Environment
Chapter 5 describes the procedures for setting up the plug-in environment, along with the procedures for upgrading and deleting (uninstalling) it.
6. Creating Databases
Chapter 6 describes the procedures from schema, table, and index creation through data storage.
7. Linking to Other Products
Chapter 7 describes how to link HiRDB to other products.
8. Designing a HiRDB/Single Server
Chapter 8 describes the system configuration of a HiRDB/Single Server, the procedure for designing its HiRDB file system areas and system files, and provides notes about placement of RDAREAs.
9. Designing a HiRDB/Parallel Server
Chapter 9 describes the system configuration of a HiRDB/Parallel Server, the procedure for designing its HiRDB file system areas and system files, and provides notes about placement of RDAREAs.
10. Designing a Multi-HiRDB
Chapter 10 describes the design of a multi-HiRDB.
11. Designing Global Buffers and Local Buffers
Chapter 11 describes global-buffer and local-buffer design.
12. Designing Tables
Chapter 12 describes table design.
13. Designing Indexes
Chapter 13 describes the design of indexes and plug-in indexes.
14. Designing RDAREAs
Chapter 14 describes the design of the segments and pages that constitute an RDAREA.
15. Storage Requirements for HiRDB
Chapter 15 explains how to determine the storage requirements for a HiRDB/Single Server and a HiRDB/Parallel Server.
16. Determining RDAREA Size
Chapter 16 explains how to determine the size of each type of RDAREA.
17. Determining the Size of System Files and Audit Trail Files
Chapter 17 explains how to determine the size of system files, such as system log files, synchronization point dump files, and status files. This chapter also explains how to determine the size of audit trail files.
18. Determining Work Table File Size
Chapter 18 explains how to determine the size of a work-table file.
19. Storage Requirements for Utility Execution
Chapter 19 explains how to determine the file sizes and storage requirements for executing utilities.
20. Determining Environment Variables Related to the Number of Resources
Chapter 20 explains how to determine the environment variables related to the number of resources.
21. Windows Registry Settings
Chapter 21 explains how to determine the Windows registry settings.
22. Sample Files
Chapter 22 describes the sample files provided with HiRDB (sample database, configuration, and UOC).
23. Communication Between HiRDB Servers and HiRDB Clients
Chapter 23 explains how to connect HiRDB clients with HiRDB servers. It also describes the settings for a DNS server and a firewall.
A. HiRDB Maximum and Minimum Values
Appendix A lists the maximum and minimum values for HiRDB system configuration.
B. Processes Started by HiRDB
Appendix B lists and describes the processes that are started by HiRDB.
C. Questions and Answers
Appendix C provides examples of HiRDB system setup in a question and answer format.
D. Setting Up an Environment Using a Batch File
Appendix D describes the procedure for setting up the HiRDB server environment using a batch file, which automatically sets up a sample environment.

Related publications

This manual is related to the following manuals, which should be read as required.

HiRDB (for Windows)
HiRDB (for UNIX)
HiRDB (for both Windows and UNIX)

In references to HiRDB Version 9 manuals, this manual omits the phrases for UNIX systems and for Windows systems. Refer to either the UNIX or Windows HiRDB manual, whichever is appropriate for your platform.

For related products

#: This manual has been published in Japanese only; it is not available in English.

Organization of HiRDB manuals

The HiRDB manuals are organized as shown below. For the most efficient use of these manuals, it is suggested that they be read in the order they are shown, going from left to right.

[Figure]

[Figure]

Conventions: Abbreviations for product names

This manual uses the following abbreviations for product names:

Full name or meaningAbbreviation
HiRDB Server Version 9HiRDB/Single ServerHiRDB or HiRDB Server
HiRDB/Parallel Server
HiRDB/Developer's Kit Version 9HiRDB/Developer's KitHiRDB Client
HiRDB/Developer's Kit Version 9(64)
HiRDB/Run Time Version 9HiRDB/Run Time
HiRDB/Run Time Version 9(64)
HiRDB Accelerator Version 8HiRDB Accelerator
HiRDB Accelerator Version 9
HiRDB Adapter for XML - Standard EditionHiRDB Adapter for XML
HiRDB Adapter for XML - Enterprise Edition
HiRDB Advanced High Availability Version 9HiRDB Advanced High Availability
HiRDB Control ManagerHiRDB CM
HiRDB Control Manager AgentHiRDB CM Agent
HiRDB Dataextractor Version 8HiRDB Dataextractor
HiRDB Datareplicator Version 8HiRDB Datareplicator
HiRDB Disaster Recovery Light Edition Version 9HiRDB Disaster Recovery Light Edition
HiRDB Non Recover Front End Server Version 9HiRDB Non Recover FES
HiRDB Staticizer Option Version 9HiRDB Staticizer Option
HiRDB Text Search Plug-in Version 9HiRDB Text Search Plug-in
HiRDB XML Extension Version 9HiRDB XML Extension
Single serverSDS
System managerMGR
Front-end serverFES
Dictionary serverDS
Back-end serverBES
Microsoft(R) ActiveX(R)ActiveX
DNCWARE ClusterPerfect (Linux Edition)ClusterPerfect
DataStage(R)DataStage
DB2 Universal Database for OS/390 Version 6DB2
JP1/Magnetic Tape AccessEasyMT
EasyMT
JP1/Automatic Job Management System 2 - Scenario OperationJP1/AJS2-SO
JP1/Automatic Job Management System 3JP1/AJS3
JP1/Automatic Job Management System 2
JP1/Cm2/Extensible SNMP AgentJP1/ESA
JP1/Cm2/Extensible SNMP Agent for Mib Runtime
JP1/Integrated Management - ManagerJP1/Integrated Management or JP1/IM
JP1/Integrated Management - View
JP1/NETM/Audit - ManagerJP1/NETM/Audit
JP1/NETM/DMJP1/NETM/DM
JP1/NETM/DM Manager
JP1/Cm2/Network Node ManagerJP1/NNM
JP1/Performance ManagementJP1/PFM
JP1/Performance Management - Agent Option for HiRDBJP1/PFM-Agent for HiRDB
JP1/Performance Management - Agent Option for PlatformJP1/PFM-Agent for Platform
JP1/Performance Management/SNMP System ObserverJP1/SSO
JP1/VERITAS NetBackup BS V4.5 Agent for HiRDB LicenseJP1/VERITAS NetBackup Agent for HiRDB License
JP1/VERITAS NetBackup V4.5 Agent for HiRDB License
JP1/VERITAS NetBackup 5 Agent for HiRDB License
LifeKeeper for Linux V7 Update1LifeKeeper
MetaBroker(R)MetaBroker
MetaStage(R)MetaStage
Microsoft(R) Office ExcelMicrosoft Excel or Excel
JP1/Magnetic Tape LibraryMTguide
JP1/VERITAS NetBackup BS v4.5NetBackup
JP1/VERITAS NetBackup v4.5
PowerHA for AIX, V5.5PowerHA
PowerHA SystemMirror V6.1
QualityStage(TM)QualityStage
OpenTP1/Server Base Enterprise OptionTP1/EE
Hitachi TrueCopyTrueCopy
Hitachi TrueCopy Asynchronous
Hitachi TrueCopy basic
Hitachi TrueCopy Software
TrueCopy
TrueCopy Asynchronous
TrueCopy remote replicator
Hitachi Universal Replicator SoftwareUniversal Replicator
Universal Replicator
Microsoft(R) Visual C++(R)Visual C++ or C++ language
Oracle WebLogic ServerWebLogic Server
Virtual-storage Operating System 3/Forefront System ProductVOS3/FSVOS3
Virtual-storage Operating System 3/Leading System ProductVOS3/LS
Virtual-storage Operating System 3/Unific System ProductVOS3/US
VOS3 Database Connection ServerDB Connection Server
Extensible Data Manager/Base Extended Version 2
XDM Basic Program XDM/BASE E2
XDM/BASE E2
XDM/Data Communication and Control Manager 3
XDM Data Communication Management System XDM/DCCM3
XDM/DCCM3
XDM/Relational Database
Relational Database System XDM/RD
XDM/RDXDM/RD
XDM/Relational Database Extended Version 2
Relational Database System XDM/RD E2
XDM/RD E2
HP-UX 11i V2 (IPF)HP-UX or HP-UX (IPF)
HP-UX 11i V3 (IPF)
AIX 5L V5.2AIX 5LAIX
AIX 5L V5.3
AIX V6.1AIX V6.1
AIX V7.1AIX V7.1
Linux(R)Linux
Red Hat Enterprise Linux(R) AS 4(AMD64 & Intel EM64T)Linux AS 4Linux
Red Hat Enterprise Linux(R) AS 4(x86)
Red Hat Enterprise Linux(R) ES 4(AMD64 & Intel EM64T)Linux ES 4
Red Hat Enterprise Linux(R) ES 4(x86)
Red Hat Enterprise Linux(R) 5 Advanced Platform (x86)Linux 5
Red Hat Enterprise Linux(R) 5 (x86)
Red Hat Enterprise Linux(R) 5 Advanced Platform (AMD/Intel 64)
Red Hat Enterprise Linux(R) 5 (AMD/Intel 64)
Red Hat Enterprise Linux 6 (32-bit x86)Linux 6
Red Hat Enterprise Linux 6 (64-bit x86_64)
Red Hat Enterprise Linux(R) AS 4(AMD64 & Intel EM64T)Linux (EM64T)
Red Hat Enterprise Linux(R) ES 4(AMD64 & Intel EM64T)
Red Hat Enterprise Linux(R) 5 Advanced Platform (AMD/Intel 64)
Red Hat Enterprise Linux(R) 5 (AMD/Intel 64)
Red Hat Enterprise Linux 6 (32-bit x86)
Red Hat Enterprise Linux 6 (64-bit x86_64)
Red Hat Enterprise Linux(R) 5 Advanced Platform (x86)Linux 5 (x86)Linux 5
Red Hat Enterprise Linux(R) 5 (x86)
Red Hat Enterprise Linux(R) 5 Advanced Platform (AMD/Intel 64)Linux 5 (AMD/Intel 64)
Red Hat Enterprise Linux(R) 5 (AMD/Intel 64)
Red Hat Enterprise Linux 6 (32-bit x86)Linux 6 (32-bit x86)Linux 6
Red Hat Enterprise Linux 6 (64-bit x86_64)Linux 6 (64-bit x86_64)
turbolinux 7 Server for AP8000Linux for AP8000
Microsoft(R) Windows NT(R) Workstation Operating System Version 4.0Windows NT
Microsoft(R) Windows NT(R) Server Network Operating System Version 4.0
Microsoft(R) Windows Server(R) 2003, Standard EditionWindows Server 2003 Standard EditionWindows Server 2003
Microsoft(R) Windows Server(R) 2003, Enterprise EditionWindows Server 2003 Enterprise Edition
Microsoft(R) Windows Server(R) 2003, Standard x64 EditionWindows Server 2003 Standard x64 Edition
Microsoft(R) Windows Server(R) 2003, Enterprise x64 EditionWindows Server 2003 Enterprise x64 Edition
Microsoft(R) Windows Server(R) 2003 R2, Standard EditionWindows Server 2003 R2
Microsoft(R) Windows Server(R) 2003 R2, Enterprise Edition
Microsoft(R) Windows Server(R) 2003 R2, Standard x64 Edition
Microsoft(R) Windows Server(R) 2003 R2, Enterprise x64 Edition
Microsoft(R) Windows Server(R) 2003 R2, Standard x64 EditionWindows Server 2003 R2 x64 Editions
Microsoft(R) Windows Server(R) 2003 R2, Enterprise x64 Edition
Microsoft(R) Windows Server(R) 2003, Enterprise Edition (64-bit version)Windows Server 2003 (IPF)
Microsoft(R) Windows Server(R) 2008 StandardWindows Server 2008 StandardWindows Server 2008
Microsoft(R) Windows Server(R) 2008 EnterpriseWindows Server 2008 Enterprise
Microsoft(R) Windows Server(R) 2008 R2 Standard (x64)Windows Server 2008 R2
Microsoft(R) Windows Server(R) 2008 R2 Enterprise (x64)
Microsoft(R) Windows Server(R) 2008 R2 Datacenter (x64)
Microsoft(R) Windows Server(R) 2008 Standard (x64)Windows Server 2008 (x64)
Microsoft(R) Windows Server(R) 2008 Enterprise (x64)
Microsoft(R) Windows Server(R) 2003, Standard x64 EditionWindows Server 2003 x64 EditionsWindows (x64)
Microsoft(R) Windows Server(R) 2003, Enterprise x64 Edition
Microsoft(R) Windows Server(R) 2003 R2, Standard x64 Edition
Microsoft(R) Windows Server(R) 2003 R2, Enterprise x64 Edition
Microsoft(R) Windows(R) XP Professional x64 EditionWindows XP x64 Edition
Microsoft(R) Windows Server(R) 2003, Enterprise Edition (64-bit version)Windows Server 2003 (IPF)Windows(IPF)
Microsoft(R) Windows(R) XP Professional x64 EditionWindows XP x64 EditionWindows XP
Microsoft(R) Windows(R) XP Professional Operating SystemWindows XP Professional
Microsoft(R) Windows(R) XP Home Edition Operating SystemWindows XP Home Edition
Microsoft(R) Windows Vista(R) Home BasicWindows Vista Home BasicWindows Vista
Microsoft(R) Windows Vista(R) Home PremiumWindows Vista Home Premium
Microsoft(R) Windows Vista(R) UltimateWindows Vista Ultimate
Microsoft(R) Windows Vista(R) BusinessWindows Vista Business
Microsoft(R) Windows Vista(R) EnterpriseWindows Vista Enterprise
Microsoft(R) Windows Vista(R) Home Basic (x64)Windows Vista (x64)
Microsoft(R) Windows Vista(R) Home Premium (x64)
Microsoft(R) Windows Vista(R) Ultimate (x64)
Microsoft(R) Windows Vista(R) Business (x64)
Microsoft(R) Windows Vista(R) Enterprise (x64)
Microsoft(R) Windows(R) 7 Home PremiumWindows 7 Home BasicWindows 7
Microsoft(R) Windows(R) 7 ProfessionalWindows 7 Professional
Microsoft(R) Windows(R) 7 EnterpriseWindows 7 Enterprise
Microsoft(R) Windows(R) 7 UltimateWindows 7 Ultimate
Microsoft(R) Windows(R) 7 Home Premium (x64)Windows 7 (x64)
Microsoft(R) Windows(R) 7 Professional (x64)
Microsoft(R) Windows(R) 7 Enterprise (x64)
Microsoft(R) Windows(R) 7 Ultimate (x64)

This manual also uses the following acronyms:

AcronymFull name or meaning
ACKAcknowledgement
ADMAdaptable Data Manager
ADOActiveX Data Objects
ADTAbstract Data Type
APApplication Program
APIApplication Programming Interface
ASN.1Abstract Syntax Notation One
BESBack End Server
BLOBBinary Large Object
BMPBasic Multilingual Plane
BOMByte Order Mark
CD-ROMCompact Disc - Read Only Memory
CGICommon Gateway Interface
CLOBCharacter Large Object
CMTCassette Magnetic Tape
COBOLCommon Business Oriented Language
CORBA(R)Common ORB Architecture
CPUCentral Processing Unit
CSVComma Separated Values
DAOData Access Object
DATDigital Audio Tape
DBDatabase
DBMDatabase Module
DBMSDatabase Management System
DDLData Definition Language
DF for Windows NTDistributing Facility for Windows NT
DF/UXDistributing Facility/for UNIX
DICDictionary Server
DLTDigital Linear Tape
DMLData Manipulate Language
DNSDomain Name System
DOMDocument Object Model
DSDictionary Server
DTDDocument Type Definition
DTPDistributed Transaction Processing
DWHData Warehouse
EUCExtended UNIX Code
EXExclusive
FATFile Allocation Table
FDFloppy Disk
FESFront End Server
FQDNFully Qualified Domain Name
FTPFile Transfer Protocol
GUIGraphical User Interface
HBAHost Bus Adapter
HDHard Disk
HDPHitachi Dynamic Provisioning
HTMLHyper Text Markup Language
IDIdentification number
IPInternet Protocol
IPFItanium(R) Processor Family
JARJava Archive File
Java VMJava Virtual Machine
JDBCJava Database Connectivity
JDKJava Developer's Kit
JFSJournaled File System
JFS2Enhanced Journaled File System
JISJapanese Industrial Standard code
JP1Job Management Partner 1
JREJava Runtime Environment
JTAJava Transaction API
JTSJava Transaction Service
KEISKanji processing Extended Information System
LANLocal Area Network
LDAPLightweight Directory Access Protocol
LIPLoop Initialization Process
LOBLarge Object
LRULeast Recently Used
LTOLinear Tape-Open
LULogical Unit
LUNLogical Unit Number
LVMLogical Volume Manager
MGRSystem Manager
MIBManagement Information Base
MRCFMultiple RAID Coupling Feature
MSCSMicrosoft Cluster Server
MSFCMicrosoft Failover Cluster
NAFONetwork Adapter Fail Over
NAPTNetwork Address Port Translation
NATNetwork Address Translation
NICNetwork Interface Card
NISNetwork Information Service
NTFSNew Technology File System
ODBCOpen Database Connectivity
OLAPOnline Analytical Processing
OLEObject Linking and Embedding
OLTPOn-Line Transaction Processing
OOCOBOLObject Oriented COBOL
ORBObject Request Broker
OSOperating System
OSIOpen Systems Interconnection
OTSObject Transaction Service
PCPersonal Computer
PDM II E2Practical Data Manager II Extended Version 2
PICPlug-in Code
PNMPublic Network Management
POSIXPortable Operating System Interface for UNIX
PPProgram Product
PRProtected Retrieve
PUProtected Update
RAIDRedundant Arrays of Inexpensive Disk
RDRelational Database
RDBRelational Database
RDB1Relational Database Manager 1
RDB1 E2Relational Database Manager 1 Extended Version 2
RDORemote Data Objects
RiSeReal time SAN replication
RMResource Manager
RMMResource Manager Monitor
RPCRemote Procedure Call
SAXSimple API for XML
SDSSingle Database Server
SGMLStandard Generalized Markup Language
SJISShift JIS
SNMPSimple Network Management Protocol
SNTPSimple Network Time Protocol
SQLStructured Query Language
SQL/KStructured Query Language / VOS K`
SRShared Retrieve
SUShared Update
TCP/IPTransmission Control Protocol / Internet Protocol
TMTransaction Manager
TMS-4V/SPTransaction Management System - 4V / System Product
UAPUser Application Program
UOCUser Own Coding
VOS KVirtual-storage Operating System Kindness
VOS1Virtual-storage Operating System 1
VOS3Virtual-storage Operating System 3
WSWorkstation
WWWWorld Wide Web
XDM/BASE E2Extensible Data Manager / Base Extended Version 2
XDM/DFExtensible Data Manager / Distributing Facility
XDM/DSExtensible Data Manager / Data Spreader
XDM/RD E2Extensible Data Manager / Relational Database Extended Version 2
XDM/SD E2Extensible Data Manager / Structured Database Extended Version 2
XDM/XTExtensible Data Manager / Data Extract
XDSExtended Data Server
XFITExtended File Transmission program
XMLExtensible Markup Language

Log representations

The application log that is displayed by Windows Event Viewer is referred to as the event log. The following procedure is used to view the event log.

To view the event log:
1. Choose Start, Programs, Administrative Tools (Common), and then Event Viewer.
2. Choose Log, and then Application.
The application log is displayed. Messages with HiRDBSingleServer or HiRDBParallelServer displayed in the Source column were issued by HiRDB.
If you specified a setup identifier when you installed HiRDB, the specified setup identifier follows HiRDBSingleServer or HiRDBParallelServer.

Conventions: Diagrams

This manual uses the following conventions in diagrams:

[Figure]

Conventions: Fonts and symbols

The following table explains the fonts used in this manual:

FontConvention
BoldBold type indicates text on a window, other than the window title. Such text includes menus, menu options, buttons, radio box options, or explanatory labels. For example:
  • From the File menu, choose Open.
  • Click the Cancel button.
  • In the Enter name entry box, type your name.
ItalicsItalics are used to indicate a placeholder for some actual text to be provided by the user or system. For example:
  • Write the command as follows:
    copy source-file target-file
  • The following message appears:
    A file was not found. (file = file-name)
Italics are also used for emphasis. For example:
  • Do not delete the configuration file.
Code fontA code font indicates text that the user enters without change, or text (such as messages) output by the system. For example:
  • At the prompt, enter dir.
  • Use the send command to send mail.
  • The following message is displayed:
    The password is incorrect.

The following table explains the symbols used in this manual:

SymbolConvention
|In syntax explanations, a vertical bar separates multiple items, and has the meaning of OR. For example:
A|B|C means A, or B, or C.
[ ]In syntax explanations, square brackets indicate that the enclosed item or items are optional. For example:
[A] means that you can specify A or nothing.
[B|C] means that you can specify B, or C, or nothing.
...In coding, an ellipsis (...) indicates that one or more lines of coding are not shown for purposes of brevity.
In syntax explanations, an ellipsis indicates that the immediately preceding item can be repeated as many times as necessary. For example:
A, B, B, ... means that, after you specify A, B, you can specify B as many times as necessary.
()Parentheses indicate the range of items to which the vertical bar (|) or ellipsis (...) is applicable.

The following notations are used in formulas:

NotationExplanation
[Figure][Figure]Round up the result to the next integer.
Example: The result of [Figure]34 [Figure] 3[Figure] is 12.
[Figure][Figure]Discard digits following the decimal point.
Example: The result of [Figure]34 [Figure] 3[Figure] is 11.
MAXSelect the largest value as the result.
Example: The result of MAX(3 x 6, 4 + 7) is 18.
MINSelect the smallest value as the result.
Example: The result of MIN(3 x 6, 4 + 7) is 11.
modmod(a, b) indicates the remainder of a divided by b.
Example: The result of MOD(9, 2) is 1.

Notes on Windows path names

Example: C:\win32app\hitachi\hirdb_s\spool\tmp

Example: pdinit -d "C:\Program Files(x86)\hitachi\hirdb_s\conf\mkinit"

However, double quotation marks are not necessary when you use the set command in a batch file or at the command prompt to set an environment variable or when you specify the installation directory. If you do use double quotation marks in such a case, the double quotation marks become part of the value assigned to the environment variable.

Example: set PDCLTPATH=C:\Program Files\hitachi\hirdb_s\spool

Conventions: KB, MB, GB, and TB

This manual uses the following conventions:

Conventions: Version numbers

The version numbers of Hitachi program products are usually written as two sets of two digits each, separated by a hyphen. For example:

The version number might be shown on the spine of a manual as Ver. 2.00, but the same version number would be written in the program as 02-00.

Important notes on this manual

The following facilities are explained, but they are not supported:

The following products and option program products are explained, but they are not supported: