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

HP Neoview Repository User GuideHP Part Number: 621366-001Published: May 2010Edition: HP Neoview Release 2.4 Service Pack 2 (SP2)

Appendix B (page 83)Use this appendix to learn about the history of new and changed information in the Repository.Appendix C (page 85)Use this appendi

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)ANSI Timestamp i

QUERY_STATS_VW1 and SQL_TEXT_VW1 so that you can obtain query statistics in a singlerow.CAUTION: Although your pre-R2.4 SP1 queries will not fail due

Table C-5 ODBC_QUERY_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameMessage sequence number generatedby NDCS. Numbering starts at

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

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

Table C-6 ODBC_QUERY_STATS_V2 Fields (continued)Source and NotesData TypeIncomplete QueriesComplete QueriesSTARTCHAR(8)USER_IDUSER_IDSTARTCHAR(128)USE

Table C-6 ODBC_QUERY_STATS_V2 Fields (continued)Source and NotesData TypeIncomplete QueriesComplete QueriesEND, or NULL foran incompletequeryTIMEQUERY

Because statistics are updated as the query executes, you can use this view to monitor runningqueries.With regard to when query statistics will be pre

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Percentage of availab

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)SQL error code, if an

{ } BracesBraces enclose required syntax items. For example:FROM { grantee[, grantee]...}A group of items enclosed in braces is a list from which you

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Amount of “heap” type

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Number of records acc

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

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

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

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

116

D History of Field Changes for RepositoryThis is a chronological history of changes to Repository.• “Summary of Changes for Repository 2.4 SP2” (page

Summary of Changes For Repository 2.4 SP1These changes have been made to views between Repository 2.4 and Repository 2.4 SP1. If youhave already modif

Table D-1 Fields Not Available in Repository 2.4 SP1 Views ODBC_QUERY_STATS_V1,ODBC_QUERY_STATS_V2, and QUERY_RUNTIME_STATS_V1 (continued)Field Unavai

Line SpacingIf the syntax of a command is too long to fit on a single line, each continuation line is indentedthree spaces and is separated from the p

The following table shows how fields defined in the view QUERY_RUNTIME_STATS_V1 wererenamed in Repository 2.3.Table D-2 Field Definition Changes for Q

Summary of Field Definition Changes for Repository 2.2The following field names changed between Repository 2.1 and Repository 2.2. If you havealready

Table D-5 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 toODBC_QUERY_STATS_V2 (continued)Field Name in ODBC_QUERY_STATS_V2Field Name in ACCESS_

Table D-7 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 toODBC_SESSION_STATS_V2 (continued)Field Name in ODBC_SESSION_STATS_V2Field Name in AC

124

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

126

IndexAAggregate statistics for processes, 43CCPU statistics (see Processing node statistics)DDefault configuration, 17Disk statistics, 50Documents, re

Context-sensitive help topics that describe how to use the NeoviewPerformance Analysis Tools to analyze and troubleshoot query-related issueson the Ne

Publishing HistoryPublication DateProduct VersionPart NumberAugust 2007Release 2.2544570–001April 2008Release 2.3544811–001April 2009Release 2.4546262

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

Use the Neoview Performance Analysis Tools (NPA Tools) client to monitor queries and systemresources on the Neoview platform and to reveal, as soon as

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

Retention TimeRepository Metric30 daysProcess statistics, if enabled30 daysProcess aggregation Level1 statistics, if enabled30 daysTable statistics30

3 Repository ViewsOverviewYou can use the following views for access to the Repository:• “VIEW NEO.HP_METRICS.QUERY_STATS_VW1” (page 19)• “VIEW NEO.HP

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

Table 3-1 QUERY_STATS_VW1 Field DefinitionsDescriptionData TypeField NameANSI Timestamp, in Local Civil Time,indicating when query execution began. Th

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameNeoview user role name. Multiple users canhave the same role name

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameCompiler-provided value, one of:• SQL_SELECT_UNIQUE• SQL_SELECT_N

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameANSI Timestamp, in Local Civil Time,indicating when query compila

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameIndicates whether this query is required toexecute under a transa

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameEstimated total cost (time in seconds) of theSQL operations for t

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameEstimate of the number of seconds ofprocessor time it might take

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameWhat the executor is doing. Possible querystates include:INITIALO

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameAn approximation, in microseconds, of thetotal node time spent in

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameAmount of “space” type (static) memory, inkilobytes, allocated (r

Table of ContentsAbout This Document...9Supporte

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameQuery ID for the immediate parent of thisquery ID. If the parent

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)DescriptionData TypeField NameCumulative number of times record (row)locks were escalated to fi

VIEW NEO.HP_METRICS.SQL_TEXT_VW1This view allows access to the complete SQL text for a query.When the SQL text for a query is 254 characters or fewer,

Table 3-2 SQL_TEXT_VW1 Field Definitions (continued)DescriptionData TypeField NameNeoview system name, made up of thefirst three letters of the system

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

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

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

Table 3-4 ODBC_SESSION_STATS_V2 Fields (continued)Source and NotesData TypeIncomplete SessionsComplete SessionsSTARTCHAR(130)APPLICATION_IDAPPLICATION

Table 3-4 ODBC_SESSION_STATS_V2 Fields (continued)Source and NotesData TypeIncomplete SessionsComplete SessionsEND, or NULL for an incompletesessionLA

Table 3-5 NODE_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameANSI SQL time, in CoordinatedUniversal Time, indicating whenthe mea

4 Examples and Guidelines for Creating Repository Queries...67Overview...

Table 3-5 NODE_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumber of free memory frames(physical pages) when theprocessing nod

Table 3-6 PROCESS_STATS_V1 Field DefinitionsDescriptionData TypeField NameSegment number of the processINTEGER UNSIGNED NODEFAULTSEGMENT_IDProcessing

Table 3-6 PROCESS_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameName of the process being measuredCHARACTER(8)PROCESS_NAMEObject

Table 3-6 PROCESS_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumber of message bytes received bythe processLARGEINTRETURNED_B

Table 3-7 PROCESS_AGGR_LEVEL1_STATS_V1 Field DefinitionsDescriptionData TypeField NameSegment number of the parentprocessSMALLINT UNSIGNEDSEGMENT_IDAN

Table 3-7 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameSum of CPU busy time, inmicroseconds, for all proces

Table 3-7 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameAverage percent busy of allprocesses with a CPU busy

Table 3-7 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameAmong processes that had morethan 30 dispatches, the

• TABLE_STATS_V2 provides the most recently collected data for each monitored object.Thus, the view includes only one row per monitored table or mater

Table 3-8 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)DescriptionData TypeField NameName of applicable schema for the object

Index...127Table of Conten

Table 3-8 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)DescriptionData TypeField NameCumulative list of columns for whichstat

Table 3-9 DISK_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameState of the primary disk, one of:'Up''Down'&ap

Table 3-9 DISK_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameNumerical equivalent of the status text:1 means 'Exists'2

Table 3-9 DISK_STATS_V1 Field Definitions (continued)DescriptionData TypeField NameInput kilobytes per second during thisinterval for the mirror diskD

Table 3-10 EVENTS_VW1 Field Definitions (continued)DescriptionData TypeField NamePrimary KeyA sequence number used todifferentiate between twoevents t

Table 3-10 EVENTS_VW1 Field Definitions (continued)DescriptionData TypeField NameFile system error, if related toan SQL error. Null for any otherevent

Table 3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)DescriptionData TypeField NameNeoview system name, made up of the firstthree letter

Table 3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)DescriptionData TypeField NameCurrent data size, in bytes, of the partition,determi

Table 3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)DescriptionData TypeField NameSize allocated by the file systemLARGEINTALLOCATED_SI

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)DescriptionData TypeField NameObject type, which can be:BT (Base Table)MV (

List of Figures1-1 Neoview Repository and Related Products...166 List o

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)DescriptionData TypeField NameMaximum size, in bytes, of the partitionLARGE

Table 3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)DescriptionData TypeField NameTimestamp, in Coordinated Universal Time,when

Sample Query Views for Space ManagementYou can use these sample query views to obtain various reports from the Repository views forspace management. T

SPACE_Q_OBJECT_GROWTH_VW1Table 3-16 SPACE_Q_OBJECT_GROWTH_VW1This report provides historical data of object growth for a given time period, from the e

SPACE_Q_TABLES_BY_SCHEMA_VW1Table 3-20 SPACE_Q_TABLES_BY_SCHEMA_VW1This report lists the tables in each schema on the Neoview platform.Description:SCH

SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1Table 3-24 SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1This report lists the non-partitioned objects with the top 10

SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1Table 3-28 SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1This report lists the top 10 users who are consuming the most space, in

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

Retrieve Statistics for Completed QueriesThis query lists information for the ten most recent queries that completed normally. You couldenhance this q

SUM(MESSAGE_BYTES_TO_DISK) as TTL_MESSAGE_BYTES_TO_DISK, SUM(NUM_ROWS_IUD) as TTL_NUM_ROWS_IUD, SUM(ROWS_ACCESSED) as TTL_ROWS_ACCESSED, SUM(ROWS

List of Tables3-1 QUERY_STATS_VW1 Field Definitions...203-2 SQL_T

Completed Queries Executed on a System in the Previous Two DaysTo count queries that executed from one midnight to the next, instead of within a 24 ho

Queries within the Past 24 Hours, Grouped by Client Name and Including Averageand Maximum Elapsed TimeSELECT client_name, COUNT(*) AS num_of_qu

Minor formatting of the columns can yield a more readable result:select [first 10] left (datasource, 25) as datasource1, client_name, count(*) as q

A Sample Queries for Event InformationThese are examples of queries you can run against the error event data on the Neoview platformusing HPDM SQL Whi

Example A-1 Generate Update Stats Command ListThis report generates an executable command list to resolve missing table statistics, based ontwo event

Example A-2 Search Event Logs for Abnormal Program TerminationThis report performs a case-insensitive search for all events in which the event text co

Example A-3 Search Event Logs For a Specific Event NumberThis report lists all occurrences of a specified event number within a given time period.SELE

Example A-4 Search Event Logs for Specific Event TextThis report performs a case-insensitive search for events in which the event text contains theent

Example A-5 Search Event Logs for Missing StatisticsThis report searches for all occurrences of missing SQL statistics messages 6007, 6008, 6010 and60

Example A-6 Search Event Logs for a Process NameThis report lists all events for a full or partial process name and given time period.SELECT EVEN

List of ExamplesA-1 Generate Update Stats Command List...74A-2

Example A-7 Search Event Logs for a Query IDThis report searches event text for a full or partial query_id during a given time period.SELECT EVEN

Example A-8 Search Event Logs for SubsystemThis report searches for all events for full or partial subsystem name and time period.SELECT EVENT_NU

Example A-9 Summary of all EventsThis report summarizes all events for a given time period and returns results grouped by SSIDand event number.SELECT

B History of New and Changed Information in PreviousReleases of the RepositoryNew and Changed Information in Previous EditionsThe Release 2.4 Service

• Naming changes to reflect the fact that the product formerly called Neoview Script is nowcalled Neoview Command Interface.• Deletion of text and des

C Pre-R2.4 SP2 Query Statistics ViewsQuery Statistics for R2.4 SP1Three new Repository views improve the collection of the Repository statistics:Two n

These three views provide access to R2.4 query and runtime statistics information. This informationis maintained on the Neoview platform for your conv

Table C-2 ODBC_QUERY_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField NameANSI SQL timestamp in CoordinatedUniversal Time when the

Table C-2 ODBC_QUERY_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField NameSTART if this record containsinformation collected at th

Table C-2 ODBC_QUERY_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField NameCompiler-provided value, one of:SQL_SELECT_UNIQUE,SQL_SE

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

This table indicates which fields are present for completed and incomplete queries. The sourceof data fields indicates whether the value is collected

Table C-3 ODBC_QUERY_STATS_V2_2400 Fields (continued)Source and NotesData TypeIncomplete QueriesComplete QueriesSTARTTIMESTAMPQUERY_START_DATETIMEQUER

NOTE: In both ODBC_QUERY_STATS_V1_2400 and ODBC_QUERY_STATS_V2_2400, theQUERY_ID field contains the unique ID of the query unless an error occurs befo

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Process identifi

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Difference in mi

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Amount of “space

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Usually the warn

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Estimated cost (

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)Calculated compi

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)DescriptionData TypeField Name (* means available only inthis view)The SQL statemen