Neoview Repository User Guide (R2.4 SP1)

Retrieve Statistics for Incomplete Queries
This query lists information about queries that have started but not ended. The result set is
ordered in descending chronological order (most recent first). The result set represents queries
that are active, queries that terminated abnormally, or queries where the user chose not to finish
fetching the data. If a query did not complete, fields that are not populated unless the query
completes have the value NULL.
The list following the query shows the values that might be associated with a specific query.
SELECT [FIRST 2] *
FROM NEO.HP_METRICS.QUERY_STATS_VW1
WHERE QUERY_STATUS IN (’INIT’, ’REJECTED’)
ORDER BY EXEC_START_LCT_TS DESC
FOR READ UNCOMMITTED ACCESS;
ValueField
2009-08-19 04:56:20.264828“EXEC_START_LCT_TS”
2009-08-19 11:56:20.264828“EXEC_START_UTC_TS”
“MXID01003030787212117386140307130000000009614SUPER.SERVICES00_254_SQL_CUR_61”“QUERY_ID”
2009-08-19 04:56:27.544543“ENTRY_ID_LCT_TS”
2009-08-19 11:56:27.544543“ENTRY_ID_UTC_TS”
\NEO0102“SEGMENT_NAME”
NEO01“PLATFORM_NAME”
“joesmith ”
1
“USER_NAME”
“ROLE.DBA”“ROLE_NAME”
148“START_PRIORITY”
\NEO0102.$Z2YK“PROCESS_NAME”
“MXID01003030787212117386140307130000000009614SUPER.SERVICES00”“SESSION_ID”
“ORDCLOVISRBTS-P2”“CLIENT_NAME”
“ODBC Test (ANSI) ”"APPLICATION_NAME"
“neo0102_clo”“DATASOURCE”
“SQL_CUR_26680060 ”“STATEMENT_ID”
“SQL_SELECT_NON_UNIQUE”“STATEMENT_TYPE“
“HP_DEFAULT_SERVICE”“SERVICE_NAME”
2“SEGMENT_ID”
1“NODE_ID”
2009-08-19 04:57:00.801175“SUBMIT_LCT_TS”
2009-08-19 11:57:00.801175“SUBMIT_UTC_TS”
2009-08-19 04:56:17.668589“COMPILE_START_LCT_TS”
2009-08-19 11:56:17.668589“COMPILE_START_UTC_TS”
2009-08-19 04:56:20.264466“COMPILE_END_LCT_TS”
2009-08-19 11:56:20.264466“COMPILE_END_UTC_TS”
2595877“COMPILE_ELAPSED_TIME”
2.595877“COMPILE_ELAPSED_TIME_SEC”
Retrieve Statistics for Incomplete Queries 79