NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
W-5
Considerations—WITH SHARED ACCESS
{ COMMIT [WORK] commit-options }
{ ROLLBACK [WORK] }
specifies the start time, the timeout period for lock requests, and the handling of
retryable errors for the commit phase of the operation. The default is the following:
COMMIT WHEN READY
TIMEOUT DEFAULT ONCOMMITERROR ROLLBACK WORK
See COMMIT Option on page C-46 for more information.
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.
•
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 the following phases:
1. Initialization and load phase