beautypg.com

HP Neoview Release 2.3 Software User Manual

Page 62

background image

The list following the query shows values that might be returned in a single record.

select [first 10] *
from NEO.HP_METRICS.ODBC_QUERY_STATS_V2
where STATEMENT_STATE = ’COMPLETE’
ORDER BY QUERY_START_DATETIME DESC
FOR READ UNCOMMITTED ACCESS;

Value

Field

\NEO0102

“SEGMENT_NAME”

2

"SEGMENT_ID"

1

"NODE_ID"

653

"PIN"

148

"START_PRIORITY"

\NEO0102.$Z2YK

“PROCESS_NAME”

"MXID01001000882212041585284557791000000000509SUPER.SERVICES00"

"SESSION_ID"

"511 "

"USER_ID"

"ROLE.DBA "

"USER_NAME"

"ORDCLOVISRBTS-P2"

"CLIENT_ID"

"ODBC Test (ANSI) "

"APPLICATION_ID"

"neo0102_clo"

"DATASOURCE"

"MXID01001000882212041585284557791000000000509SUPER.SERVICSE00_118
_SQL_CUR_26680060

"QUERY_ID"

"SQL_CUR_26680060 "

"STATEMENT_ID"

"SQL_SELECT-NON_UNIQUE"

"STATEMENT_TYPE"

"COMPLETE "

"STATEMENT_STATE"

"N"

"QUERY_TEXT_IS_MULTIROW"

"ERROR_CODE"

0

"SEQUENCE_NUM"

2007-05-23 22:30:05.867082

"QUERY_START_DATETIME"

2007-05-23

"QUERY_START_DATE"

22:30:05

"QUERY_START_TIME"

2007-05-24 05:30:05.867610

"QUERY_START_DATETIME_UTC"

2007-05-24

"QUERY_START_DATE_UTC"

05:30:05

"QUERY_START_TIME_UTC"

2007-05-23 22:30:05.867647

"QUERY_END_DATETIME"

2007-05-23

"QUERY_END_DATE"

22:30:05

"QUERY_END_TIME"

2007-05-24 05:30:05.867610

"QUERY_END_DATETIME_UTC"

2007-05-24

"QUERY_END_DATE_UTC"

05:30:05

"QUERY_END_TIME_UTC"

NULL

"EST_COST"

62

Examples and Guidelines for Creating Repository Queries