Appendix A. List of Commands

HiRDB provides operation commands and utilities. The table below lists the commands that can be used with HiRDB.

Table A-1 List of commands

TypeCommandDescriptionReference
System operationpdadmvrDisplays the HiRDB version informationpdadmvr
pdcatDisplays file contentspdcat
pdchgconfChanges the system configurationpdchgconf
pdclibsyncManipulates C library filespdclibsync
pdconfchkChecks system definitionspdconfchk
pdcspoolDeletes troubleshooting information and temporary work filespdcspool
pdinfogetCollects error information and estimates the amount of error information to be acquiredpdinfoget
pdjarsyncManipulates JAR filespdjarsync
pdlistlsDisplays list definition informationpdlistls
pdlsDisplays the HiRDB system statuspdls
pdntenvSets up a HiRDB operating environmentpdntenv
pdobjconvMigrates SQL objects into a 64-bit-mode HiRDBpdobjconv
pdsvhostnameDisplays the server's host namepdsvhostname
pdvrupUpgrades HiRDBpdvrup
HiRDB file systempdfbkupBacks up the HiRDB file systempdfbkup
pdffsckChecks and repairs the integrity of a HiRDB file system areapdffsck
pdflsDisplays HiRDB file system informationpdfls
pdfmkfsInitializes a HiRDB file system areapdfmkfs
pdfrmDeletes a HiRDB filepdfrm
pdfrstrRestores the HiRDB file systempdfrstr
pdfstatfsDisplays the status of a HiRDB file system areapdfstatfs
pdfzeroinitInitializes the used area in a HiRDB file system areapdfzeroinit
Log filespdlogadpfAllocates a log-related filepdlogadpf
pdlogatulManages the automatic log unloading facilitypdlogatul
pdlogchgChanges the status of a log-related filepdlogchg
pdlogclsCloses a log-related filepdlogcls
pdloginitInitializes a log-related filepdloginit
pdloglsDisplays log-related file informationpdlogls
pdlogopenOpens a log-related filepdlogopen
pdlogrmDeletes a log-related filepdlogrm
pdlogswapSwaps log-related filespdlogswap
pdlogsyncCollects a synchronization point dumppdlogsync
pdlogucatDisplays information about unload log filespdlogucat
pdlogunldUnloads a log-related filepdlogunld
Status filespdstsclsCloses a status filepdstscls
pdstsinitInitializes a status filepdstsinit
pdstsopenOpens a status filepdstsopen
pdstsrmDeletes a status filepdstsrm
pdstsswapSwaps status filespdstsswap
HiRDB startup and terminationpdstartStarts a HiRDB system, unit, or serverpdstart
pdstopTerminates a HiRDB system, unit, or serverpdstop
Statistics logpdstbeginStarts output of statistical informationpdstbegin
pdstendStops output of statistical informationpdstend
pdstjswapSwaps statistics log filespdstjswap
pdstjsyncApplies the statistics log buffer to the statistics log filepdstjsync
RDAREAspdcloseCloses RDAREAspdclose
pddblsDisplays the status of RDAREAspddbls
pdholdShuts down RDAREAspdhold
pdopenOpens RDAREAspdopen
pdrelsReleases RDAREAs from shutdown statuspdrels
pddbfrzFreezes updating of a full HiRDB file constituting a user LOB RDAREApddbfrz
pdrdreflsDisplays information about related RDAREAspdrdrefls
Global bufferpdbuflsDisplays global buffer informationpdbufls
pdbufmodUpdates a global buffer dynamicallypdbufmod
In-memory data processingpdmemdbPerforms in-memory data processingpdmemdb
Transaction controlpdcmtCommits a transactionpdcmt
pdfgtTerminates a transaction forciblypdfgt
pdrbkRolls back a transactionpdrbk
pdtrndecSettles an unsettled transaction forcibly and automaticallypdtrndec
Process controlpdcancelTerminates a UAP or utility forciblypdcancel
pdchprcChanges the number of resident server processespdchprc
pdkillTerminates a process forciblypdkill
pdpfreshRestarts a process server processpdpfresh
Updating HiRDB versionpdprgcopyCopies a HiRDB update versionpdprgcopy
pdprgrenewUpdates to a HiRDB update versionpdprgrenew
HiRDB Datareplicator linkagepdrplstartStarts HiRDB Datareplicator linkagepdrplstart
pdrplstopStops HiRDB Datareplicator linkagepdrplstop
Security auditpdaudbeginStarts acquisition of audit trailspdaudbegin
pdaudendStops acquisition of audit trailspdaudend
pdaudatldPerforms automatic data loading on an audit trail tablepdaudatld
pdaudrmDeletes audit trail files in shutdown statuspdaudrm
pdaudswapSwaps current audit trail filespdaudswap
pdaudputOutputs data from an audit trail table to an audit log output file for JP1/NETM/Auditpdaudput
Connection security facilitypdacunlckReleases the consecutive certification failure account lock statepdacunlck
Transaction queuing facilitypdtrnqingStarts and releases the transaction queuing facilitypdtrnqing
SQL trace acquisitionpdclttrcAcquires SQL trace dynamicallypdclttrc
Performance trace informationpdprfedEdits and outputs performance trace informationpdprfed
pdprflevelDisplays or changes the performance trace acquisition levelpdprflevel
SQL object information displaypdobilsDisplays statistical information about an SQL object bufferpdobils
SQL specificationspdextfuncDefines or deletes the extended system-defined scalar functionpdextfunc
Registration of exceptions to Windows Firewallpddelfw.batDeletes HiRDB from the Windows Firewall exception listpddelfw.bat
pdsetfw.batRegisters HiRDB into the Windows Firewall exception listpdsetfw.bat
SQL compilationpdcblCOBOL preprocessor--#1
pdcppC preprocessor--#1
pdocbOOCOBOL preprocessor--#1
pdoccC++ preprocessor--#1
Database creationpdinitDatabase initialization utilityChapter 3
pddefDatabase definition utilityChapter 4
pdloadDatabase load utilityChapter 5
pdparaloadPerforms parallel loadingpdparaload
--Interactive SQL execution utility#2Chapter 6
pddefrevGenerates a definition SQL statementpddefrev
Database operationspdmodDatabase structure modification utilityChapter 7
pdrorgDatabase reorganization utilityChapter 8
pdexpDictionary import/export utilityChapter 9
pdrbalRebalancing utilityChapter 10
pdreclaimFree page release utilityChapter 11
pdpgbfonGlobal buffer residence utilityChapter 12
pdconstckIntegrity check utilityChapter 13
TuningpdsteditStatistics analysis utilityChapter 14
pddbstDatabase condition analysis utilityChapter 15
pdgetcstOptimizing information collection utilityChapter 16
pdvwoptAccess path display utilityChapter 17
Database error handlingpdcopyDatabase copy utilityChapter 18
pdbkuplsDisplays information about backup filespdbkupls
pdrstrDatabase recovery utilityChapter 19
Plug-in-relatedpdplgrgstRegisters and deletes plug-inspdplgrgst
pdreginitRegistry facility initialization utilityChapter 20

--: Not applicable.

#1: For details about pdcbl, pdcpp, pdocb, and pdocc, see the HiRDB Version 9 UAP Development Guide.

#2: HiRDB SQL Executor is required in order to execute the interactive SQL execution utility.