SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-54
SQL 9178
Cause. You entered an APPENDRESTART command to complete an APPEND that
had been interrupted, but the contents of the source file were changed sometime after
that original APPEND started. APPENDRESTART requires that the source file must
contain the same data as was there for the original APPEND command.
Effect. The command fails. The target is not modified.
Recovery. If the source file was changed unintentionally, and if you have a backup of
it, put it back to its original condition in a way that restores its original timestamp. If you
want to use the modified data in the source file, first cancel the original APPEND with
the APPENDCANCEL command, and then start a new APPEND command.
SQL 9179
Cause. You entered an APPENDCANCEL command to cancel an APPEND that had
been interrupted, but the original APPEND command had reached the point of clearing
the corrupt flags on the target before it was interrupted. Once APPEND starts clearing
the corrupt flags, it is not possible to cancel the operation; it must be completed using
APPENDRESTART.
Effect. The command fails. The target is not modified.
Recovery. Use APPENDRESTART to complete the interrupted APPEND.
SQL 9180
Cause. You may have misspelled the recovery file name, or you may have tried to
restart an APPEND that had completed. If neither of those are the case, you might
have entered an APPENDRESTART command to complete an APPEND that had been
interrupted, but the original APPEND command was interrupted before it created the
recovery file or before it had finished writing the recovery information to the file.
Effect. The command fails. The target is not modified.
Recovery. If the original APPEND had completed, no recovery is needed. If the
problem was incorrect spelling of the recovery file name, correct the spelling and retry
the command. Otherwise, use an APPEND command to start the APPEND again.
9178 The source file has been modified since the original
APPEND started. Its original modification timestamp was
value-1, its current modification timestamp is value-2.
9179 APPENDCANCEL cannot cancel this APPEND because the
original APPEND had already started clearing the corrupt
flags from the target.
9180 The recovery file specified in the APPENDRESTART command
does not exist or does not contain complete recovery data.