SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual427720-006
11-60
SQL 9216
Cause. An error occurred in mapping names. The target and source might have the
same name, or the collation name was not specified in MAP NAMES.
Effect. The collation object is not duplicated.
Recovery. Correct the name mapping errors and reissue the request.
SQL 9217
Cause. A utility command specified an operation that is not allowed on an OSS file.
Effect. If a fileset list contains an OSS file, that file is skipped. If an OSS file is
specified as any other parameter, the entire command is terminated.
Recovery. Remove any OSS file names from the fileset list and from all command
parameters, and then reissue the command.
SQL 9128
Cause. The object could not be used because either the unreclaimed freespace or
incomplete SQLDDL file attributes were turned on. The unreclaimed freespace
attribute is set when an ALTER TABLE or ALTER INDEX request has completed and
data still needs to be deleted through a call to FUP RELOAD. The Incomplete SQLDDL
attribute is set while an ALTER TABLE or ALTER INDEX request is running, or when a
previous ALTER TABLE or ALTER INDEX request failed without cleaning up properly.
Effect. The operation fails.
Recovery. Perform a SQL FILEINFO request to see what is wrong with the object. If a
“D” is listed, the incomplete SQLDDL attribute is set. If an “F” is listed, the unreclaimed
freespace attribute is set.
For an incomplete SQLDDL operation, wait until the ALTER operation completes and
reenter the DUP command. If there is no ALTER operation in progress, run an ALTER
[TABLE|INDEX] name PARTONLY RECOVER INCOMPLETE SQLDDL OPERATION
to complete the previously failed Alter operation and rerun the DUP request.
For unreclaimed freespace, run a FUP RELOAD operation before reissuing the DUP
request.
9216 Unable to value-1. DUP of collation object value-2
failed because of mapping error.
9217 The requested operation is not allowed on an OSS file.
9218 Unable to perform the requested operation on value-1
because it either has unreclaimed freespace or a SQLDDL
operation has not completed.