Nonstop Database, HiRDB Version 9 System Operation Guide

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

6.8.5 Manipulating user LOB RDAREAs for which the frozen update command has been executed

Some manipulations cannot be executed on user LOB RDAREAs for which the frozen update command has been executed, as indicated in the table below. If you must execute on a LOB RDAREA a manipulation that the following table shows cannot be executed, use the frozen update command with the -d option specified to release the user LOB RDAREA's frozen update status. After executing the manipulation, you must back up all HiRDB files in the user LOB RDAREAs again.

Table 6-8 Manipulations executable on user LOB RDAREAs for which the frozen update command has been executed

Manipulation Status of HiRDB files
Frozen update status Permit update status
SQL (data manipulation) INSERT -- Yes
UPDATE No Yes
DELETE No Yes
SQL (table manipulation) PURGE TABLE No No
DROP TABLE No No
Database load utility Add mode -- Yes
Load mode No No
Database reorganization utility (table reorganization, table reloading) No No
Rebalancing utility No No
Database structure modification utility Yes Yes
Database recovery utility Yes Yes
Operation command Yes Yes

Legend:
Yes: Can be executed
No: Cannot be executed
--: Not applicable.