Understand the warning information, Compiler statistics – HP Neoview Release 2.5 Software User Manual

Page 203

Advertising
background image

Description

Field

Group Box

The total time that the query ran or is running (that is, the elapsed time),
plus any time that the query spent in the waiting, holding, or suspended
state. The display format is hhh:mm:ss for hours, minutes, and seconds.

Total Query Time

Warning level that is set for the query:

NOWARN (green)
LOW (yellow)
MEDIUM (orange)
HIGH (red)

Click View for more details. See

“Understand the Warning Information”

(page 203)

.

Warn Level

Warn Level

Understand the Warning Information

Description

Field

Query identifier

Query ID

Name of the WMS service

Service Name

CONN for a connection rule
COMP for a compilation rule
EXEC for an execution rule

Warn Type

LOW, MEDIUM, or HIGH

Warn Level

Name of the rule that triggered the warning

Rule Name

Expression number in the rule, corresponding to the ordinal position of the expression
for an OR operator or the total number of expressions for an AND operator

Expr

Rule expression that triggered the warning

Reason

Compiler Statistics

Description

Field

Group Box

Name of the WMS service

Service

Info

Name of the master process of the query

Process

Internal name of the query containing the client host name concatenated
with the application name

Query

Name of the application that initiated the query

Application

Client host name

Computer

Name of the Neoview role associated with the query (that is, the role
of the user who is running the query)

Role

Name of the user connected to the Neoview platform

User

Name of the data source for the connection

DataSource

The time when the query was submitted into the Neoview system. The
display format is yyyy-mm-dd (for year, month, and day) and
hh

:mm:ss.ssssss (for hours, minutes, and seconds).

Start

Unique identifier to indicate when the query entered the Neoview
system. The display format is yyyy-mm-dd (for year, month, and day)
and hh:mm:ss.ssssss (for hours, minutes, and seconds).

Entry

Estimated cost of the query

Cost

Estimate

Use the Workload Detail Dialog Box

203

Advertising