The use of the inner replica facility through the installation of HiRDB Staticizer Option and the use of updatable online reorganization are subject to the following restrictions:
The following table lists the SQL statements that can be executed in conjunction with the inner replica facility.
Table 1-36 SQL statements that can be executed in conjunction with the inner replica facility
SQL | RDAREA status | ||
---|---|---|---|
Not on online reorganization hold | On online reorganization hold | ||
Definition SQL | ALTER TABLE | C#1 | N |
CREATE INDEX | C#1 | N | |
CREATE TABLE | C#1, #2 | N | |
DROP INDEX | C#1 | N | |
DROP SCHEMA | C#1 | N | |
DROP TABLE | C#1 | N | |
GRANT | C#1 | C#1 | |
Data manipulation SQL | ASSIGN LIST statement | Y | C#1 |
CALL statement | Y | C#1 | |
DELETE statement | Y | C#1 | |
FETCH statement | Y | C#1 | |
INSERT statement | Y | C#1 | |
PURGE TABLE statement | Y | N | |
Single-row SELECT statement | Y | C#1 | |
Dynamic SELECT statement | Y | C#1 | |
UPDATE statement | Y | C#1 | |
Assignment statement | Y | C#1 | |
Control SQL | LOCK statement | Y | C#1 |