SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

A-57

Considerations—APPENDCANCEL



APPENDCANCEL has the same authorization requirements as the APPEND

command. For more information about authorization requirements for

APPENDCANCEL, see APPEND Command on page A-52. 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.



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 that 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. For more information, see

Considerations—APPENDRESTART on page A-59.



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 processor 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.