1.3 List of utilities

The table below lists the utilities used with HiRDB. Depending on the utility, conditions might be applicable to the executor, HiRDB status, and the executing server machine. For details, see the description of each utility.

Table 1-2 List of utilities

UtilityDescriptionExecutorHiRDB statusExecuting server machine
Database initialization utility (pdinit)Initializes a database (creates RDAREAs).HiRDB administratorACTSDS or MGR
Database definition utility (pddef)Executes definition SQL statements.User with CONNECT privilegeACTAny server machine
Database load utility (pdload)Stores user-created data in a table.Depends on the operating modeACTSDS or MGR
SQL interactive execution utility (pdsql)Executes SQL commands interactively.User with CONNECT privilegeACTAny 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)Maintains tables such as by reorganizing tables and re-creating indexes.Depends on the functionACTSDS 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.General userANYSDS or FES
Database copy utility (pdcopy)
  • 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)
  • 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
Audit log output utility for JP1/NETM/Audit (pdaudput)Outputs audit trail table data to an audit log output file for JP1/NETM/Audit.HiRDB administrator and auditor#1ACTSDS or MGR
Legend:
ANY: Can be executed whether or not HiRDB is active.
ACT: Can be executed only while HiRDB is active.
SDS: In a HiRDB single server configuration, the command is executed on the server machine of the single server.
MGR: In a HiRDB parallel server configuration, the command is executed on the server machine where the system manager is located.
FES: In a HiRDB parallel server configuration, 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
Can be executed by the HiRDB administrator acting in concert with the auditor.