Unconditional Supplemental Groups
ALTER TABLE nydata1.allinsured
ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY)
COLUMNS;
To specify an unconditional supplemental
log group that includes all columns for a table, use an ALTER
TABLE statement with the ALL option in the ADD SUPPLEMENTAL LOG
DATA clause. The log group will have a system-generated name.
For example, to add all the columns of the NYDATA1.ALLINSURED
table to an unconditional log group use the statement:
ALTER TABLE nydata1.allinsured
ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
To specify an unconditional supplemental
log group that contains columns that are selected by the DBA,
use an ALTER TABLE statement with the ALWAYS specification.
These log groups may also include key columns, if needed. For
example, to add the POL_NO and SALESID column of the
NYDATA1.ALLINSURED table to an unconditional log group named
log_group_pol_salesid use the following statement:
ALTER TABLE nydata1.allinsured
ADD SUPPLEMENTAL LOG GROUP
log_group_pol_salesid
(pol_no , salesid ) ALWAYS;
