1.3 List of utilities

Table 1-2 lists the utilities used with HiRDB.

Table 1-2 List of utilities

UtilityDescriptionExecutorHiRDB statusExecuting server machine
Database initialization utility (pdinit)Initializes a database (creates RDAREAs).HiRDB administratorACT4SDS or MGR
Database definition utility (pddef)Executes definition SQL statements.User with CONNECT privilege5ACTAny server machine
Database load utility (pdload)1Stores user-created data in a table.Depends on the operating mode2ACTSDS or MGR
SQL interactive execution utility (pdsql)6Executes SQL commands interactively.User with CONNECT privilege5ACTAny server machine
Database structure modification utility (pdmod)Modifies the physical structure of a database, such as by adding, extending, or reinitializing RDAREAs.HiRDB administratorACTSDS or MGR
Database reorganization utility (pdrorg)1Maintains tables such as by reorganizing tables and re-creating indexes.Depends on the function3ACTSDS or MGR
Dictionary import/export utility (pdexp)Migrates table definition information and stored procedure information.User with DBA privilegeACTSDS 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 privilegeACTSDS or MGR
Free page release utility (pdreclaim)Releases free pages (used free pages) during online operation.User with DBA, INSERT, or DELETE privilegeACTSDS 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 ownerACTSDS 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 ownerACTSDS or MGR
Statistics analysis utility (pdstedit)Inputs information from unload data files and system log files and edits the statistical information.HiRDB administratorANYAny 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 privilegeACTSDS 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 tableACTSDS or MGR
Access path display utility (pdvwopt)Displays access path information determined by SQL optimization processing.USRANYSDS or FES
Database copy utility (pdcopy)1
  • Makes a backup of a database.
  • Acquires log point information and creates a log point information file.
HiRDB administratorACTSDS or MGR
Database recovery utility (pdrstr)1
  • 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 administratorACTSDS 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 administratorACTSDS 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.
1
A utility special unit can be used.
2
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.
3
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.
4
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).
5
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.
6
HiRDB SQL Executor is required in order to execute the SQL interactive execution utility.