Nonstop Database, HiRDB Version 9 UAP Development Guide
Some HiRDB commands can be executed from UAPs and some cannot. The following table shows whether each command is executable from UAPs.
Table 12-1 Command executability from UAPs
| Type | Command | Description | Executability from COMMAND EXECUTE | Executability from CALL COMMAND |
|---|---|---|---|---|
| System operation | pdadmvr | Gets the HiRDB version information. | E | E |
| pdcat | Displays file contents. | E | E | |
| pdchgconf | System reconfiguration command | -- | E | |
| pdclibsync | Manipulates C library files. | E | E | |
| pdconfchk | Checks system definitions. | -- | E | |
| pdcspool | Deletes troubleshooting information. | E | E | |
| pddivinfgt | Acquires and outputs table partitioning conditions. | -- | -- | |
| pdgeter | Acquires error information. | E | E | |
| pdinfoget | Acquires error information and estimates its volume. | -- | E | |
| pditvtrc | Periodically gets the HiRDB status. | E | E | |
| pditvstop | Stops periodic acquisition of the HiRDB status. | E | E | |
| pdjarsync | Manipulates JAR files. | E | E | |
| pdlistls | Displays list definition information. | E | E | |
| pdlodsv | Reduces the size of the installation directory. | -- | -- | |
| pdls | Displays HiRDB system status. | E | E | |
| pdmemsv | Saves memory space. | -- | -- | |
| pdntenv | Sets the HiRDB operation environment. | -- | -- | |
| pdobjconv | Migrates SQL objects into 64-bit-mode HiRDB. | E | -- | |
| pdopsetup | Installs an additional HiRDB program product. | -- | -- | |
| pdsetup | Registers or deletes a HiRDB system in the OS. | -- | -- | |
| pdsvhostname | Displays the server host name. | -- | E | |
| pdvrup | Upgrades HiRDB. | -- | E | |
| HiRDB file system | pdfbkup | Backs up the HiRDB file system. | E | E |
| pdfls | Displays HiRDB file system information. | E | E | |
| pdfmkfs | Initializes a HiRDB file system area. | E | E | |
| pdfrm | Deletes a HiRDB file. | E | E | |
| pdfrstr | Restores the HiRDB file system. | E | E | |
| pdfstatfs | Displays the status of a HiRDB file system area. | E | E | |
| pdffsck | Verifies and restores HiRDB file system area integrity. | E | E | |
| Log files | pdlogadpf | Allocates a log file. | E | E |
| pdlogatul | Controls the automatic log unloading facility. | -- | E | |
| pdlogchg | Changes the status of a log file. | E | E | |
| pdlogcls | Closes a log file. | E | E | |
| pdloginit | Initializes a log file. | E | E | |
| pdlogls | Displays log file information. | E | E | |
| pdlogopen | Opens a log file. | E | E | |
| pdlogrm | Deletes a log file. | E | E | |
| pdlogswap | Swaps log files. | E | E | |
| pdlogsync | Collects a synchronization point dump. | E | E | |
| pdlogucat | Displays unload log file information. | E | E | |
| pdlogunld | Unloads a log file. | E | E | |
| Status files | pdstscls | Closes an open status file. | E | E |
| pdstsinit | Initializes a status file. | E | E | |
| pdstsopen | Opens a status file. | E | E | |
| pdstsrm | Deletes a status file. | E | E | |
| pdstsswap | Swaps status files. | E | E | |
| HiRDB startup and termination | pdstart | Starts a HiRDB system, unit, or server. | E | E |
| pdstop | Terminates a HiRDB system, unit, or server. | E | E | |
| Statistics log | pdstbegin | Starts output of statistical information. | E | E |
| pdstend | Stops output of statistical information. | E | E | |
| pdstjswap | Swaps statistics log files. | E | E | |
| pdstjsync | Copies the contents of the statistics log buffer to the statistics log file. | E | E | |
| RDAREAs | pdclose | Closes RDAREAs. | E | E |
| pddbls | Displays the status of RDAREAs. | E | E | |
| pdhold | Shuts down RDAREAs. | E | E | |
| pdopen | Opens RDAREAs. | E | E | |
| pdrels | Releases RDAREAs from shutdown status. | E | E | |
| pddbfrz | Executes frozen update of full HiRDB files in the user LOB RDAREA. | E | E | |
| pdrdrefls | Displays related RD area information. | E | E | |
| Global Buffer | pdbufls | Displays global buffer information. | E | E |
| pdbufmod | Dynamically changes the global buffer. | E | E | |
| Transaction control | pdcmt | Commits a transaction. | E | E |
| pdfgt | Forcibly terminates a transaction. | E | E | |
| pdrbk | Rolls back a transaction. | E | E | |
| pdtrndec | Forcibly completes uncompleted transactions automatically. | -- | E | |
| Process control | pdcancel | Forcibly terminates UAP and utility processing. | E | E |
| pdchprc | Changes the number of server process activations. | E | E | |
| pdkill | Stops a process forcibly. | -- | E | |
| pdpfresh | Refreshes a server process. | E | E | |
| pdrpause | Restarts a process server process. | -- | E | |
| Update to HiRDB update version | pdprgcopy | Copies the HiRDB update version. | -- | E |
| pdprgrenew | Updates HiRDB to the update version. | -- | E | |
| HiRDB Datareplicator linkage | pdrplstart | Starts HiRDB Datareplicator linkage. | -- | E |
| pdrplstop | Stops HiRDB Datareplicator linkage. | -- | E | |
| Inner replica facility | pddbchg | Switches the replica status of the replica RDAREA. | E | E |
| Updatable online reorganization | pdorbegin | Commits the database for online reorganization. | E | E |
| pdorcheck | Checks the application conditions for online reorganization. | E | E | |
| pdorchg | Switches the current RDAREA for online reorganization. | E | E | |
| pdorcreate | Creates a reflection environment for online reorganization. | E | E | |
| pdorend | Executes reflection of online reorganization. | E | E | |
| Security audit | pdaudbegin | Starts audit trail acquisition. | E | E |
| pdaudend | Stops audit trail acquisition. | E | E | |
| pdaudrm | Deletes audit trail files that are shut down. | E | E | |
| pdaudswap | Swaps the current audit trail file. | E | E | |
| pdaudatld | Controls the facility for automatically loading audit trail table data. | E | E | |
| pdaudput | Outputs audit logs for JP1/NETM/Audit. | E | -- | |
| Connection security facility | pdacunlck | Unlocks the consecutive certification failure account lock state. | -- | E |
| Real Time SAN Replication | pdrisechk | Checks the configuration of Real Time SAN Replication. | -- | E |
| pdrisedbto | Inherits the Real Time SAN Replication database. | -- | E | |
| pdriseset | Sets the site status of Real Time SAN Replication. | -- | E | |
| In-memory data processing | pdmemdb | Performs in-memory data processing. | E | E |
| SQL trace acquisition | pdclttrc | Dynamically acquires an SQL trace. | E | E |
| SQL object information display | pdobils | Displays statistical information for an SQL object. | -- | E |
| SQL compilation | pdcbl | COBOL preprocessor | -- | -- |
| pdcpp | C preprocessor | -- | -- | |
| pdocb | OOCOBOL preprocessor | -- | -- | |
| pdocc | C++ preprocessor | -- | -- | |
| Database creation | pdinit | Database initialization utility | -- | E |
| pddef | Database definition utility | -- | E | |
| pdload | Database load utility | E | E | |
| pdparaload | Parallel loading facility | -- | -- | |
| pdsql# | Interactive SQL execution utility | -- | -- | |
| pddefrev | Generates a definition SQL statement. | -- | E | |
| Database operations | pdmod | Database structure modification utility | E | E |
| pdrorg | Database reorganization utility | E | E | |
| pdexp | Dictionary import/export utility | -- | E | |
| pdrbal | Rebalancing utility | -- | E | |
| pdreclaim | Free page release utility | E | E | |
| pdpgbfon | Global buffer residence utility | E | E | |
| pdconstck | Integrity check utility | -- | E | |
| Tuning | pdstedit | Statistics analysis utility | -- | E |
| pddbst | Database condition analysis utility | E | E | |
| pdgetcst | Optimizing information collection utility | -- | E | |
| pdvwopt | Access path display utility | -- | E | |
| Database error handling | pdcopy | Database copy utility | E | E |
| pdbkupls | Displays backup file information. | E | E | |
| pdrstr | Database recovery utility | E | E | |
| Plug-in-related | pdplgrgst | Registers a plug-in. | -- | -- |
| pdplgset | Sets up a plug-in. | -- | -- | |
| pdreginit | Registry facility initialization utility | E | -- |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.