Hp Integrity NonStop J-Series Bedienungsanleitung PDF herunterladen (Seite 88)

Table 26 (page 88) describes the options.

Table 26 Options in the Control Table Statements tab

DescriptionValue

Specifies name of the table.Name

Determines the result if you attempt to access data with read committed or if you serialize access,

and the data is locked by another user.

If-Locked

Specifies whether to use Multi-dimensional Access Method (MDAM) for subsequently compiled DML

statements that access the index.

MDAM

Specifies the priority for subsequent file system requests to MDAM. MDAM uses the priority to ensure

efficient performance in a mixed workload environment.

Priority

Specifies whether to perform similarity checks for new and previous tables to avoid statement

recompilation. This option applies only to tables. It does not apply to views.

Similarity Check

Determines whether to use table locks for subsequently compiled DML statements that access the

table or view.

Table Lock

Specifies the amount of time allowed to complete file-system requests from the DML operations. If the

time elapses before the file system can grant a request to lock data, the DML statement fails and

SQL/MX returns an error.

Timeout

NOTE: This timeout applies to static operations only.

If-Locked

DescriptionValue

Specifies the value used is the system default setting that exists at the time of execution.<Not Set>

Returns the file-system error 73. For more information on file-system errors, see the HP NonStop SQL/MX

Release 3.2 Messages Manual.

Return

Indicates that SQL/MX waits for another user to release the lock, until the timeout period elapses.Wait

MDAM

DescriptionValue

The value used is the system default setting that exists at execution.<Not Set>

SQL/MX determines whether to use MDAM.Enable

MDAM is not used.Off

MDAM is used.On

Priority

The possible values are 1 through 9, where 9 is the highest value. You can specify a higher priority

for short-duration OLTP-type requests running with concurrent long-duration query requests.

CAUTION: Using the highest possible value (9) can interfere with SQL/MX system-level activity.

88 Managing MXCS objects

1 2 ... 83 84 85 86 87 88 89 90 91 92 93 ... 109 110

Keine Kommentare

Hp Integrity NonStop J-Series Bedienungsanleitung Seite 88