Neoview Control Query Default (CQD) Reference Guide (R2.5)

Neoview Release 2.4Introduced in release
Not applicableDeprecated in release
SAVE_DROPPED_TABLE_DDL
Operational controlsCategory
Saves DDL text, with the actual partition file names and other details, to be able to recreate
dropped tables in order to recover them at a later time. It only applies when dropping
tables. DDL text is not saved if that table is dropped as part of:
• A DROP SCHEMA command
• Running in cleanup mode
• A TRANSFORM operation
Or if the table being dropped is a volatile table.
Description
DDL text is saved when a table is dropped‘ON’
DDL text is not saved when a table is dropped‘OFF’
The default value is ‘ON’.
Values
When turned on, the DDL text is stored in an OSS directory. Your HP representative can
then use this text when a dropped table needs to be recovered. The recovery process needs
the exact partition file names for the dropped table. If the table has been dropped multiple
times, the appropriate DDL file can be used to recreate the table for recovery.
The motivation to turn this off is if a dropped table recovery is never desired and you
would rather not have these files clutter the disk space. There is no clean up utility to clean
up files older than the last online dump that may be available for recovery. However, these
files are very small and would not use up a lot of space.
This setting could be turned off in development, test, and QA systems where there is a lot
of drop activity, with no need for recovery of dropped objects, often with no online dumps
being taken to facilitate such recovery.
Usage
Set this CQD to OFF on development, test, and QA systems but should not be turned off
in production.
Production usage
If turned on, the OSS directory /usr/tandem/sqlmx/ddl and needs to be monitored and files
older than the last online dump available for recovery manually removed. Otherwise the
directory could fill up and prevent the ability to drop tables.
Customers do not have access to this directory. Your HP representative can assist with
cleanup or providing a script that you can run.
Impact
SystemLevel
Not applicableConflicts/Synergies
Not applicableAddressing the real
problem
Neoview Release 1.0Introduced in release
Not applicableDeprecated in release
62 Miscellaneous