SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Utility Messages (20000 through 23099)
HP NonStop SQL/MX Messages Manual—523730-004
17-68
SQL 20293
Cause. The partition that you specified in the partition management request contains
data, and the specified base table is referenced by another base table via a referential
integrity constraint. The REUSE operation is not allowed on such a partition.
Effect. The operation fails.
Recovery. None.
SQL 20294
Cause. The partition that you specified in the partition management request contains
data, and the specified base table has an enabled DELETE trigger. The REUSE
operation is not allowed on such a partition.
Effect. The MODIFY utility operation fails.
Recovery. Disable all triggers on the table and retry the REUSE operation.
SQL 20295
Where file-name-list is the list of Guardian file names of partitions that might
need reloading. The names are separated by blanks.
Cause. The MODIFY utility has completed, but it failed to start ORSERV (the FUP
RELOAD operation) successfully. The failures are reported in separate error
messages. If the failures were caused by the MODIFY process being killed
inadvertently, the warning message is issued by the RECOVER utility during the
recovery.
Effect. The MODIFY utility completed the request, but the specified partitions might
not have been reloaded. Therefore, their D flag (INCOMPLETE SQLDDL
OPERATION), F flag (UNRECLAIMED FREE SPACE), or both flags might still be set,
and no subsequent DDL commands or utilities can operate on the partitions.
Recovery. Run FUP RELOAD manually to reclaim free space on the specified
partitions if the D or F flag is present for the partitions. Use the FUP INFO or
SHOWLABEL utility to see if the D or F flag is set.
20293 The partition cannot be reused because the partition
contains data and the specified table is referenced by
another table.
20294 The partition cannot be reused because the partition
contains data and the table has an enabled DELETE trigger.
20295 The MODIFY request has completed successfully, but
ORSERV failed. Please run FUP RELOAD manually to reclaim any
free space on file-name-list.