NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-64
DROP SYSTEM CATALOG Command
DROP SYSTEM CATALOG Command
DROP SYSTEM CATALOG is an SQLCI command that allows the local super ID to
delete the system catalog, including the CATALOGS table and information about the
SQLCI2 program.
catalog-name
identifies the system catalog to be dropped; catalog-name is the name of the
volume and subvolume that contain the system catalog (or an equivalent DEFINE).
If ServerWare SMF is installed on your node, the system catalog must have either a
virtual or direct name.
Considerations—DROP SYSTEM CATALOG
•
To drop the system catalog, you must use the local super ID.
•
The system catalog must be empty except for the system catalog entry in the
CATALOGS table and entries for the catalog tables and the SQLCI2 program. The
system catalog must be the only catalog registered in the CATALOGS table. You
must drop all other objects, programs, and catalogs before executing this command.
•
If you are running SQLCI and have not entered any SQLCI commands during the
current session, you can drop the system catalog by entering the following command
at the SQLCI prompt:
>> DROP SYSTEM CATALOG catalog-name;
You cannot enter the DROP SYSTEM CATALOG command, however, while the
SQLCI2 program is running, as it normally is after you enter a command during the
current SQLCI session. If you attempt to enter the DROP SYSTEM CATALOG
command while SQLCI2 is running, the command terminates abnormally and an
error message appears.
To enter the command correctly, you can use either of two methods:
°
Exit from SQLCI. Then restart SQLCI and enter the DROP SYSTEM
CATALOG command at the first SQLCI prompt, as follows:
30> SQLCI
>> DROP SYSTEM CATALOG catalog-name;
°
Enter the DROP SYSTEM CATALOG command at the TACL prompt, as
follows:
31> SQLCI DROP SYSTEM CATALOG catalog-name;
DROP SYSTEM CATALOG catalog-name ;