Hp Neoview Release 2.4 Software Bedienungsanleitung PDF herunterladen (Seite 70)

Completed Queries Executed on a System in the Previous Two Days

To count queries that executed from one midnight to the next, instead of within a 24 hour period

relative to the current time, the following query uses the Neoview DATE_TRUNC function in

the SQL WHERE clause.

SELECT DISTINCT (CAST(EXEC_START_LCT_TS AS DATE)) AS START_DATE,

COUNT(*) AS NUM_OF_QUERIES,

MAX(CAST(EXEC_START_LCT_TS AS TIME(6))) AS MAX_START_TIME,

MIN(CAST(EXEC_START_LCT_TS AS TIME(6))) AS MIN_START_TIME

FROM NEO.HP_METRICS.QUERY_STATS_VW1

WHERE EXEC_START_LCT_TS <= CURRENT

AND EXEC_START_LCT_TS >= DATE_TRUNC('DAY', CURRENT - INTERVAL '1' DAY)

AND QUERY_STATUS = 'COMPLETED'

GROUP BY 1

FOR READ UNCOMMITTED ACCESS;

MIN_START_TIMEMAX_START_TIMENUM_OF_QUERIESSTART_DATE

15:15:34.09236816:16:30.572346202010-04-25

04:20:09.29752010:56:20.56835210722010-04-26

Queries within the Past 24 Hours, Grouped by Client Name

This example indicates how many queries different clients ran within a 24-hour period.

SELECT client_name, COUNT(*) AS NUM_OF_QUERIES

FROM NEO.HP_METRICS.QUERY_STATS_VW1

WHERE EXEC_START_LCT_TS <= CURRENT

AND EXEC_START_LCT_TS >= CURRENT - INTERVAL '1' DAY

AND QUERY_STATUS = 'COMPLETED'

GROUP BY client_name

ORDER BY client_name

FOR READ UNCOMMITTED ACCESS;

NUM_OF_QUERIESCLIENT_NAME

52SJUMT1

980exedl1-1

23scott1

38sqdev8

Queries within the Past 24 Hours, Grouped by Data Source

This example indicates how many queries within the 24-hour period were associated with each

data source.

SELECT datasource, COUNT(*) AS NUM_OF_QUERIES

FROM NEO.HP_METRICS.QUERY_STATS_VW1

WHERE EXEC_START_LCT_TS <= CURRENT

AND EXEC_START_LCT_TS >= CURRENT - INTERVAL '1' DAY

AND QUERY_STATUS = 'COMPLETED'

GROUP BY datasource

ORDER BY datasource

FOR READ UNCOMMITTED ACCESS;

NUM_OF_QUERIESDATASOURCE

996Admin_Load_DataSource

98TDM_Default_DataSource

70 Examples and Guidelines for Creating Repository Queries

1 2 ... 65 66 67 68 69 70 71 72 73 74 75 ... 127 128

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.4 Software Bedienungsanleitung Seite 70

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.4 Software