SQL/MP Installation and Management Guide

Planning Database Security and Recovery
HP NonStop SQL/MP Installation and Management Guide—523353-004
4-25
Using OBEY Command Files for Recovery
Another recovery method is to maintain EDIT files that contain database creation
statements and commands for re-creating your database. When you first create the
database, you should record the statements and commands in EDIT files. These EDIT
files are called OBEY command files because you can use the OBEY command
through SQLCI to run part or all the statements and commands in the files. OBEY
command files provide both a simple method for entering the detailed database
creation statements and commands and a method for backing up table, view, and
index definitions.
Whenever you enter a DDL statement, the active data dictionary changes. You should
always use the SQLCI logging facility when you make database changes, additions, or
deletions. Keep the log file for your records. If you need to determine valid definitions,
your original command file and a log of the changes can assist you in reconstructing
data definitions.
You can use your recovery command files to re-create a database on the same system
or on another system. You can also use these files as a verification point for the
correctness of the catalog descriptions if the data dictionary changes inadvertently.