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-35
Backing Up and Restoring OSS Program Files and
SPJs
Backing Up and Restoring OSS Program Files and SPJs
Backing Up and Restoring Program Executables and User
Modules
Program executables and user modules in the SQL/MX environment are stored in OSS
directories. To back up these files, use OSS backup objects to specify their OSS
directory locations:
BR> BACKUP $tape-drive, OSS (/usr/embedsqlprogs,
/usr/embedsqlcbl, /usr/javaclasses,
/usr/tandem/sqlmx/USERMODULES);
To restore program executables and user modules, use OSS restore objects to specify
the original OSS directory locations and optional target locations under which the
original directories are restored:
BR> RESTORE $tape-drive, OSS (/usr/embedsqlprogs, TARGET
/newdir), (/usr/embedsqlcbl, TGT /newdir), /usr/javaclasses,
/usr/tandem/sqlmx/USERMODULES);
For detailed information about backing up and restoring OSS objects, see the Backup
and Restore 2 Manual.
Backing Up and Restoring SPJ Metadata Information
Information about an SPJ is stored in the SQL/MX metadata tables. When you back up
a catalog or schema, Backup and Restore 2 automatically backs up the SQL/MX
metadata for all SPJs in the catalog or schema.
Backup and Restore 2 does not automatically restore SPJ metadata information. To
restore it, run the OBEY command file for the SPJ generated by the RESTORE
SHOWDDL ON command. For more information, see Using the RESTORE
SHOWDDL ON Option to Re-Create Objects on page 5-36.
Backing Up and Restoring SPJ Class or JAR Files
An SPJ consists of a Java method within a Java class or JAR file stored in an OSS
directory. To back up class or JAR files, use OSS backup objects to specify their OSS
directory locations:
BR> BACKUP $tape-drive, OSS (/usr/jarfiles, /usr/spjclasses);
To restore class or JAR files, use OSS restore objects to specify the original OSS
directory locations and optional target locations under which the original directories are
restored:
BR> RESTORE $tape-drive, OSS ((/usr/jarfiles, TARGET /newdir),
(/usr/spjclasses, TGT /newdir));