HP Neoview Release 2.5 Software - Manual (Page 227)

User_name as User_Name,
query_start_datetime as Start_time,
query_end_datetime as end_time,
Datasource as datasource,
start_priority as Pri,
rows_accessed,
rows_retrieved,
num_rows_iud as Row_IUD,
error_code,
statement_state,
process_name as Mstr_Exec,
sequence_size as SQL_TXT_Size,
sql_text as First_3k_text
FROM
ODBC_QUERY_STATS_V2
WHERE
(QUERY_START_DATETIME) >= TIMESTAMP '$$__FROM_TIME$$'
AND (QUERY_START_DATETIME) < TIMESTAMP '$$__TO_TIME$$'
and STATEMENT_STATE <> 'MULTIROW'
and statement_state = 'COMPLETE'
order by Elapsed_min desc
FOR READ UNCOMMITTED ACCESS
;
The resulting parameter prompt is:
For each parameter, Metric Miner stores the last 10 values that you supply so that they can be
reused in later statement executions. These stored parameters are persisted across sessions (Metric
Miner remembers the values even when you disconnect from HPDM). Once the report executes
successfully, the parameters corresponding to the report are displayed in a Parameters tab next
to the Description tab.
Related Topics
“Run a SQL Statement Using Metric Miner” (page 225)
Cancel a Query From Metric Miner
Sometimes you need to cancel a running SQL query. It may be that you typed the wrong query,
the query is taking too long, or the query is creating a performance bottleneck and needs to be
stopped. After a query starts executing in Metric Miner, the Stop button changes to red and
becomes active. To stop the query, click the Stop button ( ) on the Metric Miner toolbar.
Related Topics
Run Statements 227