SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-82
Table Management
SAVE_DROPPED_TABLE
_DDL
Controls whether definitions of dropped tables are saved to
enable them to be recovered.
If set to ON, DDL information for a dropped table is saved to a
file called catalog.schema.tablename-yyyymmdd-
timestamp.ddl in the OSS directory /usr/tandem/sqlmx/ddl.
For example, if a table called CAT.SCH.T123 is dropped at
12:53:31 PM on July 29, 2003, the full OSS path name of the
saved DDL file would be:
/usr/tandem/sqlmx/ddl/CAT.SCH.T123-20030729-
125331.ddl
To drop the table you must have write access to this directory
or you receive error 1232:
*** ERROR[1232] A file error occurred when saving dropped
table DDL for table table to /usr/tandem/sqlmx/ddl.
If the table name contains a delimited identifier, characters that
are not permitted in OSS file names are replaced by
underscores. Quotes delimiting the identifier are removed.
For example, if the table CAT."S&C%H"."T*A*B?01" is dropped
at 12:57:15 am on April 24, 2003, the saved DDL file would be:
/usr/tandem/sqlmx/ddl/CAT.S_C_H.T_A_B_01-
20030424-215715.ddl
If the 3-part ANSI name exceeds the maximum OSS file name
length of 248, it is truncated to 248 characters.
Despite similarities in the resulting file names because of
character replacement or file name truncation, the files are
always distinguishable by the trailing timestamp portion of the
name and the contents of the file, which always indicates the
full ANSI name of the table.
NonStop SQL/MX does not remove saved DDL files. You must
remove unwanted files from this location. If you do not
periodically remove these files, the OSS directory will become
full and DROP TABLE will no longer succeed. Database
administrators should monitor the saved DDL location
/usr/tandem/sqlmx/ddl for the accumulation of unneeded files.
Here is an example of a script that will delete DDL files every
seven days:
find /usr/tandem/sqlmx/ddl -mtime +7
-print | grep "/ddl/" | sed "s/./rm &/"
| sh
In development and testing environments where tables are
frequently created and dropped it is recommended that this
value be set to OFF.
The default is ON.
Attribute Setting