beautypg.com

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

background image

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