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. Table 7-1 shows the relationships between the functions of the database structure modification utility (pdmod) and the types of RDAREAs.

Table 7-1 Relationships between functions and RDAREA types

RDAREA type FunctionMDirDDirDDicDDic LOBUsrUsr LOBListRegReg LOB
RDAREA additionNENEYY1YYYNENE
RDAREA expansionYYYYYYYYY
RDAREA reinitializationNENENEY2YYYYY
RDAREA deletionNENENE3NEYYYNENE
Moving RDAREANENENENEYYNENENE
Dictionary table attribute definition modification[Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure]
RDAREA attribute modificationNENENENEYYYNENE
RDAREA change from HiRDB/Single Server structure to HiRDB/Parallel Server structure.YYYYYYYYY
Registration of HiRDB file system area generation[Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure]
Deletion of HiRDB file system area generation[Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure]
RDAREA replica definitionNENENENEYYNENENE
RDAREA configuration information copyingNENENENEYYNENENE
Integration of RDAREAsNENENENEYYNENENE
Auditor registration[Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure][Figure]
Audit trail table creation[Figure][Figure][Figure][Figure]Y[Figure][Figure][Figure][Figure]
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.
[Figure]: 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.