7.1 Functions of the database structure modification utility

Executor: HiRDB administrator
The database structure modification utility (pdmod) is used to modify the physical structure of a database, such as by adding, expanding, or reinitializing RDAREAs. This utility resolves RDAREA space shortages that may be caused by frequent additions to and updating of tables.
The table below shows the relationships among the functions of the database structure modification utility (pdmod), the types of RDAREAs, and the memory database.

Table 7-1 Relationships between functions and RDAREA types

RDAREA type FunctionMDirDDirDDicDDic LOBUsrUsr LOBListRegReg LOB
RDAREA additionNENEYY#1YYYNENE
RDAREA expansionYYYYYYYYY
RDAREA reinitializationNENENEY#2YYYYY
RDAREA deletionNENENE#3NEYYYNENE
Moving RDAREANENENENEYYNENENE
Data dictionary table attribute definition modification------------------
RDAREA attribute modificationRDAREA nameNEYYYYYYYY
Open timingNENENENEYYYNENE
Automatic extensionNENEYYYYNEYY
RDAREA change from a HiRDB single server configuration to a HiRDB parallel server configuration. YYYYYYYYY
Registration of HiRDB file system area generation------------------
Deletion of HiRDB file system area generation------------------
RDAREA replica definitionNENENENEY#4YNENENE
RDAREA configuration information copyingNENENENEY#4YNENENE
Integration of RDAREAsNENENENEY#4YNENENE
Auditor registration------------------
Audit trail table creationNENENENEY#4NENENENE
Legend:
MDir: Master directory RDAREA
DDir: Data directory RDAREA
DDic: Data dictionary RDAREA
DDic LOB: Data dictionary LOB RDAREA
Usr: User RDAREA
Usr LOB: User LOB RDAREA
List: List RDAREA
Reg: Registry RDAREA
Reg LOB: Registry LOB RDAREA
Y: Can be executed.
NE: Cannot be executed.
--: Not applicable.

#1: In the case of RDAREA addition, two RDAREAs must be added.

#2: Can be executed only for an RDAREA in which stored procedure of stored function objects are stored.

#3: Can be executed for a data dictionary RDAREA in which a database state analyzed table and database management table are stored.

#4: Cannot be executed on temporary table RDAREAs.