Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

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 Function MDir DDir DDic DDic LOB Usr Usr LOB List Reg Reg LOB
RDAREA addition NE NE Y Y1 Y Y Y NE NE
RDAREA expansion Y Y Y Y Y Y Y Y Y
RDAREA reinitialization NE NE NE Y2 Y Y Y Y Y
RDAREA deletion NE NE NE3 NE Y Y Y NE NE
Moving RDAREA NE NE NE NE Y Y NE NE NE
Dictionary table attribute definition modification [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
RDAREA attribute modification NE NE NE NE Y Y Y NE NE
RDAREA change from HiRDB/Single Server structure to HiRDB/Parallel Server structure. Y Y Y Y Y Y Y Y Y
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.