HP Integrity NonStop J-Series - Manual (Page 92)

MDAM
Description Value
The value used is the system default setting that exists at execution.
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.
Similarity check
Description Value
The value used is the system default setting that exists at execution.
SQL/MX recompiles the statement at run time, depending on the outcome of late name resolution,
timestamp comparison, or table redefinition. Off
SQL/MX performs similarity checks at run time to determine whether the new table is similar to the
previous table. If similar, SQL/MX uses the table without recompilation. Otherwise, the SQL statement
is recompiled with the new table name. This setting is the default. On
Table Lock
Description Value
The value used is the system default setting that exists at execution.
This value indicates whether to use table locks for the specified table or view. Enable
Table locks are not used. Off
Table locks are used. On
Timeout
Description Value
The value used is the system default setting that exists at execution.
No timeout is specified. No Timeout
Does not wait for a table lock. If the lock cannot be acquired, SQL/MX returns an error. Will Not Wait
1 through 2147483519 in hundredths of a second. Interval
Copying a data source
If you want to create a data source that is similar to an already-configured data source, you can
use the configured data source as a template for the new data source. This procedure makes a
copy of an existing data source configuration and enables you to modify the copy as needed.
To make a copy of an existing data source:
1.
Log on to the HP NonStop SQL/MX Database Manager.
92 Managing MXCS objects