Nonstop Database, HiRDB Version 9 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.
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 Function MDir DDir DDic DDic LOB Usr Usr LOB List Reg Reg LOB
RDAREA addition NE NE Y Y#1 Y Y Y NE NE
RDAREA expansion Y Y Y Y Y Y Y Y Y
RDAREA reinitialization NE NE NE Y#2 Y Y Y Y Y
RDAREA deletion NE NE NE#3 NE Y Y Y NE NE
Moving RDAREA NE NE NE NE Y Y NE NE NE
Data dictionary table attribute definition modification -- -- -- -- -- -- -- -- --
RDAREA attribute modification RDAREA name NE Y Y Y Y Y Y Y Y
Open timing NE NE NE NE Y Y Y NE NE
Automatic extension NE NE Y Y Y Y NE Y Y
RDAREA change from a HiRDB single server configuration to a HiRDB parallel server configuration. Y Y Y Y Y Y Y Y Y
Registration of HiRDB file system area generation -- -- -- -- -- -- -- -- --
Deletion of HiRDB file system area generation -- -- -- -- -- -- -- -- --
RDAREA replica definition NE NE NE NE Y#4 Y NE NE NE
RDAREA configuration information copying NE NE NE NE Y#4 Y NE NE NE
Integration of RDAREAs NE NE NE NE Y#4 Y NE NE NE
Auditor registration -- -- -- -- -- -- -- -- --
Audit trail table creation NE NE NE NE Y#4 NE NE NE NE

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.