This subsection describes RDMS files.
Files SYS$LIB$*RDMS
alternate-application-group-qualifier*RDMS
Assigned by Exec during first access to an AFCB in this file
Cataloged by SOLAR installation of RDMS or UDS security utility prior to SOLAR installation if a Security Option 3 system
Deleted by SOLAR deinstallation of RDMS
Freed by Exec
Dumped by SOLAR LIBSAVE runstream once after installation
Reloaded by SOLAR LIBLOAD runstream
This file contains the RDMS product Dump Analysis Procedure (DAP) functions and is used during the accessing or updating of relational data.
This file also contains addstreams, which are added during UREP installation to create storage areas, and relational views used by RDMS.
Files SYS$LIB$*RDMS$CFGSCOD
alternate-app-group-qualifier*RDMS$CFGSCOD
Assigned by Exec during first access to the RDMS subsystem in this file
Cataloged by UDS security utility or SOLAR installation of RDMS depending on first need
Deleted by SOLAR deinstallation of RDMS
Freed by Exec
Dumped by SOLAR LIBSAVE runstream once after installation
Reloaded by SOLAR LIBLOAD runstream
This file contains the RDMS and RSA product chameleon subsystems. The file is used during the accessing or updating of relational data.
Files Used Exclusively by Each Application Group
Files SYS$LIB$*RDMS$CFGSDEF
alternate-app-group-qualifier*RDMS$CFGSDEF
Assigned by Exec during first access to the RDMS subsystem in this file
Cataloged by UDS security utility or SOLAR installation of RDMS depending on first need
Deleted by SOLAR deinstallation of RDMS
Freed by Exec
Dumped by SOLAR LIBSAVE runstream once after installation
Reloaded by SOLAR LIBLOAD runstream
This file contains the RDMS and RSA product chameleon subsystem public gates. The file is used during the accessing or updating of relational data.
Files SYS$LIB$*SYS$LIB$*RDMSLIB
alternate-app-group-qualifier*RDMSLIB
Assigned by Exec during first access to an AFCB in this file
Cataloged by SOLAR installation of RDMS or UDS security utility prior to SOLAR installation if a Security Option 3 system
Deleted by SOLAR deinstallation of RDMS
Freed by Exec
Dumped by SOLAR LIBSAVE runstream once after installation
Reloaded by SOLAR LIBLOAD runstream
This file contains the RDMS intercept and connect routine (ICR) absolutes for both basic mode and extended mode. The file is used when accessing or updating relational data.
Files Used Exclusively by Each Application Group
Files SYS$LIB$*RSA
alternate-app-group-qualifier*RSA
Assigned by Exec during first access to an AFCB in this file
Cataloged by SOLAR installation of RDMS or UDS security utility prior to SOLAR installation if a Security Option 3 system
Freed by Exec
Deleted by SOLAR deinstallation of RDMS
Dumped by SOLAR LIBSAVE runstream once after installation
Reloaded by SOLAR LIBLOAD runstream
The RSA component of RDMS responds to subroutine calls in user programs containing relational commands and submits the relational commands to RDMS.
This file is used during the accessing and updating of relational data.
This file also contains the extended mode object module (RSAC-UCSEMOM), which is called by all Universal Compiling System (UCS) programs.
Files application-group-qualifier*ECM$FILE application-group-qualifier*EEAM$FILE application-group-qualifier*FRDT$FILE application-group-qualifier*RDT$FILE
Assigned by UDS when RDMS or UREP is used
Cataloged by UREP during installation
Deleted Never
Freed by UDS Control if no threads are accessing the file and all pages are flushed from memory. Also freed by an IRU DOWN command.
UDS Recovered Status
TRUE
UDS Audited Status TRUE
Dumped by IRU DUMP command
Reloaded by IRU RELOAD command
The ECM$FILE, EEAM$FILE, and FRDT$FILE files are interdependent and must be dumped along with the repository meta-database files and the RDMS files listed below.
The RDT$FILE file is related to RDMS storage areas and the repository meta-database. These files are interdependent and must be dumped and recovered together.
Files Used Exclusively by Each Application Group
This file also contains all RDMS table descriptions and is used during the accessing and updating of relational data.
You must recover this file when you recover the repository meta-database and the following RDMS files: application-group-qualifier*AUTH$FILE application-group-qualifier*DEP$FILE application-group-qualifier*LOB$SA$FILE application-group-qualifier*NULL$FILE application-group-qualifier*PARAMS$FILE application-group-qualifier*PART$FILE application-group-qualifier*RDM$DROPFILE application-group-qualifier*ROUTINE$FILE application-group-qualifier*SCH$FILE application-group-qualifier*STATS$FILE application-group-qualifier*TRIG$FILE application-group-qualifier*TRIGCOL$FILE application-group-qualifier*VIEWDEP$FILE
You must also dump the storage areas that were affected by the SQL CREATE INDEX, DROP INDEX, ALTER TABLE ADD CONSTRAINT UNIQUE, and ALTER TABLE ADD PARTITION commands.
When recovering a storage area of a partitioned table, use the RDMUTL DETACH statement to detach the partition from the table. This can be accomplished either before or after the recovery of the storage area.
After recovering the storage area, use the RDMUTL ATTACH statement to reattach the partition. This process verifies that the storage area is in the proper format.
Files Used Exclusively by Each Application Group Files application-group-qualifier*AUTH$FILE application-group-qualifier*DEP$FILE application-group-qualifier*LOB$SA$FILE application-group-qualifier*NULL$FILE application-group-qualifier*PARAMS$FILE application-group-qualifier*PART$FILE application-group-qualifier*RDM$DROPFILE application-group-qualifier*ROUTINE$FILE application-group-qualifier*SCH$FILE application-group-qualifier*STATS$FILE application-group-qualifier*TRIG$FILE application-group-qualifier*TRIGCOL$FILE application-group-qualifier*VIEWDEP$FILE
Assigned by UDS Control when RDMS or UREP is used
Cataloged by UREP during installation
Deleted Never
Freed by UDS Control when no threads are accessing the file and all pages are flushed from memory. Also freed by an IRU DOWN command.
UDS Recovered Status
TRUE
UDS Audited Status TRUE
Dumped by IRU DUMP command
Reloaded by IRU RELOAD command
The contents of these files are as follows.
File Contents
AUTH$FILE Access authorization information (GRANT and REVOKE
statement information) for RDMS tables that have controlled data access. It is used whenever RDMS accesses a table for which data access control is active. AUTH$FILE is a relational file. The owner of RDMS.AUTHTABLE can view the
authorization records within the table.
DEP$FILE List of all dependent SQL routines (stored procedures and
functions) and triggers for each related table.
LOB$SA$FILE Table RDMS_LOB_STORAGE_AREAS, which contains storage
area names for all BLOB columns.
NULL$FILE Table used internally by RDMS.
PARAMS$FILE Table RDMS_PARAMETERS, which includes a list of parameter
Files Used Exclusively by Each Application Group
File Contents
RDM$DROPFILE Table RDMS_DROPPED_OBJECTS, which contains information
about schema objects either explicitly or implicitly dropped during database and security maintenance operations. ROUTINE$FILE Table RDMS_ROUTINES, which includes a list of all SQL
routines and their attributes (for example, the number of parameters).
SCH$FILE List of schema names that were created.
STATS$FILE Table STATS, which contains table statistics used by the RDMS optimizer if the command SET STATISTICS ON is in effect.
TRIG$FILE Table RDMS_TRIGGERS, which contains a list of triggers and
the SQL routines invoked by them, together with the schema that owns each trigger.
TRIGCOL$FILE Table TRIGGERED_COLUMN, which contains a list of all triggers and columns related to them.
VIEWDEP$FILE Table VIEWDEPS, which lists the dependent views for each relational table. It is updated whenever views are created and dropped. It is used by RDMS for processing the SQL
statements CREATE VIEW, DROP VIEW, ALTER TABLE, DROP TABLE, FUNCTION, PROCEDURE, DROP FUNCTION, DROP PROCEDURE, GRANT, and REVOKE.
All these files are interdependent, so you must recover these files together whenever you recover the repository meta-database and application-group-qualifier*RDT$FILE.
For more information about these tables, see the Relational Database Server for
Files Used Exclusively by Each Application Group