beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 68

background image

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