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 | ACT4 | SDS or MGR |
Database definition utility (pddef) | Executes definition SQL statements. | User with CONNECT privilege5 | ACT | Any server machine |
Database load utility (pdload)1 | Stores user-created data in a table. | Depends on the operating mode2 | ACT | SDS or MGR |
SQL interactive execution utility (pdsql)6 | Executes SQL commands interactively. | User with CONNECT privilege5 | 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)1 | Maintains tables such as by reorganizing tables and re-creating indexes. | Depends on the function3 | 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)1 |
| HiRDB administrator | ACT | SDS or MGR |
Database recovery utility (pdrstr)1 |
| 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 |