SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
W-5
Considerations—WITH SHARED ACCESS
COMMIT WHEN READY
TIMEOUT DEFAULT ONCOMMITERROR ROLLBACK WORK
For more information, see COMMIT Option on page C-52.
Considerations—WITH SHARED ACCESS

Restrictions

You cannot use WITH SHARED ACCESS on a statement that executes within
a user-defined TMF transaction.

You cannot use WITH SHARED ACCESS unless each source object (for
example, the table being indexed by CREATE INDEX or the partition being
moved by ALTER INDEX or ALTER TABLE) in the operation is audited.

You cannot use WITH SHARED ACCESS for an ALTER TABLE or ALTER
INDEX statement unless each source object and each target object (for
example, the new location of a partition being moved by ALTER INDEX or
ALTER TABLE) in the operation resides on a node running version 315 or later
of NonStop SQL/MP.

You cannot use WITH SHARED ACCESS on a statement that performs
cross-node operations, where the TMF on one node provides Format 2 audit
trail file support, and the TMF on the other node provides only Format 1 audit
trail file support.

TMF audit trail requirements
An operation that uses WITH SHARED ACCESS cannot complete successfully
unless the TMF audit trail generated during the operation is available for reading
later in the operation. If a required audit trail has been overwritten, a WITH
SHARED ACCESS operation cancels changes made to the database and
terminates.
When performed on a source object that has a valid TMF online dump, an
operation that uses WITH SHARED ACCESS generates audit information for the
target object. The target might not audit to the same audit trail as the source.
Lengthy operations that use WITH SHARED ACCESS might require an operator to
mount tapes of previously taken TMF audit dumps. Requests to mount TMF audit
dump tapes for WITH SHARED ACCESS operations are not distinguishable from
other requests to mount TMF audit dump tapes. Such requests are generally sent
to an operator's console. SQL does not return information about such requests to
the terminal or process that started the operation.

Phases of a WITH SHARED ACCESS operation
An operation specified by a statement that includes the WITH SHARED ACCESS
option occurs in these phases: