DDL missing ENABLE ARCHIVE

Products

• RC Compare for DB2 for z/OS

Issue/Introduction

The line command DDL for table DB2ADM.MYTABLE does not generate

ALTER TABLE DB2ADM.MYTABLE

ENABLE ARCHIVE USE DB2ADM.MYARCHIVE

 However, when using HDDL this statement is generated

Environment

Release:
Component: RCQ

Resolution

This is expected behavior. The ENABLE ARCHIVE statement is generated in the DDL of the archive table, in this case DB2ADM.MYARCHIVE, and not on the DDL of the original (archive-enabled) table, DB2ADM.MYTABLE.

 Since HDDL will generate DDL for both tables the ALTER TABLE .. ENABLE ARCHIVE is generated for the archive table.

Additional Information

Use line command D (detail) to display creator/name of ARCHIVING TABLE