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.
- Using the following Console template, generate the DDL needed to create the archive schema:
-- $TABLESANDVIEWS$
$TABLE.sql.archive$;
- 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)!
|