The HiRDB administrator must back up not only RDAREAs that have been processed, but also RDAREAs that have been updated as a result of that processing. Table 6-3 lists the RDAREAs that should be backed up together.
Table 6-3 RDAREAs to be backed up together
Processing executed since previous backup | Type of RDAREA to be backed up | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
MST | DIR | DIC | DIC LOB | USR | USR LOB | REG | REG LOB | LOB indx | LOB data | ||
ALTER PROCEDURE | Y | Y | |||||||||
ALTER ROUTINE | Y | Y | |||||||||
ALTER TABLE | Y1 | Y1 | Y | Y | |||||||
ALTER TRIGGER | Y | Y | |||||||||
CREATE FUNCTION | Y | Y | |||||||||
CREATE INDEX | Y | Y | Y | Y | Y15 | ||||||
CREATE PROCEDURE | Y | Y | |||||||||
CREATE SCHEMA, CREATE CONNECTION SECURITY | Y | ||||||||||
CREATE TABLE | Y | Y2 | Y | Y34 | Y | Y9 | Y16 | ||||
CREATE TRIGGER | Y | Y | |||||||||
CREATE TYPE | Y | Y24 | |||||||||
CREATE VIEW | Y | Y | |||||||||
DROP CONNECTION SECURITY | Y | ||||||||||
DROP DATA TYPE | Y | Y24 | |||||||||
DROP FUNCTION | Y | Y | |||||||||
DROP INDEX | Y | Y | Y | Y | Y17 | ||||||
DROP PROCEDURE | Y | Y | |||||||||
DROP SCHEMA | Y3 | Y3 | Y | Y14 | Y | Y10 | Y18 | Y19 | |||
DROP TABLE | Y | Y8 | Y | Y34 | Y | Y9 | Y20 | Y21 | |||
DROP TRIGGER | Y | Y | |||||||||
DROP VIEW | Y | Y | |||||||||
Definition SQL other than above | Y7 | Y | |||||||||
PURGE TABLE | Y35 | Y | Y9 | Y20 | Y21 | ||||||
Other data manipulation SQL | Y13 | Y13 | Y22 | Y23 | |||||||
Database load utility | Y35 | Y | Y9 | Y20 | Y21 | ||||||
Database structure modif utility | RDAREA addition | Y | Y | Y30 | Y5 | Y11 | Y11 | ||||
RDAREA expansion | Y | Y | Y30 | Y5 | Y11 | Y25 | Y26 | Y11 | Y11 | ||
RDAREA deletion | Y | Y | |||||||||
RDAREA re-initial | Y | Y4 | Y | Y30 | Y5 | Y11, 12 | Y25 | Y26 | |||
Database reorg utility | Reload | Y6, 35 | Y6 | Y | Y31 | Y20 | Y21 | ||||
Reorg | Y36 | Y36 | |||||||||
Re-create an index | Y32 | Y33 | Y33 | ||||||||
Index reorg | Y | ||||||||||
Dict import/export utility | Import table definition info | Y | Y | Y | Y34 | Y | Y9 | ||||
Import of stored procedure | Y | Y | |||||||||
Integrity check utility | Y35 | Y35 | |||||||||
Optimizing information collection utility | Y | ||||||||||
Registry facility initialization utility | Y25 | Y26 | |||||||||
Rebalancing utility | Y | Y | Y | Y9 | Y20 | Y21 | |||||
Database definition utility | Same as definition SQL | ||||||||||
pdplgrgst command | Y | Y | |||||||||
pdorend command | Y36 | Y36 | |||||||||
Deletion of plug-in | Y | Y | Y | Y | Y | Y27 | Y | Y | Y28 | Y29 |
modif: modification
re-initial: re-initialization
reorg: reorganization
Re-create: Re-creating
Dict: Dictionary
info: information
Y: RDAREAs to be backed up together
MST: Master directory RDAREA
DIR: Data directory RDAREA
DIC: Data dictionary RDAREA
DIC LOB: Data dictionary LOB RDAREA
USR: User RDAREA
USR LOB: User LOB RDAREA
REG: Registry RDAREA
REG LOB: Registry LOB RDAREA
LOB indx: User LOB RDAREA (applicable if plug-in index is stored)
LOB data: User LOB RDAREA (applicable if abstract data type is stored)
1 Required if a column comprising the index was deleted or a column with a low ID was deleted from the index columns. The column IDs can be obtained by searching the COLUMN_ID column of the SQL_COLUMNS dictionary table.
2 Required if a row-partitioned table or cluster key was defined.
3 Required if a table or index was defined for a schema that was deleted.
4 Required if an index is stored in an RDAREA that was deleted.
5 Required if a user RDAREA was processed.
6 Required if a dictionary table was reorganized.
7 Required if a view table was deleted because access privilege to the base table was lost by REVOKE access-privilege.
8 Required in the following cases:
9 Required if a LOB column is defined for a table that was processed.
10 Required if a schema that was deleted contained a table for which a LOB column was defined.
11 Required if a user LOB RDAREA was processed.
12 Required if a user RDAREA that contained a table for which a LOB column was defined was initialized.
13 If no LOB column is defined for the updated table, the user RDAREAs that contain this table must be backed up. If a LOB column is defined for the updated table, the RDAREAs listed in Table 6-4 must be backed up.
14 Required if a routine, a table for which a CASCADE referential constraint action was defined, or a trigger was defined in a schema that is subject to deletion.
15 Required if a plug-in index was created.
16 Required if an abstract data type was defined for a table has the LOB attribute.
17 Required if a plug-in index was deleted.
18 Required if a schema that was deleted contained a table for which a plug-in index was defined.
19 Required if a schema that was deleted contained a table for which the LOB attribute was defined.
20 Required if a plug-in index was defined for a table that was processed.
21 Required if the LOB attribute was defined for a table that was processed.
22 Required if an attribute for which a plug-in index was defined was updated.
23 Required if the LOB attribute was updated.
24 Required if there was a function definition specified with an SQL procedure.
25 Required if a registry RDAREA was processed.
26 Required if a registry LOB RDAREA was processed.
27 Required if the LOB attribute was defined for a table for which an abstract data type provided by a plug-in was defined.
28 Required if a plug-in index was defined.
29 Required if the LOB attribute was defined for an abstract data type provided by a plug-in.
30 Required if a data dictionary LOB RDAREA was processed.
Table 6-4 RDAREAs to be backed up when a LOB column is defined for an updated table
Updating type and condition | For user | For user LOB | |||
---|---|---|---|---|---|
INSERT statement | Data exists in a column other than LOB column. | LOB column is null. | Y | ![]() | |
LOB column contains data. | Y | Y | |||
DELETE statement | Data exists in a column other than LOB column. | LOB column is null. | Y | ![]() | |
LOB column contains data. | Y | Y | |||
UPDATE statement | Updating occurred in a column other than LOB column. | LOB column was not updated. | Y | ![]() | |
LOB column was updated. | Y | Y | |||
No updating occurred in a column other than LOB column. | LOB column was updated. | Null value was updated to some data. | Y | Y | |
Data was updated to null. | Y | Y | |||
Data A was updated to data B. | ![]() | Y |
Y: Backup must be collected.
: Backup need not be collected.