SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-36
Using the RESTORE SHOWDDL ON Option to Re-
Create Objects
For detailed information about backing up and restoring OSS objects, see the Backup
and Restore 2 Manual.
Using the RESTORE SHOWDDL ON Option to Re-Create Objects
Every backup operation captures the DDL from all SQL/MX CREATE statements that
have been executed. This capture always occurs; there is no backup job option to
prevent it.
When the SHOWDDL option of the RESTORE command is turned ON (the default is
OFF), the restore operation automatically generates an OSS EDIT file that
corresponds to each CREATE statement that has been executed. The information that
is used to generate OSS EDIT files during the restore operation is collected during the
backup operation.
OSS EDIT files can be edited and used as MXCI OBEY command files to regenerate
these SQX/MX objects that Backup and Restore 2 does not restore:
•
REFERENTIAL INTEGRITY constraints
•
SPJs
•
Triggers
•
Views
The formats for naming OSS EDIT files generated by SHOWDDL are:
In the file name, the number after SHOWDDL identifies the number of OSS EDIT files
that have been created for those objects. For example, when the first file,
SHOWDDL1_Stored_Procedures, is full, Backup and Restore 2 generates a new file
with the number 2, SHOWDDL2_Stored_Procedures, into which it places the
remaining SHOWDDL information. This process of creating new OSS EDIT files
continues until all SHOWDDL information for those objects has been written to disk.
The OSS EDIT files are overwritten with every new execution of Backup and Restore 2
where the SHOWDDL option is set to ON, and the same location for the files is
specified.
SHOWDDL File Name For Object Type
SHOWDDL1_RI_Constraints REFERENTIAL INTEGRITY
constraint
SHOWDDL1_Stored_Procedures SPJ
SHOWDDL1_Triggers Trigger
SHOWDDL1_Views View