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

Procházejte online nebo si stáhněte Uživatelský manuál pro Software Hp Neoview Release 2.3 Software. HP Neoview Release 2.3 Software User Manual Uživatelská příručka

  • Stažení
  • Přidat do mých příruček
  • Tisk

Shrnutí obsahu

Strany 1 - Published: April 2008

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

Strany 2

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

Strany 3 - Table of Contents

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

Strany 4 - 4 Table of Contents

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

Strany 5 - List of Figures

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

Strany 7 - List of Tables

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

Strany 8

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

Strany 9 - About This Document

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

Strany 10 - Notation Conventions

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

Strany 11 - Notation Conventions 11

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

Strany 12 - Related Documentation

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

Strany 13 - HP Encourages Your Comments

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

Strany 14

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

Strany 15 - 1 Introduction

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

Strany 16 - 16 Introduction

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

Strany 17 - Installation

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

Strany 18

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

Strany 19 - Starting the Repository

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

Strany 20 - 30 daysDisk statistics

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

Strany 21 - 3 Repository Views

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

Strany 22

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

Strany 23

Table of ContentsAbout This Document...9Supporte

Strany 24

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

Strany 25

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

Strany 26

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

Strany 27

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

Strany 28

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

Strany 29

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

Strany 30

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

Strany 31

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

Strany 32

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

Strany 33

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

Strany 34

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

Strany 35 - ODBC Session Data

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

Strany 36

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

Strany 37

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

Strany 38

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

Strany 39

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

Strany 40

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

Strany 41 - Processing Node Statistics

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

Strany 42

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

Strany 43 - Process Statistics

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

Strany 44

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

Strany 45

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

Strany 46

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

Strany 47

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

Strany 48

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

Strany 49

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

Strany 50

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

Strany 51

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

Strany 52 - Table Statistics

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

Strany 53

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

Strany 54 - Disk Statistics

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

Strany 55

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

Strany 57

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

Strany 58

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

Strany 59

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

Strany 60 - TABLE_STATS_V2

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

Strany 61 - Overview

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

Strany 62 - FOR READ UNCOMMITTED ACCESS;

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

Strany 63 - FOR READ UNCOMMITTED ACCESS;

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

Strany 64

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

Strany 65

rstein-xp 31TDM_Default_DataSource

Strany 66 - Maximum Elapsed Time

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_

Strany 67

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

Strany 69 - Retrieving UCS2 Columns

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

Strany 71 - Glossary

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

Strany 74

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

Komentáře k této Příručce

Žádné komentáře