Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 130)

Table E-8 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

ANSI Timestamp indicating when the

Workload Management Services

received the most recent runtime

statistics from the Query Executor.

TIMESTAMP(6) NO DEFAULTREFRESH_TS

Repository-generated ANSI

Timestamp showing when this row

was last updated. You can use this

value to monitor whether the query is

still running.

TIMESTAMP(6) NO DEFAULTLAST_UPDATE_TS

ANSI Timestamp, in Local Civil Time,

indicating when query compilation

began. If this information is initially

unavailable, it is assigned the value

NULL and later updated with the

correct value. This field is updated

whenever the Repository updates the

statistics.

TIMESTAMP(6) NO DEFAULTCOMPILE_START_TS

ANSI Timestamp, in Local Civil Time,

indicating when query compilation

ended. If this information is initially

unavailable, it is assigned the value

NULL and later updated with the

correct value. This field is updated

whenever the Repository updates the

statistics.

TIMESTAMP(6) NO DEFAULTCOMPILE_END_TS

ANSI Timestamp, in Local Civil Time,

indicating when query execution

began. If the query has not yet begun

execution, the value is NULL.

TIMESTAMP(6) NO DEFAULTEXEC_START_TS

ANSI Timestamp indicating when

query execution ended, converted to

LCT from UTC. If the query has not

yet begun execution, the value is

NULL.

TIMESTAMP(6) NO DEFAULTEXEC_END_TS

1 Total memory used by a query in the sum: “SQL Space Used” + “SQL Heap Used” + “EID Space Used” + “EID Heap

Used”. This value changes during the lifetime of a query.

130 Pre-R2.5 Query Statistics Views

1 2 ... 125 126 127 128 129 130 131 132 133 134 135 ... 141 142

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 130

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.5 Software