Hp Neoview Release 2.3 Software Uživatelský manuál Strana 1

HP Neoview Repository User GuideHP Part Number: 544811-001Published: April 2008Edition: N02.03 and subsequent N-series RVUs

Document OrganizationThis document is organized as follows:Chapter 1: IntroductionUse this chapter to learn about the Repository and related Neoview s

DROP SCHEMA schema [CASCADE] [RESTRICT]DROP SCHEMA schema [ CASCADE | RESTRICT ]{ } BracesBraces enclose required syntax items. For

If there is no space between two items, spaces are not permitted. In this example, no spacesare permitted between the period and any other items:myfil

Information about using Neoview Workload Management Services (WMS) tomanage workload and resources on a Neoview data warehousing platform.Neoview Work

14

1 IntroductionRepository Features and InterfacesThe Neoview Manageability Repository is a Neoview SQL database and set of programs thatautomatically c

NOTE: Because the Query Runtime Statistics feature updates the Repository as new querystatistics information is received from the Dashboard, you can n

2 Getting Started with Repository 2.3InstallationThe Repository is initially installed on the Neoview platform by HP Manufacturing. Repositoryupgrades

If you’ve written queries using views defined in Release 2.1, modify them to use the correspondingviews described in this document. The Release 2.1 (d

Starting the RepositoryDuring installation, the Repository is configured to come up automatically when the Neoviewplatform starts.By default, statisti

© Copyright 2008 Hewlett-Packard Development Company, L.P.Legal NoticeConfidential computer software. Valid license from HP required for possession, u

Retention TimeRepository Metric30 daysTable statistics30 daysDisk statisticsTo modify these retention times, contact your account representative.20 Ge

3 Repository ViewsOverviewYou can use the following views for access to the Repository:• “VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1” (page 22)• “VIEW NE

Table 3-1 Comparison of ODBC Query Statistics and Query Runtime Statistics (continued)Query Runtime StatisticsODBC Query StatisticsData is available o

Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameRepository assigned value. Usedinternally.INTEGER UNSIGNEDMET

Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameClient data source name used at thetime of the connection.CHA

Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameA unique ID for the query, beginningwith the string “MXID” an

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)Source and NotesData TypeIncomplete QueriesComplete QueriesSTARTCHAR(108) orNCHAR(108)SESSION_IDSESSIO

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)Source and NotesData TypeIncomplete QueriesComplete QueriesEND, or NULL foran incomplete queryTIMEQUER

When compared with the other available views that provide information for queries, this onecontains many additional fields. Fields available only in t

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Cumulative node utili

Table of ContentsAbout This Document...9Supporte

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Numeric form of the u

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Number of bytes writt

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Estimate of the numbe

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Elapsed clock time, i

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)What the executor is

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)ANSI Timestamp, in Lo

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameANSI SQL Timestamp, inCoordinated Universal Time,indicating

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameTotal number of SQL INSERTstatements sent by the HPODBC dri

Table 3-5 ODBC_SESSION_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameName of the Neoview segmentused by the data source.CHAR(10)

Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platformconfiguration. In the following table:• If a data type is given

Get the Number of Rows in a View...61Retrieve a Spe

Table 3-6 ODBC_SESSION_STATS_V2 Fields (continued)Source andNotesData TypeIncomplete SessionsComplete SessionsEND, orNULL for anincompletesessionDATES

Table 3-6 ODBC_SESSION_STATS_V2 Fields (continued)Source andNotesData TypeIncomplete SessionsComplete SessionsEND, orNULL for anincompletesessionLARGE

Table 3-7 NODE_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameANSI SQL timestamp, in LocalCivil Time, indicating when themeasurem

Table 3-7 NODE_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumber of times a process wasselected from the ready list andexecut

• The Neoview NDCS server (MXOSRVR)• The Repository collector processes (MMCOLLEC)By default, a measurement of each of these processes occurs every fi

Table 3-8 PROCESS_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameANSI SQL date, in CoordinatedUniversal Time, indicating when the

Table 3-8 PROCESS_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameTime, in microseconds, that extendedsegments were allocated to t

In the case of an NDCS server process or a Neoview SQL compiler process, statistics are notreally aggregates because each record represents only one p

Table 3-9 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameAverage creation priorityall processes described byt

Table 3-9 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumber of processeswith a CPU busypercentage between

List of Figures1-1 Neoview Repository and Related Products...165

Table 3-9 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameStandard deviation ofpercent busy forprocesses with

Table 3-9 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameAmong processes thathad page faults, thesmallest num

Table StatisticsThe Repository includes two views that provide access to data about tables or materialized viewswhose histogram statistics are missing

Table 3-10 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)DescriptionData TypeField NameName of the catalog in which theobject

Table 3-10 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)DescriptionData TypeField NameIf update statistics is currentlyrunnin

Table 3-11 DISK_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameProcess identification number of thedisk process for this volumeSM

Table 3-11 DISK_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumber of disk requests blocked persecond for this intervalSMALLIN

Table 3-11 DISK_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumber of disk process readoperations per second for this interval

Table 3-12 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 toODBC_QUERY_STATS_V1 (continued)Field Name in ODBC_QUERY_STATS_V1Field Name in ACCESS

Table 3-14 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V1 toODBC_SESSION_STATS_V1.Field Name in ODBC_SESSION_STATS_V1Field Name in ACCESS_ODBCM

6

Table 3-16 Changes in Field Definitions for QUERY_RUNTIME_STATS_V1 from Repository 2.2 toRepository 2.3 (continued)Change in Repository 2.3Field Name

4 Examples and Guidelines for Creating Repository QueriesOverviewThis section lists some simple queries against the available Repository views and pro

The list following the query shows values that might be returned in a single record.select [first 10] *from NEO.HP_METRICS.ODBC_QUERY_STATS_V2where ST

ValueField2325"QUERY_ELAPSED_TIME"16-7"MASTER_EXEC_EXECUTION_TIME"0"DISK_READS"0"LOCK_ESCALATIONS"0"LOCK_

ValueField"SQL_CUR_26680060 ""STATEMENT_ID""SQL_SELECT-NON_UNIQUE""STATEMENT_TYPE""INCOMPLETE""

this example, an ODBC session that executed a single query saturated the system fromapproximately 19:25:00 to 19:35:00 and then was inactive.reset par

AND QUERY_START_DATETIME >= DATE_TRUNC('DAY', CURRENT - INTERVAL '1' DAY) AND STATEMENT_STATE = 'COMPLETE' GROUP

AND QUERY_START_DATETIME >= CURRENT - INTERVAL '1' DAY AND STATEMENT_STATE = 'COMPLETE' GROUP BY client_id ORDER BY cl

rstein-xp 31TDM_Default_DataSource

This next query assumes that you know the specific QUERY_ID of interest:SELECT [first 10] left(query_id,95) as query_id1, query_start_date, query_

List of Tables3-1 Comparison of ODBC Query Statistics and Query Runtime Statistics...213-2 ODBC_QUERY_STATS_V1 F

70

GlossaryCollector process A Repository process that collects metrics for a monitored entity.Execdirect A SQL statement or call that executes a query d

72

IndexAAggregate statistics for processes, 46CCPU statistics (see Processing node statistics)DDefault configuration, 19Disk statistics, 54Documents, re

8

About This DocumentThis document describes the views supported by the Neoview Manageability Repository, aNeoview SQL database and set of programs that