Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

Preface

This manual describes the syntax of the commands used with HiRDB Scalable Database Server HiRDB Version 8.

Intended readers

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

It is assumed that readers of this manual have the following:

The following manuals should be read before reading this manual:

Organization of this manual

This manual consists of the following 18 chapters and appendixes:

Chapter 1. Overview of Commands
Chapter 1 explains the methods of entering commands and the descriptive format for commands.

Chapter 2. Operation Commands
Chapter 2 explains the operation commands that can be used with HiRDB.

Chapter 3. Database Initialization Utility (pdinit)
Chapter 3 describes the database initialization utility that defines a physical structure that, in turn, permits files to be used as a HiRDB database.

Chapter 4. Database Definition Utility (pddef)
Chapter 4 describes the database definition utility that permits modifications of schema definitions and contents.

Chapter 5. Database Load Utility (pdload)
Chapter 5 describes the database load utility that stores user-provided data in a table.

Chapter 6. Interactive SQL Execution Utility
Chapter 6 explains the interactive SQL execution utility that can interactively execute SQL statements.

Chapter 7. Database Structure Modification Utility (pdmod)
Chapter 7 explains the database structure modification utility that can modify the physical structure of a database, such as by adding an RDAREA, expanding the database, or reinitializing the database.

Chapter 8. Database Reorganization Utility (pdrorg)
Chapter 8 explains the database reorganization utility for maintaining tables and indexes.

Chapter 9. Dictionary Import/Export Utility (pdexp)
Chapter 9 explains the dictionary import/export utility that migrates table definition information and stored procedure information between HiRDB systems.

Chapter 10. Rebalancing Utility (pdrbal)
Chapter 10 explains the rebalancing utility that rebalances a table partitioned by the hash partitioning method.

Chapter 11. Free Page Release Utility (pdreclaim)
Chapter 11 explains the free page release utility that enables you to release free pages (used free pages) during online operation.

Chapter 12. Global Buffer Residence Utility (pdpgbfon)
Chapter 12 explains the global buffer residence utility that reads table data pages and index pages into a global buffer in advance, such as immediately following HiRDB startup or before starting online jobs.

Chapter 13. Integrity Check Utility (pdconstck)
Chapter 13 explains the integrity check utility (pdconstck), which performs integrity checking and manipulates (sets or releases) the check pending status on tables for which referential constraints or check constraints have been defined.

Chapter 14. Statistics Analysis Utility (pdstedit)
Chapter 14 explains the statistics analysis utility that edits statistical information, such as information about HiRDB system activities.

Chapter 15. Database Condition Analysis Utility (pddbst)
Chapter 15 explains the database condition analysis utility, which analyzes the relationship between data dictionary tables or user RDAREAs and the storage status of the index, and summarizes and displays the results of the analysis.

Chapter 16. Optimizing Information Collection Utility (pdgetcst)
Chapter 16 explains the optimizing information collection utility, which collects information for optimizing based on cost and stores the information in the dictionary table.

Chapter 17. Access Path Display Utility (pdvwopt)
Chapter 17 explains the access path display utility, which displays access path information that was determined by the SQL optimization processing.

Chapter 18. Database Copy Utility (pdcopy)
Chapter 18 explains how to use the database copy utility (pdcopy), which makes a backup of a database.

Chapter 19. Database Recovery Utility (pdrstr)
Chapter 19 explains how to use the database recovery utility, which is used to recover databases and re-create log point information files.

Chapter 20. Registry Facility Initialization Utility (pdreginit)
Chapter 20 explains the registry facility initialization utility, which can be used to register the registry facility for using plug-in utilities.

Appendix A. List of Commands
Appendix A provides a list of operation commands and utilities.

Appendix B. Lock Mode During Command Execution
Appendix B describes the resources that are locked while an operation command or utility is executing.

Appendix C. RDAREA Status During Command Execution
Appendix C describes the RDAREA statuses during execution of commands.

Appendix D. Maximum Number of Concurrently Executable Utilities
Appendix D describes the maximum number of utilities that can be executed concurrently.

Appendix E. Creation of a UOC for Use by pdload and pdrorg
Appendix E explains the creation of a UOC for use by pdload and pdrorg.

Appendix F. Number of Concurrent Command Connections
Appendix F explains the number of concurrent command connections.

Appendix G. List of Command Return Codes
Appendix G explains the return codes from commands.

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)

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

You must use the UNIX or the Windows manuals, as appropriate to the platform you are using.

Others

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]

Conventions: Abbreviations

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

Name of product or other entity Representation
HiRDB/Single Server Version 8 HiRDB/Single Server HiRDB or HiRDB Server
HiRDB/Single Server Version 8(64)
HiRDB/Parallel Server Version 8 HiRDB/Parallel Server
HiRDB/Parallel Server Version 8(64)
HiRDB/Developer's Kit Version 8 HiRDB/Developer's Kit HiRDB Client
HiRDB/Developer's Kit Version 8(64)
HiRDB/Run Time Version 8 HiRDB/Run Time
HiRDB/Run Time Version 8(64)
HiRDB Datareplicator Version 7 HiRDB Datareplicator
HiRDB Dataextractor Version 7 HiRDB Dataextractor
HiRDB Text Search Plug-in Version 7 HiRDB Text Search Plug-in
HiRDB Spatial Search Plug-in Version 3 HiRDB Spatial Search Plug-in
HiRDB Staticizer Option Version 8 HiRDB Staticizer Option
HiRDB LDAP Option Version 8 HiRDB LDAP Option
HiRDB Advanced Partitioning Option Version 8 HiRDB Advanced Partitioning Option
HiRDB Advanced High Availability Version 8 HiRDB Advanced High Availability
HiRDB Non Recover Front End Server Version 8 HiRDB Non Recover FES
HiRDB Disaster Recovery Light Edition Version 8 HiRDB Disaster Recovery Light Edition
HiRDB External Data Access Version 8 HiRDB External Data Access
HiRDB External Data Access Adapter Version 8 HiRDB External Data Access Adapter
HiRDB Adapter for XML - Standard Edition HiRDB Adapter for XML
HiRDB Adapter for XML - Enterprise Edition
HiRDB Control Manager HiRDB CM
HiRDB Control Manager Agent HiRDB CM Agent
Hitachi TrueCopy TrueCopy
Hitachi TrueCopy basic
TrueCopy
TrueCopy remote replicator
JP1/Automatic Job Management System 2 JP1/AJS2
JP1/Automatic Job Management System 2 - Scenario Operation JP1/AJS2-SO
JP1/Cm2/Extensible SNMP Agent JP1/ESA
JP1/Cm2/Extensible SNMP Agent for Mib Runtime
JP1/Cm2/Network Node Manager JP1/NNM
JP1/Integrated Management - Manager JP1/Integrated Management or JP1/IM
JP1/Integrated Management - View
JP1/Magnetic Tape Access EasyMT
EasyMT
JP1/Magnetic Tape Library MTguide
JP1/NETM/DM JP1/NETM/DM
JP1/NETM/DM Manager
JP1/Performance Management JP1/PFM
JP1/Performance Management Agent for HiRDB JP1/PFM-Agent for HiRDB
JP1/Performance Management - Agent for Platform JP1/PFM-Agent for Platform
JP1/Performance Management/SNMP System Observer JP1/SSO
JP1/VERITAS NetBackup BS v4.5 NetBackup
JP1/VERITAS NetBackup v4.5
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
OpenTP1/Server Base Enterprise Option TP1/EE
Virtual-storage Operating System 3/Forefront System Product VOS3/FS VOS3
Virtual-storage Operating System 3/Leading System Product VOS3/LS
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 control XDM/DCCM3
XDM/DCCM3
XDM/Relational Database XDM/RD XDM/RD XDM/RD
XDM/Relational Database Extended Version 2
XDM/RD E2
XDM/RD E2
VOS3 Database Connection Server DB Connection Server
DB2 Universal Database for OS/390 Version 6 DB2
DNCWARE ClusterPerfect (Linux Version) ClusterPerfect
Microsoft(R) Excel Microsoft Excel or Excel
Microsoft(R) Visual C++(R) Visual C++ or C++
Oracle 8i ORACLE
Oracle 9i
Oracle 10g
Sun JavaTM System Directory Server Sun Java System Directory Server or Directory Server
HP-UX 11i V2 (IPF) HP-UX or HP-UX (IPF)
Red Hat Linux Linux
Red Hat Enterprise Linux
Red Hat Enterprise Linux AS 3 (IPF) Linux (IPF) Linux
Red Hat Enterprise Linux AS 4 (IPF)
Red Hat Enterprise Linux AS 3(AMD64 & Intel EM64T) Linux (EM64T)
Red Hat Enterprise Linux AS 4(AMD64 & Intel EM64T)
Red Hat Enterprise Linux ES 4(AMD64 & Intel EM64T)
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
Microsoft(R) Windows(R) 2000 Professional Operating System Windows 2000
Microsoft(R) Windows(R) 2000 Server Operating System
Microsoft(R) Windows(R) 2000 Datacenter Server Operating System
Microsoft(R) Windows(R) 2000 Advanced Server Operating System Windows 2000 or Windows 2000 Advanced Server
Microsoft(R) Windows ServerTM 2003, Standard Edition Windows Server 2003
Microsoft(R) Windows ServerTM 2003, Enterprise Edition
Microsoft(R) Windows ServerTM 2003 R2, Standard Edition Windows Server 2003 R2 or Windows Server 2003
Microsoft(R) Windows ServerTM 2003 R2, Enterprise Edition
64 bit Version Microsoft(R) Windows ServerTM 2003, Enterprise Edition (IPF) Windows Server 2003 (IPF) or Windows Server 2003
Microsoft(R) Windows ServerTM 2003, Standard x64 Edition Windows Server 2003 or Windows Server 2003 x64 Editions Windows (x64)
Microsoft(R) Windows ServerTM 2003, Enterprise x64 Edition
Microsoft(R) Windows ServerTM 2003 R2, Standard x64 Edition Windows Server 2003, Windows Server 2003 R2 or Windows Server 2003 x64 Editions
Microsoft(R) Windows ServerTM 2003 R2, Enterprise x64 Edition
Microsoft(R) Windows(R) XP Professional x64 Edition Windows XP or Windows XP x64 Edition
Microsoft(R) Windows(R) XP Professional Operating System Windows XP Professional Windows XP
Microsoft(R) Windows(R) XP Home Edition Operating System Windows XP Home Edition
Single server SDS
System manager MGR
Front-end server FES
Dictionary server DS
Back-end server BES

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
BOM Byte Order Mark
CD-ROM Compact Disc - Read Only Memory
CGI Common Gateway Interface
CLOB Character Large Object
CMT Cassette Magnetic Tape
COBOL Common Business Oriented Language
CORBA(R) Common ORB Architecture
CPU Central Processing Unit
CSV Comma Separated Values
DAO Data Access Object
DAT Digital Audio Taperecorder
DB Database
DBM Database Module
DBMS Database Management System
DDL Data Definition Language
DF for Windows NT Distributing Facility for Windows NT
DF/UX Distributing Facility/for UNIX
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
HBA Host Bus Adapter
HD Hard Disk
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
LDAP Lightweight Directory Access Protocol
LIP loop initialization process
LOB Large Object
LRU Least Recently Used
LTO Linear Tape-Open
LU Logical Unit
LUN Logical Unit Number
LVM Logical Volume Manager
MGR System Manager
MIB Management Information Base
MRCF Multiple RAID Coupling Feature
MSCS Microsoft Cluster Server
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
OLAP Online Analytical Processing
OLE Object Linking and Embedding
OLTP On-Line Transaction Processing
OOCOBOL Object Oriented COBOL
ORB Object Request Broker
OS Operating System
OSI Open Systems Interconnection
OTS Object Transaction Service
PC Personal Computer
PDM II E2 Practical Data Manager II Extended Version 2
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
RDB1 Relational Database Manager 1
RDB1 E2 Relational Database Manager 1 Extended Version 2
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
SQL Structured Query Language
SQL/K Structured Query Language / VOS K
SR Shared Retrieve
SU Shared Update
TCP/IP Transmission Control Protocol / Internet Protocol
TM Transaction Manager
TMS-4V/SP Transaction Management System - 4V / System Product
UAP User Application Program
UOC User Own Coding
VOS K Virtual-storage Operating System Kindness
VOS1 Virtual-storage Operating System 1
VOS3 Virtual-storage Operating System 3
WS Workstation
WWW World Wide Web
XDM/BASE E2 Extensible Data Manager / Base Extended Version 2
XDM/DF Extensible Data Manager / Distributing Facility
XDM/DS Extensible Data Manager / Data Spreader
XDM/RD E2 Extensible Data Manager / Relational Database Extended Version 2
XDM/SD E2 Extensible Data Manager / Structured Database Extended Version 2
XDM/XT Extensible Data Manager / Data Extract
XFIT Extended File Transmission program
XML Extensible 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.
3. 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

Font and symbol conventions are classified as:

These conventions are described below.

General font conventions

The following table lists the general font conventions:

Font Convention
Bold Bold 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, bold is used in sentences such as the following:
  • From the File menu, choose Open.
  • Click the Cancel button.
  • In the Enter name entry box, type your name.
Italics Italics are used to indicate a placeholder for some actual text provided by the user or system. Italics are also used for emphasis. For example:
  • Write the command as follows:
    copy source-file target-file
  • Do not delete the configuration file.
Code font A 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.

Examples of coding and messages appear as follows (although there may be some exceptions, such as when coding is included in a diagram):

MakeDatabase
...
StoreDatabase temp DB32

In examples of coding, an ellipsis (...) indicates that one or more lines of coding are not shown for purposes of brevity.

Conventions in syntax explanations

Syntax definitions appear as follows:

StoreDatabase [temp|perm] (database-name ...)

The following table lists the conventions used in syntax explanations. The syntactical characters described below are used to provide a clear explanation of code syntax; you do not actually enter these characters.

Example font or symbol Convention
StoreDatabase Code-font characters must be entered exactly as shown.
database-name This font style marks a placeholder that indicates where appropriate characters are to be entered in an actual command.
SD Bold code-font characters indicate the abbreviation for a command.
perm Underlined characters indicate the default value.
[ ] Square brackets enclose an item or set of items whose specification is optional.
| Only one of the options separated by a vertical bar can be specified at the same time.
... An ellipsis (...) indicates that the item or items enclosed in ( ) or [ ] immediately preceding the ellipsis may be specified as many times as necessary.
() Parentheses indicate the range of items to which the vertical bar (|) or ellipsis (...) is applicable.
[Figure] The user-specified value preceding the swung dash must be specified in accordance with the attributes following the swung dash.
<< >> Double angle brackets enclose the default value assumed by the system when the specification is omitted.
< > Angle brackets enclose the syntax element notation for a user-specified value.
(( )) Double parentheses enclose the permitted range of values that can be specified.

Syntax element notations

Syntax element notations explain the types of user-specified values.

Syntax element notation Explanation
<alphabetic> Alphabetic characters (A-Z, a-z) and _ (underline)
<alphabetic symbol> Alphabetic characters (A-Z, a-z), #, @, \
<alphanumeric> Alphabetic characters and numeric characters (0-9)
<alphanumeric symbol> Alphabetic symbols and numeric characters
<unsigned integer> Numeric characters
<hexadecimal> Numeric characters and (A-F, a-f)
<identifier>1 Alphanumeric character string beginning with an alphabetic character
<symbolic name> Alphanumeric symbol string beginning with an alphabetic symbol
<character string> String of any characters
<path name>2, 3 Includes symbolic names, backslashes (\), periods (.), spaces, and parentheses.
<HiRDB file name> Character string consisting of alphabetic characters (A-Z, a-z), numeric characters (0-9), . (period), _ (underline), and @ (maximum 30 characters)

Note
Alphabetic characters are case sensitive (i.e., lowercase alphabetic characters are distinguished from uppercase alphabetic characters).

1 An RDAREA name is an alphanumeric character string beginning with an alphabetic character or special character, and can include alphanumeric characters, underscores (_), and spaces. If an RDAREA name includes a space, the entire name must be enclosed in double quotation marks (").
A host name is a character string that can include alphabetic characters (A to Z, a to z), numeric characters, periods (.), hyphens (-), and underscores (_). A host name can begin with a numeric character.

2 Path names depend on the operating system being used. The backslash (\) must not be used in a HiRDB file system area name.

3 If a path name includes any spaces or parentheses, the entire path name must be enclosed in double quotation marks (").

Notations used in formulas

The following notations are used in computational expressions:

Notation Explanation
[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.
MAX Select the largest value as the result.
Example: The result of max(10, 2 [Figure] 4, 3 + 8) is 11.
MIN Select the smallest value as the result.
Example: The result of min(10, 2 [Figure] 4, 3 + 8) is 8.

Conventions in command explanations

This manual explains each command in the format shown as follows; note that this format may differ slightly from one command to another:

[Figure]

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:

Notes on printed manuals

Please note that even though the printed manuals are separated into Part I and Part II, the chapters and page numbers sequentially continue from Part I to Part II. Also, please note that the index is only included in Part II.