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 |