Scalable Database Server, HiRDB Version 8 System Operation Guide
Some manipulations cannot be executed on user LOB RDAREAs for which the frozen update command has been executed, as indicated in Table 6-8. If you must execute on a LOB RDAREA a manipulation that Table 6-8 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) 2007, Hitachi, Ltd.