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.