Select this radio button to specify that the target
table is read-only. If you select this radio button, you must select
one the following read-only target types:
- User copy
- Contains a snapshot of the table when copied without the IBMSNAP_LOGMARKER
column, which differentiates it from a point-in-time table. This choice
is the default and must have a primary key.
- Point-in-time
- A complete, condensed copy of the source table, which must have a primary
key. Contains a snapshot of the table when copied with the
IBMSNAP_LOGMARKER column.
- Staging table
- Can be used as a source for further copies, supports a consistent data
environment, provides flexibility in data distribution across a network, and
becomes the source for a copy operation. If you select this target
type, you can optionally append unit-of-work table columns
(ASN.IBMSNAP_UOW) to the target table by selecting the Unit of
Work (UOW) table columns check box. You can also use a staging
table as a source for future copies.
- Base aggregate
- A history table in which a new row is appended for each changed row in the
source table resulting in an SQL column function calculation against the
existing user table. Contains data aggregated directly from a source
table or point-in-time table at intervals.
- Change aggregate
- A history table in which a new row is appended for each changed row in the
source table resulting in an SQL column function calculation against only
recent change data. Contains data aggregations based on changes
recorded for a source table.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]