beautypg.com

User_name field increased to 128 characters, Summary of changes for repository 2.4 – HP Neoview Release 2.4 Software User Manual

Page 119

background image

Table D-1 Fields Not Available in Repository 2.4 SP1 Views ODBC_QUERY_STATS_V1,

ODBC_QUERY_STATS_V2, and QUERY_RUNTIME_STATS_V1 (continued)

Field Unavailable in
QUERY_RUNTIME_STATS_V1

Field Unavailable in
ODBC_QUERY_STATS_V2

Field Unavailable in
ODBC_QUERY_STATS_V1

LAG_ELAPSED_TIME

UTC_BIAS

METRIC_CLASS_ID

METRIC_CLASS_VERSION

METRIC_CTRL

QUERY_INDEX

SERVICE_INDEX

USER_ID

NUM_ESPS_GT_THRESHOLD

NUM_CHILD_ESPS

NUM_SUSPENDED_ESPS

QUE_TIME

STATS_BYTES

MASTER_EXEC_BUSY_TIME

REPOSITORY_QUERY_STATUS

REFRESH_TS

USER_NAME Field Increased to 128 Characters

The following table shows the view names affected by the data type increase for the USER_NAME
field:

New Data Type

Field Name

View Names

CHAR(128)

USER_NAME

ODBC_QUERY_STATS_V1

CHAR(128)

USER_NAME

ODBC_QUERY_STATS_V2

CHAR(128)

USER_NAME

QUERY_RUNTIME_STATS_V1

CHAR(128)

USER_NAME

ODBC_QUERY_STATS_V1_2400

CHAR(128)

USER_NAME

ODBC_QUERY_STATS_V2_2400

CHAR(128)

USER_NAME

QUERY_RUNTIME_STATS_V1_2400

Summary of Changes for Repository 2.4

No field definition changes were made between Repository 2.4 and Repository 2.3.
The R2.4 edition of this manual includes the following new and changed information:

Clarify and correct text related to space and heap.

Miscellaneous other corrections and clarifications.

Summary of Field Definition Changes for Repository 2.3

This section describes field definition changes between Repository 2.2 and Repository 2.3.

Summary of Changes for Repository 2.4

119