HP Neoview Release 2.3 Software User Manual
Page 62
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