SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-67
SQL 1407
Cause. The CATALOGS table corresponding to this system either does not exist or
the disk on which the CATALOGS table resides is not operating.
Effect. The CREATE CATALOG or DROP CATALOG statement fails.
Recovery. If the disk is not operating, use PUP and TMFCOM to bring the disk up,
issue an ENABLE VOLUMES command from TMFCOM, and reissue the command. If
the table does not exist, create the CATALOGS table by entering CREATE SYSTEM
CATALOG from SQLCI.
SQL 1408
Cause. Stated in the error message.
Effect. The command fails.
Recovery. Drop the other catalogs, or specify the system catalog.
SQL 1409
Cause. DROP PARTITION can be performed only on a partition that is not the primary
partition.
Effect. The statement fails.
Recovery. Correct the statement. For a partitioned table, verify that the object name
identifies a partition that is not the primary partition.
SQL 1410
Cause. The view text stored in the VIEWS table cannot be updated to reflect the
change required in the operation.
Effect. The statement fails.
1407 The CATALOGS table corresponding to this system is not
available.
1408 The named catalog is not a system catalog, or the
CATALOGS table must be empty except for the entry describing
the system catalog.
1409 DROP PARTITION cannot be performed against the primary
partition of a partitioned table.
1410 The object name stored in the view text cannot be
changed in a DROP or RENAME operation.