SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
W-8
Example—WITH SHARED ACCESS
cause far less application downtime than equivalent operations without WITH
SHARED ACCESS.
The duration of a WITH SHARED ACCESS operation increases with the number
and length of transactions on the node that contains the source partition,
particularly with the number and length of transactions that involve the source
partition and the amount of activity on the audit trail used for the source partition.
Example—WITH SHARED ACCESS
The command CREATE INDEX uses the WITH SHARED ACCESS option:
CREATE INDEX EMPLOYE2
ON EMPLOYEE (JOBCODE) CATALOG PERSNL
WITH SHARED ACCESS NAME CR_IND_EMP2
COMMIT WHEN READY TIMEOUT NEVER;