Previous Topic

Book Contents

Book Index

Next Topic

DB2

The 'Create Archive Scripts' action is not available for DB2. Archive creation needs to be done by generating DDL scripts using a Valuemation Console template.

  1. Using the following Console template, generate the DDL needed to create the archive schema:

    -- $TABLESANDVIEWS$

    $TABLE.sql.archive$;

  2. Execute the result directly from Valuemation Console:

    $QUALIFIER=<ARCHIVE>;

    <content of the generated DDL>

    Where <ARCHIVE> is the archive schema name. (Replace ARCHIVE with your own schema name as needed.)

    Important: remember to commit the changes after the script is executed (F11)!

See Also

Other Methods

Oracle - Alternative Methods

SQL Server - Alternative Methods