Nonstop Database, HiRDB Version 9 System Operation Guide
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 |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.