Preface

This manual is intended for users who will be constructing or operating HiRDB Version 9 ("HiRDB") relational database systems.

Readers of this manual must have the following:

A basic knowledge of managing Windows
A basic knowledge of SQL

This manual is based on the following manuals, which we recommend that you read before reading this one:

HiRDB Version 9 Installation and Design Guide
HiRDB Version 9 System Operation Guide

This manual is organized into the following chapters:

1. Overview: Chapter 1 explains the organization and syntax rules of the HiRDB system definitions. This chapter also provides a list of the operands.

2. System Common Definition: Chapter 2 explains the system common definition.

3. Unit Control Information Definition: Chapter 3 explains the unit control information definition.

4. Server Common Definition: Chapter 4 explains the server common definition.

5. Single Server Definition: Chapter 5 explains the single server definition.

6. Front-End Server Definition: Chapter 6 explains the front-end server definition.

7. Dictionary Server Definition: Chapter 7 explains the dictionary server definition.

8. Back-End Server Definition: Chapter 8 explains the back-end server definition.

9. UAP Environment Definition: Chapter 9 explains the UAP environment definition.

A. Operand Specification Values: Appendix A explains the information to be specified in operands (arranged by types of operands).

B. Examples of Definitions: Appendix B provides examples of HiRDB system definitions.

C. Formulas for Determining Operand Specification Values: Appendix C provides and explains formulas that can be used to determine operand specification values.

D. Determining the Number of Locked Resources: Appendix D provides and explains formulas that can be used to determine the numbers of locked resources.

E. Operands Checked by the pdconfchk Command: Appendix E provides a list of operands that can be checked by executing the pdconfchk command.

F. List of Operands That Can Be Specified When Using the Standby-less System Switchover (Effects Distributed) Facility (Unit Control Information Definition): Appendix F lists the operands that can be specified in the unit control information definition for the standby-less system switchover (effects distributed) facility.

This manual is part of a related set of manuals. The manuals in the set are listed below (with the manual numbers):

HiRDB (for Windows)

HiRDB Version 9 System Description (3020-6-451(E)), for Windows systems
HiRDB Version 9 Installation and Design Guide (3020-6-452(E)), for Windows systems
HiRDB Version 9 System Operation Guide (3020-6-454(E)), for Windows systems
HiRDB Version 9 Command Reference (3020-6-455(E)), for Windows systems
HiRDB Version 8 Batch Job Accelerator (3020-6-368)^#

HiRDB (for UNIX)

HiRDB Version 9 Description (3000-6-451(E)), for UNIX systems
HiRDB Version 9 Installation and Design Guide (3000-6-452(E)), for UNIX systems
HiRDB Version 9 System Definition (3000-6-453(E)), for UNIX systems
HiRDB Version 9 System Operation Guide (3000-6-454(E)), for UNIX systems
HiRDB Version 9 Command Reference (3000-6-455(E)), for UNIX systems
HiRDB Version 9 Staticizer Option Description and User's Guide (3000-6-463), for UNIX systems^#
HiRDB Version 9 Disaster Recovery System Configuration and Operation Guide (3000-6-464(E)), for UNIX systems
HiRDB Version 9 Batch Job Accelerator (3020-6-468)^#
HiRDB Version 9 Memory Database Installation and Operation Guide (3020-6-469), for UNIX systems^#1

HiRDB (for both Windows and UNIX)

HiRDB Version 9 UAP Development Guide (3020-6-456(E))
HiRDB Version 9 SQL Reference (3020-6-457(E))
HiRDB Version 9 Messages (3020-6-458(E))
HiRDB Version 9 XDM/RD E2 Connection Facility (3020-6-465)^#
HiRDB Version 9 XML Extension (3020-6-480)^#
HiRDB Version 9 Text Search Plug-in (3020-6-481)^#
HiRDB Version 8 Security Guide (3020-6-359)^#
HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide (3020-6-360(E))
HiRDB Datareplicator Extension Version 8 (3020-6-361)^#
HiRDB Dataextractor Version 8 Description, User's Guide and Operator's Guide (3020-6-362(E))

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.

Others

Hitachi HA Toolkit (3000-9-115)^#

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

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]

Unless otherwise required, this manual uses the following abbreviations for product and other names:

Full name or meaning	Abbreviation
HiRDB Server Version 9	HiRDB/Single Server	HiRDB or HiRDB Server
HiRDB Server Version 9	HiRDB/Parallel Server	HiRDB or HiRDB Server
HiRDB/Developer's Kit Version 9	HiRDB/Developer's Kit	HiRDB Client
HiRDB/Developer's Kit Version 9(64)	HiRDB/Developer's Kit
HiRDB/Run Time Version 9	HiRDB/Run Time
HiRDB/Run Time Version 9(64)	HiRDB/Run Time
HiRDB Accelerator Version 8	HiRDB Accelerator
HiRDB Accelerator Version 9	HiRDB Accelerator
HiRDB Adapter for XML - Standard Edition	HiRDB Adapter for XML
HiRDB Adapter for XML - Enterprise Edition	HiRDB Adapter for XML
HiRDB Advanced High Availability Version 9	HiRDB Advanced High Availability
HiRDB Control Manager	HiRDB CM
HiRDB Control Manager Agent	HiRDB CM Agent
HiRDB Dataextractor Version 8	HiRDB Dataextractor
HiRDB Datareplicator Version 8	HiRDB Datareplicator
HiRDB Disaster Recovery Light Edition Version 9	HiRDB Disaster Recovery Light Edition
HiRDB Non Recover Front End Server Version 9	HiRDB Non Recover FES
HiRDB Staticizer Option Version 9	HiRDB Staticizer Option
HiRDB Text Search Plug-in Version 9	HiRDB Text Search Plug-in
HiRDB XML Extension Version 9	HiRDB XML Extension
Single server	SDS
System manager	MGR
Front-end server	FES
Dictionary server	DS
Back-end server	BES
Microsoft^(R) ActiveX^(R)	ActiveX
^DNCWARE ClusterPerfect (Linux Edition)	ClusterPerfect
DataStage^(R)	DataStage
DB2 Universal Database for OS/390 Version 6	DB2
JP1/Magnetic Tape Access	EasyMT
EasyMT	EasyMT
JP1/Automatic Job Management System 2 - Scenario Operation	JP1/AJS2-SO
JP1/Automatic Job Management System 3	JP1/AJS3
JP1/Automatic Job Management System 2	JP1/AJS3
JP1/Cm2/Extensible SNMP Agent	JP1/ESA
JP1/Cm2/Extensible SNMP Agent for Mib Runtime	JP1/ESA
JP1/Integrated Management - Manager	JP1/Integrated Management or JP1/IM
JP1/Integrated Management - View	JP1/Integrated Management or JP1/IM
JP1/NETM/Audit - Manager	JP1/NETM/Audit
JP1/NETM/DM	JP1/NETM/DM
JP1/NETM/DM Manager	JP1/NETM/DM
JP1/Cm2/Network Node Manager	JP1/NNM
JP1/Performance Management	JP1/PFM
JP1/Performance Management - Agent Option for HiRDB	JP1/PFM-Agent for HiRDB
JP1/Performance Management - Agent Option for Platform	JP1/PFM-Agent for Platform
JP1/Performance Management/SNMP System Observer	JP1/SSO
JP1/VERITAS NetBackup BS V4.5 Agent for HiRDB License	JP1/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 Update1	LifeKeeper
MetaBroker^(R)	MetaBroker
MetaStage^(R)	MetaStage
Microsoft^(R) Office Excel	Microsoft Excel or Excel
JP1/Magnetic Tape Library	MTguide
JP1/VERITAS NetBackup BS v4.5	NetBackup
JP1/VERITAS NetBackup v4.5	NetBackup
PowerHA for AIX, V5.5	PowerHA
PowerHA SystemMirror V6.1	PowerHA
QualityStage(TM)	QualityStage
OpenTP1/Server Base Enterprise Option	TP1/EE
Hitachi TrueCopy	TrueCopy
Hitachi TrueCopy Asynchronous
Hitachi TrueCopy basic
Hitachi TrueCopy Software
TrueCopy
TrueCopy Asynchronous
TrueCopy remote replicator
Hitachi Universal Replicator Software	Universal Replicator
Universal Replicator	Universal Replicator
Microsoft^(R) Visual C++^(R)	Visual C++ or C++ language
Oracle WebLogic Server	WebLogic Server
Virtual-storage Operating System 3/Forefront System Product	VOS3/FS	VOS3
Virtual-storage Operating System 3/Leading System Product	VOS3/LS
Virtual-storage Operating System 3/Unific System Product	VOS3/US
VOS3 Database Connection Server	DB 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/RD	XDM/RD
XDM/Relational Database Extended Version 2 Relational Database System XDM/RD E2	XDM/RD E2	XDM/RD
HP-UX 11i V2 (IPF)	HP-UX or HP-UX (IPF)
HP-UX 11i V3 (IPF)	HP-UX or HP-UX (IPF)
AIX 5L V5.2	AIX 5L	AIX
AIX 5L V5.3	AIX 5L
AIX V6.1	AIX V6.1
AIX V7.1	AIX V7.1
Linux^(R)	Linux
Red Hat Enterprise Linux^(R) AS 4(AMD64 & Intel EM64T)	Linux AS 4	Linux
Red Hat Enterprise Linux^(R) AS 4(x86)	Linux AS 4
Red Hat Enterprise Linux^(R) ES 4(AMD64 & Intel EM64T)	Linux ES 4
Red Hat Enterprise Linux^(R) ES 4(x86)	Linux ES 4
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^(R) 6 (32-bit x86)	Linux 6
Red Hat Enterprise Linux^(R) 6 (64-bit x86_64)	Linux 6
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^(R) 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)	Linux 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)	Linux 5 (AMD/Intel 64)
Red Hat Enterprise Linux^(R) 6 (32-bit x86)	Linux 6 (32-bit x86)	Linux 6
Red Hat Enterprise Linux^(R) 6 (64-bit x86_64)	Linux 6 (64-bit x86_64)	Linux 6
turbolinux 7 Server for AP8000	Linux for AP8000
Microsoft^(R) Windows NT^(R) Workstation Operating System Version 4.0	Windows NT
Microsoft^(R) Windows NT^(R) Server Network Operating System Version 4.0	Windows NT
Microsoft^(R) Windows Server^(R) 2003, Standard Edition	Windows Server 2003 Standard Edition	Windows Server 2003
Microsoft^(R) Windows Server^(R) 2003, Enterprise Edition	Windows Server 2003 Enterprise Edition
Microsoft^(R) Windows Server^(R) 2003, Standard x64 Edition	Windows Server 2003 Standard x64 Edition
Microsoft^(R) Windows Server^(R) 2003, Enterprise x64 Edition	Windows Server 2003 Enterprise x64 Edition
Microsoft^(R) Windows Server^(R) 2003 R2, Standard Edition	Windows 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 Edition	Windows Server 2003 R2 x64 Editions
Microsoft^(R) Windows Server^(R) 2003 R2, Enterprise x64 Edition	Windows Server 2003 R2 x64 Editions
Microsoft^(R) Windows Server^(R) 2008 Standard	Windows Server 2008 Standard	Windows Server 2008
Microsoft^(R) Windows Server^(R) 2008 Enterprise	Windows 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)	Windows Server 2008 (x64)
Microsoft^(R) Windows Server^(R) 2012 Standard	Windows Server 2012
Microsoft^(R) Windows Server^(R) 2012 Datacenter	Windows Server 2012
Microsoft^(R) Windows Server^(R) 2003, Standard x64 Edition	Windows Server 2003 x64 Editions	Windows (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 Edition	Windows XP x64 Edition
Microsoft^(R) Windows Server^(R) 2003, Enterprise x64 Edition	Windows Server 2003 (IPF)	Windows(IPF)
Microsoft^(R) Windows^(R) XP Professional x64 Edition	Windows XP x64 Edition	Windows XP
Microsoft^(R) Windows^(R)XP Professional Operating System	WindowsXP Professional
Microsoft^(R) Windows^(R)XP Home Edition Operating System	Windows XP Home Edition
Microsoft^(R) Windows Vista^(R) Home Basic	Windows Vista Home Basic	Windows Vista
Microsoft^(R) Windows Vista^(R) Home Premium	Windows Vista Home Premium
Microsoft^(R) Windows Vista^(R) Ultimate	Windows Vista Ultimate
Microsoft^(R) Windows Vista^(R) Business	Windows Vista Business
Microsoft^(R) Windows Vista^(R) Enterprise	Windows 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 Vista^(R) Ultimate (x64)	Windows Vista Ultimate (x64)
Microsoft^(R) Windows Vista^(R) Business (x64)	Windows Vista Business (x64)
Microsoft^(R) Windows Vista^(R) Enterprise (x64)	Windows Vista Enterprise (x64)
Microsoft^(R) Windows^(R) 7 Home Premium	Windows 7 Home Premium	Windows 7
Microsoft^(R) Windows^(R) 7 Professional	Windows 7 Professional
Microsoft^(R) Windows^(R) 7 Enterprise	Windows 7 Enterprise
Microsoft^(R) Windows^(R) 7 Ultimate	Windows 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)
Microsoft^(R) Windows^(R) 7 Professional (x64)	Windows 7 Professional (x64)
Microsoft^(R) Windows^(R) 7 Enterprise (x64)	Windows 7 Enterprise (x64)
Microsoft^(R) Windows^(R) 7 Ultimate (x64)	Windows 7 Ultimate (x64)
Microsoft^(R) Windows^(R) 8 (Core Edition)	Windows 8 (Core Edition)	Windows 8
Microsoft^(R) Windows^(R) 8 Pro	Windows 8 Pro
Microsoft^(R) Windows^(R) 8 Enterprise	Windows 8 Enterprise
Microsoft^(R) Windows^(R) 8 (Core Edition) (x64)	Windows 8 (Core Edition) (x64)
Microsoft^(R) Windows^(R) 8 Pro (x64)	Windows 8 Pro (x64)
Microsoft^(R) Windows^(R) 8 Enterprise (x64)	Windows 8 Enterprise (x64)

Windows Server 2003, Windows Server 2008, and Windows Server 2012 are often referred to collectively as Windows Server. Windows XP, Windows Server, Windows Vista, Windows 7, and Windows 8 are often referred to collectively as Windows.
The HiRDB directory path is represented as %PDDIR%. The path of the Windows installation directory is represented as %windir%.
The hosts file means the hosts file stipulated by TCP/IP. As a rule, a reference to the hosts file means the %windir%\system32\drivers\etc\hosts file.

This manual also uses the following abbreviations:

Abbreviation	Full name or meaning
ACK	Acknowledgement
ADM	Adaptable Data Manager
ADO	ActiveX Data Objects
ADT	Abstract Data Type
AP	Application Program
API	Application Programming Interface
ASN.1	Abstract Syntax Notation One
BES	Back End Server
BLOB	Binary Large Object
BMP	Basic Multilingual Plane
BOM	Byte Order Mark
CD-ROM	Compact Disc - Read Only Memory
CLOB	Character Large Object
CMT	Cassette Magnetic Tape
COBOL	Common Business Oriented Language
CORBA	Common ORB Architecture
CPU	Central Processing Unit
CSV	Comma Separated Values
DAO	Data Access Object
DAT	Digital Audio Tape
DB	Database
DBMS	Database Management System
DDL	Data Definition Language
DIC	Dictionary Server
DLT	Digital Linear Tape
DML	Data Manipulate Language
DNS	Domain Name System
DOM	Document Object Model
DS	Dictionary Server
DTD	Document Type Definition
DTP	Distributed Transaction Processing
DWH	Data Warehouse
EUC	Extended UNIX Code
EX	Exclusive
FAT	File Allocation Table
FD	Floppy Disk
FES	Front End Server
FQDN	Fully Qualified Domain Name
FTP	File Transfer Protocol
GUI	Graphical User Interface
HD	Hard Disk
HDP	Hitachi Dynamic Provisioning
HTML	Hyper Text Markup Language
ID	Identification number
IP	Internet Protocol
IPF	Itanium^(R) Processor Family
JAR	Java Archive File
Java VM	Java Virtual Machine
JDBC	Java Database Connectivity
JDK	Java Developer's Kit
JFS	Journaled File System
JFS2	Enhanced Journaled File System
JIS	Japanese Industrial Standard code
JP1	Job Management Partner 1
JRE	Java Runtime Environment
JTA	Java Transaction API
JTS	Java Transaction Service
KEIS	Kanji processing Extended Information System
LAN	Local Area Network
LIP	Loop Initialization Process
LOB	Large Object
LRU	Least Recently Used
LTO	Linear Tape-Open
LU	Logical Unit
LVM	Logical Volume Manager
MGR	System Manager
MIB	Management Information Base
MRCF	Multiple RAID Coupling Feature
MSCS	Microsoft Cluster Server
MSFC	Microsoft Failover Cluster
NAFO	Network Adapter Fail Over
NAPT	Network Address Port Translation
NAT	Network Address Translation
NIC	Network Interface Card
NIS	Network Information Service
NTFS	New Technology File System
ODBC	Open Database Connectivity
OLE	Object Linking and Embedding
OLTP	On-Line Transaction Processing
OOCOBOL	Object Oriented COBOL
ORB	Object Request Broker
OS	Operating System
OTS	Object Transaction Service
PC	Personal Computer
PIC	Plug-in Code
PNM	Public Network Management
POSIX	Portable Operating System Interface for UNIX
PP	Program Product
PR	Protected Retrieve
PU	Protected Update
RAID	Redundant Arrays of Inexpensive Disk
RD	Relational Database
RDB	Relational Database
RDO	Remote Data Objects
RiSe	Real time SAN replication
RM	Resource Manager
RMM	Resource Manager Monitor
RPC	Remote Procedure Call
SAX	Simple API for XML
SDS	Single Database Server
SGML	Standard Generalized Markup Language
SJIS	Shift JIS
SNMP	Simple Network Management Protocol
SNTP	Simple Network Time Protocol
SR	Shared Retrieve
SU	Shared Update
TCP/IP	Transmission Control Protocol / Internet Protocol
TM	Transaction Manager
UAP	User Application Program
UOC	User Own Coding
VOS3	Virtual-storage Operating System 3
WS	Workstation
WWW	World Wide Web
XDM/BASE E2	Extensible Data Manager / Base Extended Version 2
XDM/DS	Extensible Data Manager / Data Spreader
XDM/RD E2	Extensible Data Manager / Relational Database Extended Version 2
XDM/XT	Extensible Data Manager / Data Extract
XDS	Extended Data Server
XML	Extensible Markup Language

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.

This manual uses the following conventions in diagrams:

[Figure]

The following table explains the text formatting conventions used in this manual:

Text formatting	Convention
Bold	Bold characters indicate text in 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.
Italic	Italic characters 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) Italic characters are also used for emphasis. For example: Do not delete the configuration file.
Monospace	Monospace characters indicate 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.

Text formatting

Convention

Bold

Bold characters indicate text in 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.

Italic

Italic characters 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)

Italic characters are also used for emphasis. For example:

Do not delete the configuration file.

Monospace

Monospace characters indicate 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:

Symbol	Convention
\|	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, curly brackets indicate that only one of the enclosed items is to be selected. For example: {A\|B\|C} means only one of 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 have been omitted. 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.
{{ }}	A double pair of curly brackets encloses multiple items, all of which you can specify multiple times as a unit. Example: {{pdbuffer -a option-name}} This example indicates that you can specify the above multiple times as follows: pdbuffer -a option-name pdbuffer -a option-name
~	A swung dash precedes the attributes of a user-specified value.
<< >>	A double pair of angle brackets encloses the default value assumed by the system when the specification is omitted.
< >	A single pair of angle brackets encloses the syntax element notation for a user-specified value.
(( ))	A double pair of parentheses encloses the permitted range of values that can be specified.
	Round up the result to the next integer. Example: The result of 34 3 will be 12.
	Discard digits following the decimal point. Example: The result of 34 3 will be 11.
MAX	Select the largest value as the result. Example: The result of MAX(3 6, 4 + 7) will be18.
MIN	Select the smallest value as the result. Example: The result of MIN(3 6, 4 + 7) will be 11.

Syntax element conventions

The following table explains the syntactical element symbols used in this manual:

Syntactical element symbol	Meaning
<alphabetics>	The alphabetic characters (A to Z and a to z) and the underscore (_)
<alphabetics and special characters>	The alphabetic characters (A to Z and a to z) and the special characters #, @, and \
<alphanumerics>	Alphabetic characters and the numeric digits (0 to 9)
<alphanumerics and special characters>	Alphabetic characters, special characters, and numeric digits
<unsigned integer>	Numeric value
<unsigned decimal>^#1	Numeric value (0 to 9), period (.), numeric value (0 to 9)
<hexadecimal>	Numeric digits and A to F (or a to f)
<identifier>^#2	Alphanumeric character string beginning with an alphabetic character
<symbolic name>	Alphanumeric character string beginning with an alphabetic character or a special character
<character string>	Any string of characters
<path name>^#3	Backslash (\), alphanumeric characters, period (.), space, parentheses, hash mark (#), and at mark (@)
<host-name>^#4	Character string consisting of alphabetic characters (A to Z, a to z), numeric characters, period (.), hyphen (-), underscore (_), and at mark (@).

Note: All alphabetic characters must be single-byte characters. Alphabetic characters are case sensitive, but some names might not be case sensitive.

#1: If all the numeric characters preceding the period are zeros (0), the zeros preceding the period can be omitted. Similarly, if all the numeric characters following the period are zeros (0), the zeros following the period can be omitted.; Example 1: 0.008 .008; Example 2: 15.000 15

#2: Specifying an RDAREA name:; RDAREA names can include one or more alphanumeric and special characters, underscores (_), hyphens (-), and spaces. However, the first character must be an alphabetic or special character.; When an RDAREA name includes a space, the entire name must be enclosed in double quotation marks (").

#3: Path names depend on the OS being used. If you use a parenthesis or a space in a path name, you must enclose the entire path name in double quotation marks (").

#4: Use one of the following formats to specify a host name:; host-name; IP-address (xxx.xxx.xxx.xxx format); fully-qualified-domain-name (FQDN); However, do not use different formats to specify the same host. HiRDB regards host names specified in different formats as different hosts.; You can also specify loop-back addresses.; A host name must be registered before it can be specified in a system definition. For details, see Registering host names in the HiRDB Version 9 Installation and Design Guide.

This manual uses the following conventions:

1 KB (kilobyte) is 1,024 bytes.
1 MB (megabyte) is 1,024² bytes.
1 GB (gigabyte) is 1,024³ bytes.
1 TB (terabyte) is 1,024⁴ bytes.

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

Version 1.00 (or 1.0) is written as 01-00.
Version 2.05 is written as 02-05.
Version 2.50 (or 2.5) is written as 02-50.
Version 12.25 is written as 12-25.

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.

In this manual, the Windows terms directory and folder are both referred to as directory.
Include the drive name when you specify an absolute path name.

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

When you specify in a command argument, control statements file, or HiRDB system definition file a path name that includes a space or a parenthesis, you must enclose the entire path name in double quotation marks (").

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 enclosing double quotation marks become part of the value assigned to the environment variable.

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

HiRDB cannot use files on a networked drive, so you must install HiRDB and configure the HiRDB environment on a local drive. Files used by utilities, such as utility input and output files, must also be on the local drive.
Do not use short path names (for example, do not use path names such as C:\PROGRA~1).

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

Distributed database facility
Server mode system switchover facility
User server hot standby
Rapid system switchover facility
Standby-less system switchover (1:1) facility
Standby-less system switchover (effects distributed) facility
HiRDB External Data Access facility
Inner replica facility
Updatable online reorganization
Sun Java System Directory Server linkage facility
Simple setup tool
Extended syslog facility
Rapid batch facility
Memory database facility
Linkage with JP1/NETM/Audit

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

HiRDB CM
HiRDB Disaster Recovery Light Edition
uCosminexus Grid Processing Server
HiRDB Text Search Plug-in
HiRDB XML Extension
TP1/Server Base
JP1/PFM-Agent Option for HiRDB
JP1/VERITAS NetBackup Agent for HiRDB License
XDM/RD
HiRDB SQL Tuning Advisor
COBOL2002