Priority option of controlled tables tab, Similarity check option of controlled tables tab, Table lock option of controlled tables tab – HP Neoview Release 2.5 Software User Manual
Page 150: Timeout option of controlled tables tab, Copy a data source, Priority, Similarity check, Table lock, Timeout
Priority Option of Controlled Tables Tab
Possible values are 1 through 9. Specify a higher priority for short-duration OLTP-type requests
running with concurrent long-duration query requests.
NOTE:
Using the highest possible value (9) can interfere with Neoview SQL system-level
activity.
Similarity Check Option of Controlled Tables Tab
Description
Value
The value used is the system default setting that exists at execution time.
Neoview SQL recompiles the statement at run time, depending on the outcome of late name resolution,
timestamp comparison, or table redefinition.
Off
Neoview SQL performs similarity checks at run time to determine whether the new table is similar
to the previous table. If similar, Neoview SQL uses the table without recompilation. Otherwise, the
SQL statement is recompiled with the new table name. This is the default.
On
Table Lock Option of Controlled Tables Tab
Description
Value
The value used is the system default setting that exists at execution time.
Neoview SQL decides whether to use table locks for the specified table or view.
Enable
Do not use table locks.
Off
Use table locks.
On
Timeout Option of Controlled Tables Tab
Description
Option
The value used is the system default setting that exists at execution time.
No timeout is specified.
No Timeout
Do not wait for a table lock. If the lock cannot be acquired, Neoview SQL returns an error.
Will Not
Wait
1 though 2147483519 hundredths of a second.
Interval
Copy a Data Source
Requirement: Only roles that have OPERATOR privileges can perform management tasks.
If you need 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 allows you to modify the copy as needed.
To make a copy of an existing data source:
1.
Under the navigation tree pane, click the Connectivity area.
2.
Under My Systems, expand the tree for the Neoview platform for which you want to create
a data source until you can see the Data Sources heading and the data source names under
the heading.
3.
In the navigation tree pane, right-click the data source that you want to copy and select
Create New Data Source Like
. The Create New Data Source window appears.
150
Manage Data Sources