6.3 RDAREAs to be backed up together

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 backupType of RDAREA to be backed up
MSTDIRDICDIC
LOB
USRUSR
LOB
REGREG
LOB
LOB
indx
LOB
data
ALTER
PROCEDURE

YY

ALTER
ROUTINE

YY

ALTER
TABLE
Y1Y1Y

Y

ALTER
TRIGGER

YY

CREATE
FUNCTION

YY

CREATE
INDEX
YYY

Y

Y15

CREATE
PROCEDURE

YY

CREATE
SCHEMA,
CREATE
CONNECTION
SECURITY

Y

CREATE
TABLE
YY2YY34YY9

Y16
CREATE
TRIGGER

YY

CREATE
TYPE

YY24

CREATE
VIEW
Y

Y

DROP
CONNECTION
SECURITY

Y

DROP
DATA TYPE

YY24

DROP
FUNCTION

YY

DROP
INDEX
YYY

Y

Y17

DROP
PROCEDURE

YY

DROP
SCHEMA
Y3Y3YY14YY10

Y18Y19
DROP
TABLE
YY8YY34YY9

Y20Y21
DROP
TRIGGER

YY

DROP
VIEW
Y

Y

Definition SQL other than aboveY7

Y

PURGE
TABLE

Y35

YY9

Y20Y21
Other data manipulation SQL

Y13Y13

Y22Y23
Database load utility

Y35

YY9

Y20Y21
Database structure modif utilityRDAREA additionY

YY30Y5

Y11Y11
RDAREA expansionY

YY30Y5Y11Y25Y26Y11Y11
RDAREA deletionY

Y

RDAREA re-initialYY4YY30Y5Y11, 12Y25Y26

Database reorg utilityReload

Y6, 35Y6YY31

Y20Y21
Reorg

Y36

Y36

Re-create an index

Y32

Y33Y33
Index reorg

Y

Dict import/export utilityImport table definition infoYYYY34YY9

Import of stored procedure

YY

Integrity check utility

Y35

Y35

Optimizing information collection utility

Y

Registry facility initialization utility

Y25Y26

Rebalancing utility

YYYY9

Y20Y21
Database definition utilitySame as definition SQL
pdplgrgst command

YY

pdorend command

Y36

Y36

Deletion of plug-inYYYYYY27YYY28Y29

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)

Note
To back up a data dictionary LOB RDAREA for storing objects, either the -M option of the database copy utility must be omitted or x or r must be specified in the -M option.

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.

31 Required if a LOB column was defined for the target table. Also, in cases where only a LOB column structure base table is reconfigured (-j option is not specified), the LOB column must be acquired together with the user RDAREA.
32 The table storage RDAREA and the index storage RDAREA must be acquired as a pair.
33 Also in cases where plug-in indexes are subject to processing, the table storage RDAREAs (user RDAREAs) must be acquired in preparation for no-log hold.
34 Required if a referential constraint's action is CASCADE.
35 Required if a referencing table, a referenced table, or a table for which a check constraint was defined is the processing target.
36 Required if the check pending status is changed.

Table 6-4 RDAREAs to be backed up when a LOB column is defined for an updated table

Updating type and conditionFor userFor user LOB
INSERT statementData exists in a column other than LOB column.LOB column is null.Y[Figure]
LOB column contains data.YY
DELETE statementData exists in a column other than LOB column.LOB column is null.Y[Figure]
LOB column contains data.YY
UPDATE statementUpdating occurred in a column other than LOB column.LOB column was not updated.Y[Figure]
LOB column was updated.YY
No updating occurred in a column other than LOB column.LOB column was updated.Null value was updated to some data.YY
Data was updated to null.YY
Data A was updated to data B.[Figure]Y

Y: Backup must be collected.

[Figure]: Backup need not be collected.