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
Utility | Description | Executor | HiRDB status | Executing server machine |
---|---|---|---|---|
Database initialization utility (pdinit) | Initializes a database (creates RDAREAs). | HiRDB administrator | ACT | SDS or MGR |
Database definition utility (pddef) | Executes definition SQL statements. | User with CONNECT privilege | ACT | Any server machine |
Database load utility (pdload) | Stores user-created data in a table. | Depends on the operating mode | ACT | SDS or MGR |
SQL interactive execution utility (pdsql) | Executes SQL commands interactively. | User with CONNECT privilege | 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 function | 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. | General user | ANY | SDS or FES |
Database copy utility (pdcopy) |
| HiRDB administrator | ACT | SDS or MGR |
Database recovery utility (pdrstr) |
| 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 |
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#1 | ACT | SDS or MGR |