Releasing a Savepoint

Releasing a savepoint frees up the version pages that have been used up to that savepoint.

Data is versioned internally at the page level. SAP Sybase IQ maintains a separate copy of only the updated pages; the remaining pages are shared with the previous version.

Releasing savepoints makes better use of your disk space.

This Interactive SQL command releases savepoint n:
RELEASE SAVEPOINT n

All resources after the savepoint are released, and you cannot roll back to any intermediate savepoints.

RELEASE SAVEPOINT does not release locks.