Scalable Database Server HiRDB Version 8

For Windows Systems

Scalable Database Server

HiRDB Version 8

Command Reference

3020-6-355(E)

Contents

Notices

Preface

1. Overview of Commands

1.1 Overview

1.2 List of operation commands

1.3 List of utilities

1.4 Utility I/O files

1.4.1 Files and volumes

1.4.2 File modes usable by utilities

1.4.3 Tape device access facility

1.5 Notes on command execution

1.5.1 Forced termination by interruption of command execution

1.5.2 Batch specification of RDAREA names in operation commands

1.5.3 Specifying the LANG environment variable

1.6 Functions that become available when optional HiRDB program products are installed

2. Operation Commands

pdacunlck (Release consecutive certification failure account lock state)

pdadmvr (Acquire HiRDB product information)

pdaudbegin (Start acquisition of audit trails)

pdaudend (Stop acquisition of audit trails)

pdaudrm (Delete audit trail files in shutdown status)

pdaudswap (Swap audit trail files)

pdbkupls (Display backup file information)

pdbufls (Display global buffer information)

pdbufmod (Change global buffer dynamically)

pdcancel (Forcibly terminate UAP or utility processing)

pdcat (Display messages in file)

pdcat [-d sts specified]

pdcat [-d option omitted]

pdchgconf (Reconfigure the system)

pdchprc (Change number of startup server processes)

pdclose (Close RDAREAs)

pdclttrc (Acquire SQL trace dynamically)

pdcmt (Commit transactions)

pdconfchk (Check system definitions)

pdcspool (Delete troubleshooting information)

pddbfrz (Place a full HiRDB file in a user LOB RDAREA in frozen update status)

pddbls (Display status of RDAREAs)

pddefrev (Generate definition SQL)

pdfbkup (Back up HiRDB file system)

pdffsck (Check and repair the integrity of a HiRDB file system area)

pdfgt (Terminate transaction forcibly)

pdfls (Display HiRDB file system area information)

pdfmkfs (Initialize HiRDB file system area)

pdfrm (Delete HiRDB file)

pdfrstr (Restore HiRDB file system)

pdfstatfs (Display status of HiRDB file system area)

pdgrprfl (Refresh user and role information)

pdhold (Shut down RDAREAs)

pdjarsync (Manipulate JAR files)

pdkill (Forcibly terminate a process)

pdlistls (Display list definition information)

pdlogadpf (Allocate log file)

pdlogatul (Control the automatic log unloading facility)

pdlogchg (Change status of log file)

pdlogcls (Close open log file)

pdloginit (Initialize log file)

pdlogls (Display log-related file information)

pdlogls [-d spd] (Display synchronization point dump file information)

pdlogls [-d sys] (Display system log file information)

pdlogopen (Open log file)

pdlogrm (Delete log file)

pdlogswap (Swap log files)

pdlogsync (Collect a synchronization point dump)

pdlogucat (Display unload log file information)

pdlogunld (Unload log file)

pdls (Display HiRDB system status)

pdls [-d act] (Display user status)

pdls [-d aud] (Display the status of audit trail files)

pdls [-d ha] (Display HiRDB system status)

pdls [-d lck] (Display server lock control status)

pdls [-d mem] (Display server shared memory status)

pdls [-d prc] (Display server process status)

pdls [-d rpc] (Display server communication control information)

pdls [-d rpl] (Display HiRDB Datareplicator linkage status)

pdls [-d scd] (Display server schedule status)

pdls [-d stj] (Display whether or not statistical data output type by unit and server is specified)

pdls [-d sts] (Display status file status)

pdls [-d svr] (Display status by unit and server)

pdls [-d trn] (Display server transaction status)

pdls [-d ust] (Display unit activity status)

pdntenv (Set up HiRDB operating environment)

pdobils (Display SQL object buffer statistics)

pdopen (Open RDAREAs)

pdpfresh (Refresh server process)

pdplgrgst (Register and delete plug-ins)

pdprgcopy (Copy a HiRDB update version)

pdprgrenew (Update a HiRDB update version)

pdrbk (Roll back transactions)

pdrdrefls (Display information about related RDAREAs)

pdrels (Release RDAREAs from shutdown status)

pdrplstart (Start HiRDB Datareplicator linkage)

pdrplstop (Stop HiRDB Datareplicator linkage)

pdstart (Start HiRDB system, unit, or server)

pdstbegin (Start output of statistical information)

pdstend (Stop output of statistical information)

pdstjswap (Swap statistics log files)

pdstjsync (Apply statistics log buffer to statistics log file)

pdstop (Terminate HiRDB system, unit, or server)

pdstscls (Close open status file)

pdstsinit (Initialize status file)

pdstsopen (Open status file)

pdstsrm (Delete status file)

pdstsswap (Swap status files)

pdsvhostname (Display server's host name)

pdtrndec (Settle unsettled transactions forcibly and automatically)

pdtrnqing (Start or release the transaction queuing facility)

pdusrchk (Check the Directory Server for user information)

pdvrup (Upgrade HiRDB version)

3. Database Initialization Utility (pdinit)

3.3 Control statement

3.3.1 define system statement

3.3.2 create rdarea statement

3.3.3 Notes

3.4 Rules and notes

3.5 Examples

4. Database Definition Utility (pddef)

4.3 Handling of continuation lines

4.4 Rules and notes

4.5 Examples

5. Database Load Utility (pdload)

5.1 Function

5.1.1 What is data loading?

5.1.2 Loading data to a table with LOB columns

5.1.3 Loading data to a table with abstract data type columns (LOB attribute) provided by a plug-in

5.1.4 Data loading with the synchronization point specification

5.1.5 RDAREAs containing a table subject to data loading

5.1.6 Log acquisition mode during execution of pdload

5.1.7 Executor

5.2 Typical examples of data loading

5.2.1 Loading data to a table with indexes defined

5.2.2 Loading data to a table with LOB columns

5.2.3 Loading data to a table with abstract data type columns provided by a plug-in

5.3 List of references by purpose

5.3.1 Required information

5.3.2 Information to be specified depending on the attribute of the table subject to data loading

5.3.3 Information to be specified depending on the type of input data file

5.3.4 Information to be specified depending on the data loading method

5.4 Command format

5.4.1 Format

5.4.2 Options

5.4.3 source statement (specification of input data file information)

5.4.4 index statement (specification of index information file information)

5.4.5 idxwork statement (specification of index information file directory)

5.4.6 sort statement (specification of sort work directory information)

5.4.7 lobdata statement (specification of LOB input file information)

5.4.8 lobcolumn statement (specification of LOB column input file information)

5.4.9 lobmid statement (specification of LOB middle file information)

5.4.10 srcuoc statement (specification of UOC storage library information)

5.4.11 array statement (specification of an array data format for a table containing repetition columns)

5.4.12 extdat statement (specification of information in the extended DAT format)

5.4.13 src_work statement (specification of the output destination of divided-input data files)

5.4.14 constraint statement (specification of check pending status)

5.4.15 option statement (specification of data processing information)

5.4.16 report statement (specification of a file to which pdload tuning information is output)

5.5 Input data file

5.5.1 DAT format

5.5.2 Binary format

5.5.3 Fixed-size data format

5.5.4 Arrayed data format for tables containing repetition columns

5.5.5 LOB column input file

5.6 Error information file

5.6.1 Contents of error information file

5.6.2 Output example of error information file

5.6.3 Notes about referencing error information

5.6.4 Rules for output when the errdata operand is specified in a source statement

5.7 Column structure information file

5.7.1 Column name statement

5.7.2 skipdata statement

5.7.3 Specification examples

5.8 Null value/function information file

5.8.1 Column number statement

5.9 Null and default values during data loading

5.10 Using a UOC to load a table

5.10.1 Overview

5.10.2 UOC interface

5.10.3 Examples of UOCs

5.10.4 Creating a dynamic link library

5.11 Rules and notes

5.12 Database status in the event of an error and recovery methods

5.13 Examples

5.13.1 HiRDB/Single Server

5.13.2 HiRDB/Parallel Server

6. Interactive SQL Execution Utility

6.1 Overview

6.1.1 Function

7. Database Structure Modification Utility (pdmod)

7.1 Functions of the database structure modification utility

7.3.3 Control statement (create rdarea statement)

7.3.4 Notes

7.4 Expanding an RDAREA

7.4.1 Function

7.4.2 Examples

7.4.3 Control statement (expand rdarea statement)

7.4.4 Notes

7.5 Reinitializing an RDAREA

7.5.1 Function

7.5.2 Examples

7.5.3 Control statement (initialize rdarea statement)

7.5.4 Table and index status after reinitialization

7.5.5 Output of execution results listing

7.5.6 Notes

7.6 Deleting an RDAREA

7.6.1 Function

7.6.2 Example

7.6.3 Control statement (remove rdarea statement)

7.6.4 Notes

7.7 Moving an RDAREAs

7.7.1 Function

7.7.2 Example

7.7.3 Control statement (move rdarea statement)

7.7.4 Output of execution results listing

7.7.5 Notes

7.8 Modifying data dictionary table attribute definitions

7.8.1 Function

7.8.2 Example

7.8.3 Control statement (alter system statement)

7.8.4 Note

7.9 Modifying RDAREA attributes

7.9.1 Function

7.9.2 Example

7.9.3 Control statement (alter rdarea statement)

7.10 Changing an RDAREA from a HiRDB/Single Server structure to a HiRDB/Parallel Server structure

7.10.1 Function

7.10.2 Example

7.10.3 Control statement (alter HiRDB mode to parallel statement)

7.10.4 Notes

7.11 Registering an auditor (security audit facility)

7.11.1 Function

7.11.2 Example

7.11.3 Control statement (create auditor statement)

7.11.4 Notes

7.12 Creating an audit trail table (security audit facility)

7.12.1 Function

7.12.2 Example

7.12.3 Control statement (create audit table statement)

7.13 Rules and notes

8. Database Reorganization Utility (pdrorg)

8.1 Overview

8.1.1 Functions of pdrorg

8.1.2 Reorganizing a table

8.1.3 Unloading a table

8.1.4 Reloading to a table

8.1.5 Reorganizing a dictionary table

8.1.6 Creating indexes in batch mode

8.1.7 Re-creating an index

8.1.8 Reorganizing an index

8.1.9 Log acquisition mode during execution of pdrorg

8.1.10 RDAREAs containing a table and indexes being processed

8.1.11 Whether or not execution of pdrorg is permitted on a table containing columns of an abstract data type

8.1.12 Executor

8.2 Reorganizing a table

8.2.1 Examples

8.2.2 Cross-reference by purpose

8.3 Unloading a table

8.3.1 Examples

8.3.2 Cross-reference by purpose

8.3.3 Format of database load utility input files

8.4 Reloading to a table

8.4.1 Examples

8.4.2 Cross-reference by purpose

8.4.3 Whether or not reloading is permitted when the table definitions of unload table and reload table do not match

8.4.4 Handling of a reloading error during table reorganization

8.5 Reorganizing data dictionary tables

8.5.1 Example

8.5.2 Cross-reference by purpose

8.6 Creating indexes in batch mode

8.6.1 Examples

8.6.2 Cross-reference by purpose

8.7 Re-creating indexes

8.7.1 Examples

8.7.2 Cross-reference by purpose

8.8 Reorganizing indexes

8.8.1 Example

8.8.2 Cross-reference by purpose

8.9 Command format

8.9.1 Format

8.9.2 Options

8.9.3 unload statement (specification of unload data file)

8.9.4 index statement (specification of index information file information)

8.9.5 idxname statement (specification of index information)

8.9.6 idxwork statement (specification of directory for index information file)

8.9.7 sort statement (specification of work directory for sorting)

8.9.8 lobunld statement (specification of LOB data unload file)

8.9.9 unlduoc statement (specification of UOC storage library information)

8.9.10 tblname statement (re-registration of table data to another table)

8.9.11 array statement (specification of row data output format for repetition columns)

8.9.12 unld_func statement (specification of constructor parameter reverse creation function)

8.9.13 reld_func statement (specification of constructor function)

8.9.14 constraint statement (specification of check pending status)

8.9.15 option statement (specification of data processing information)

8.9.16 report statement (specification of a file to which pdrorg tuning information is output)

8.9.17 blobtovarchar statement (specification of column subject to data conversion)

8.9.18 fixtext_option statement (specification of output data during creation of input data file in fixed-size data format)

8.10 Reorganization using a UOC

8.10.1 How to use a UOC during reorganization

8.10.2 Relationships between options and control statements

8.10.3 Overview of UOC processing

8.10.4 UOC interface

8.10.5 Example of a UOC

8.11 Notes on executing pdrorg on special tables

8.11.1 Table with an abstract data type

8.11.2 Falsification prevented table

8.12 Rules and notes

8.13 Database status in the event of an error and recovery method

8.13.1 Error when unloading

8.13.2 Error when reloading

8.13.3 Error when creating an index in batch mode or re-creating an index

8.13.4 Error when reorganizing an index

8.13.5 Error when unloading LOB data

8.13.6 Error when reloading LOB data

9. Dictionary Import/Export Utility (pdexp)

9.1 Overview

9.1.1 Table definition information import/export

9.1.2 Trigger definition information import/export

9.1.3 Stored procedure information import/export

9.1.4 Generation of a definition SQL

10. Rebalancing Utility (pdrbal)

10.1 Overview

10.1.1 Functions of the rebalancing utility

10.1.2 Operation modes of the rebalancing utility

10.1.3 Execution environment

10.3.3 index statement (specification of index information file information)

10.3.4 idxwork statement (specification of directory for index information files)

10.3.5 sort statement (specification of work directory for sorting)

10.3.6 execstop statement (specification of pdrbal execution time)

10.3.7 unld_func statement (specification of constructor parameter reverse creation function)

10.3.8 reld_func statement (specification of constructor function)

10.3.9 report statement (specification of a process results file)

10.3.10 option statement (specification of optional functions)

10.4 Notes about the execution of SQL on FIX hash-partitioned tables during a rebalance operation

10.5 Whether or not SQL is executable during a rebalance operation

10.6 Notes

10.7 Error handling procedures

11. Free Page Release Utility (pdreclaim)

11.1 Overview

11.1.1 About free pages

11.1.2 Overview of pdreclaim

11.1.3 Functions of pdreclaim

11.1.4 Difference in functions from pdrorg

11.1.5 Execution environment

11.3.3 idxname statement (specification of index information)

11.3.4 option statement (specification of optional information)

11.4 pdreclaim processing results

11.5 Notes

12. Global Buffer Residence Utility (pdpgbfon)

12.1 Overview

12.1.1 Overview of pdpgbfon

12.1.2 Functions of pdpgbfon

12.1.3 Execution environment

12.3.3 idxname statement (specification of index information)

12.3.4 option statement (specification of optional information)

12.4 pdpgbfon processing results

12.5 Notes

13. Integrity Check Utility (pdconstck)

13.1 Overview

13.2 Functions of pdconstck

13.2.1 Integrity check facility

13.2.2 Facility for changing check pending status forcibly

13.5 pdconstck processing results

13.6 Notes

14. Statistics Analysis Utility (pdstedit)

14.2.3 Notes on option specifications

14.3 Details about statistical information

14.3.1 Output formats of statistical information

14.3.2 System activity statistical information

14.3.3 UAP statistical information

14.3.4 SQL statistical information

14.3.5 Global buffer pool statistical information

14.3.6 Statistical information about HiRDB files for database manipulation

14.3.7 Deferred write processing statistical information

14.3.8 Index statistical information

14.4 Output of statistical information to a DAT-format file

14.4.1 Data storage format of a DAT-format file

14.4.2 DAT-format file unit

14.4.3 Record formats of DAT-format files

14.5 Notes

14.6 Examples

15. Database Condition Analysis Utility (pddbst)

15.1 Overview

15.1.1 Database condition analysis facility

15.1.2 Condition analysis result accumulation facility

15.1.3 Facility for predicting reorganization time

15.2 Command format

15.2.1 Format

15.2.2 Options

15.2.3 predict statement

15.2.4 workdir statement

15.3 Output format of the database condition analysis facility

15.3.1 Condition analysis by RDAREA (logical analysis)

15.3.2 Condition analysis by RDAREA (physical analysis)

15.3.3 Condition analysis by table or index

15.3.4 Cluster key and clustering data page storage condition analysis

15.4 Execution results of the facility for predicting reorganization time

15.4.1 Output format of the execution results

15.4.2 Output format in CSV format

15.5 Standard value definition file (facility for predicting reorganization time)

15.6 Executing the condition analysis result accumulation facility in prediction level 2

15.6.1 Interval analysis

15.6.2 Merge analysis

15.6.3 Selection criteria

15.7 Rules and notes

15.8 Examples

16. Optimizing Information Collection Utility (pdgetcst)

16.1 Overview

16.1.1 Collecting optimization information by retrieval

16.1.2 Registering optimization information from an optimization information parameter file

16.1.3 Maximum number of concurrently executable utilities

16.2 Command format

16.2.1 Format

16.2.2 Options

16.3 Optimizing information

16.3.1 Optimization information to be collected

16.3.2 Optimizing information collection levels

16.4 Creating the optimization information parameter file

16.4.1 Information to be specified in the optimization information parameter file

16.4.2 Specifications in the optimization information parameter file

16.4.3 Specification example of the optimization information parameter file

16.4.4 Specification rules for the optimization information parameter file

16.5 Rules and notes

16.6 Output format

16.7 Examples

17. Access Path Display Utility (pdvwopt)

17.3 Execution procedure

17.4 Rules and notes

17.5 Output format

17.5.1 Foreign server retrieval processing (prediction) information

17.5.2 Set operation information

17.5.3 Query processing information

17.5.4 Join processing information

17.5.5 Base table retrieval processing information

17.5.6 Types of join methods

17.5.7 Types of retrieval methods

17.5.8 Types of transfer methods

17.5.9 Types of access paths

17.5.10 Types of grouping processing methods

17.5.11 Types of plug-in-provided functions

17.5.12 Search conditions

17.5.13 Key conditions

17.5.14 Types of ORDER BY processing methods

17.6 Concept of tuning

17.6.1 Examples of tuning procedure

17.6.2 Notes about index definitions

17.6.3 Notes about index retrieval

17.6.4 Notes about join retrieval

18. Database Copy Utility (pdcopy)

18.1 Functions of the database copy utility

18.2 Information required for making backup copies

18.3 Examples

18.3.1 Backing up in units of systems

18.3.2 Backing up in units of RDAREAs

18.3.3 Backing up in units of servers

18.3.4 Backing up to files on DAT

18.3.5 Backing up using the differential backup facility

18.3.6 Backing up using NetBackup

18.6 Database copy utility process results listing

18.7 Backup file format

19. Database Recovery Utility (pdrstr)

19.1 Functions of the database recovery utility

19.1.1 Database recovery

19.1.2 Re-creating a log point information file

19.2 Information required for recovering databases

19.3 Examples

19.3.1 Restoring in units of systems

19.3.2 Restoring in units of RDAREAs

19.3.3 Restoring in units of servers

19.3.4 Restoring from a backup using the differential backup facility

19.3.5 Restoring RDAREAs from their backup using NetBackup

19.3.6 Re-creating the log point information file

19.6 Database recovery utility process results listing

20. Registry Facility Initialization Utility (pdreginit)

20.3 Control statements

20.3.1 create rdarea statement

B. Lock Mode During Command Execution

B.1 Lock mode for operation commands

B.2 Lock mode for utilities

C. RDAREA Status During Command Execution

C.1 RDAREA status transitions

C.2 Availability of utility or UAP execution depending on RDAREA status

C.3 Whether or not the check pending status can be set

D. Maximum Number of Concurrently Executable Utilities

E. Creation of a UOC for Use by pdload and pdrorg

E.1 Creating a dynamic link library

E.2 Notes on UOC creation

F. Number of Concurrent Command Connections

G. List of Command Return Codes

Index