Table 1-2 lists the utilities used with HiRDB.

Table 1-2 List of utilities

Utility	Description	Executor	HiRDB status	Executing server machine
Database initialization utility (pdinit)	Initializes a database (creates RDAREAs).	HiRDB administrator	ACT3	SDS or MGR
Database definition utility (pddef)	Executes definition SQL statements.	User with CONNECT privilege4	ACT	Any server machine
Database load utility (pdload)	Stores user-created data in a table.	Depends on the operating mode1	ACT	SDS or MGR
SQL interactive execution utility5	Executes SQL commands interactively.	User with CONNECT privilege4	ACT	Any server machine
Database structure modification utility (pdmod)	Modifies the physical structure of a database, such as by adding, extending, or reinitializing RDAREAs.	HiRDB administrator	ACT	SDS or MGR
Database reorganization utility (pdrorg)	Maintains tables such as by reorganizing tables and re-creating indexes.	Depends on the function2	ACT	SDS or MGR
Dictionary import/export utility (pdexp)	Migrates table definition information and stored procedure information.	User with DBA privilege	ACT	SDS or MGR
Rebalancing utility (pdrbal)	Corrects an imbalance of data that results when RDAREAs are added to rebalancing tables.	User with DBA, SELECT, INSERT, or DELETE privilege	ACT	SDS or MGR
Free page release utility (pdreclaim)	Releases free pages (used free pages) during online operation.	User with DBA, INSERT, or DELETE privilege	ACT	SDS or MGR
Global buffer residence utility (pdpgbfon)	Reads table page information into a global buffer.	User with DBA privilege or SELECT privilege for the table, or schema owner	ACT	SDS or MGR
Integrity check utility(pdconstck)	Performs integrity checking and manipulates (sets or releases) the check pending status on tables for which referential constraints or check constraints have been defined.	User with DBA privilege or table owner	ACT	SDS or MGR
Statistics analysis utility (pdstedit)	Inputs information from unload data files and system log files and edits the statistical information.	HiRDB administrator	ANY	Any server machine
Database condition analysis utility (pddbst)	Analyzes the status of tables and indexes in user RDAREAs or the storage status of a data dictionary RDAREA, and displays the analysis result.	User with DBA privilege	ACT	SDS or MGR
Optimizing information collection utility (pdgetcst)	Collects optimization information in order to optimize based on cost and stores the information in a data dictionary table.	User with SELECT privilege for the target table	ACT	SDS or MGR
Access path display utility (pdvwopt)	Displays access path information determined by SQL optimization processing.	USR	ANY	SDS or FES
Database copy utility (pdcopy)	Makes a backup of a database. Acquires log point information and creates a log point information file.	HiRDB administrator	ACT	SDS or MGR
Database recovery utility (pdrstr)	In the event of an error, restores a database from a backup copy and information logged after the backup was made. Re-creates the log point information file.	HiRDB administrator	ACT	SDS or MGR
Registry facility initialization utility (pdreginit)	Creates registry RDAREAs, registry LOB RDAREAs, and registry management tables for controlling and operating the registry facility.	HiRDB administrator	ACT	SDS or MGR

Legend:

ANY: Can be executed whether or not HiRDB is active.

ACT: Can be executed only while HiRDB is active.

SDS: For a HiRDB/Single Server, the command is executed on the server machine of the single server.

MGR: For a HiRDB/Parallel Server, the command is executed on the server machine where the system manager is located.

FES: For HiRDB/Parallel Server, the command is executed on the server machine where the front end server is located.

Note

A file that is specified in an operation command or utility that is executing must not be used at the same time by another operation command, utility, or UAP; doing so will result in an error and cause the processing results to be invalid.

¹

In the addition mode (-d option omitted), this utility can be executed if the user has the INSERT privilege.

In the creation mode (-d option specified), the INSERT and DELETE privileges are required.

For an audit trail table, the audit privilege is required.

²

Reorganization of a dictionary can be executed only by users with the DBA privilege.

To unload a table, either the DBA privilege or the SELECT privilege for the table is required.

To reload a table, either the DBA privilege or the INSERT and DELETE privileges for the table are required.

To create, batch-create, or reorganize an index, no privilege is required.

³

This utility can be executed only when HiRDB is in end-of-initialization wait status (HiRDB is placed in wait status after issuing the KFPS05201-Q message).

⁴

The privilege that is required depends on the SQL to be executed. For details about the privileges required to execute SQL commands, see the manual HiRDB Version 8 SQL Reference.

⁵

HiRDB SQL Executor is required in order to execute the SQL interactive execution utility.