NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-52
Considerations—APPENDCANCEL
PARTONLY
You must use the PARTONLY option if PARTONLY was specified in the original
APPEND command from which this APPENDCANCEL command is recovering.
Considerations—APPENDCANCEL
•
Authorization requirements
APPENDCANCEL has the same authorization requirements as the APPEND
command. See APPEND Command
on page A-47 for more information about
authorization requirements for APPENDCANCEL.
•
APPENDCANCEL operations
APPENDCANCEL verifies that the information in recovery-file accurately
describes the target table (or partition). Using the information in recovery-file,
APPENDCANCEL restores the target table to the state it was in before the
APPEND operation began.
After the APPENDCANCEL operation finishes, the target table or partition is
accessible to applications again.
Suppose an APPEND operation finishes appending data to the target table and is
interrupted at the end of the operation, when it is clearing the corrupt flags. In this
case, you cannot use the APPENDCANCEL command to recover from the
interrupted APPEND operation. (After the APPEND operation has begun clearing
corrupt flags, the target table cannot safely be restored to its original state.) In this
situation, the APPENDCANCEL command returns an error 9179 and has no effect;
use the APPENDRESTART command instead. See Considerations—
APPENDRESTART on page A-53 for more information.
•
Recovery files and APPENDCANCEL
The APPEND operation creates a recovery file specified by recovery-file.
During normal operation, the APPEND utility purges recovery-file after it
successfully finishes adding data to the end of the target table.
However, if a CPU or process failure interrupts the APPEND operation,
recovery-file is not purged and should continue to exist and be available for
APPENDCANCEL. One exception is if APPEND is interrupted at the end of the
operation as described under the previous item. Another is if the interruption occurs
early in the APPEND operation, before APPEND finishes creating recovery-
file. In that case, you cannot use APPENDCANCEL to recover from the failure.
If APPENDCANCEL returns error 9182, indicating it cannot complete its operation
because the original APPEND did not complete the recovery-file, you should
purge the partial recovery-file. Do NOT purge a recovery-file unless an
error 9182 is generated to indicated that the recover-file was not completed by the
original APPEND.