HP Neoview Release 2.4 Software User Manual
Page 68
Value
Field
"neo0102_clo"
"DATASOURCE"
"MXID01001000882212041585284557791000000000509seethadba00_118
_SQL_CUR_26680060
"QUERY_ID"
"SQL_CUR_26680060 "
"STATEMENT_ID"
"SQL_SELECT-NON_UNIQUE"
"STATEMENT_TYPE"
"INCOMPLETE"
"STATEMENT_STATE"
"N"
"QUERY_TEXT_IS_MULTIROW"
“”
"ERROR_CODE"
0
"SEQUENCE_NUM"
0
“SEQUENCE_SIZE”
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"
NULL
"QUERY_END_DATETIME"
NULL
"QUERY_END_DATE"
NULL
"QUERY_END_TIME"
NULL
"QUERY_END_DATETIME_UTC"
NULL
"QUERY_END_DATE_UTC"
NULL
"QUERY_END_TIME_UTC"
NULL
"EST_COST"
NULL
"QUERY_ELAPSED_TIME"
NULL
"MASTER_EXEC_EXECUTION_TIME"
NULL
"DISK_READS"
NULL
"LOCK_ESCALATIONS"
NULL
"LOCK_WAITS"
NULL
"MESSAGE_BYTES_TO_DISK"
NULL
"MESSAGES_TO_DISK"
NULL
"ROWS_ACCESSED"
NULL
"ROWS_RETRIEVED"
NULL
"NUM_ROWS_IUD"
NULL
"TOTAL_EXECUTES"
"select AVG(CPU) CPU, AVG(MEMORY) MEMORY,…"
"SQL_TEXT"
68
Examples and Guidelines for Creating Repository Queries