Hp Neoview Release 2.4 Software Bedienungsanleitung Seite 90
- Seite / 128
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
This table indicates which fields are present for completed and incomplete queries. The source
of data fields indicates whether the value is collected at the start of the query or at the end. Unless
indicated here, field descriptions are those provided above for ODBC_QUERY_STATS_V1.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for ODBC_QUERY_STATS_V2 fields is SEGMENT_ID, NODE_ID,
SEQUENCE_NUM and the date/time fields (QUERY_START_DATETIME_UTC and the other
date fields.
Table C-3 ODBC_QUERY_STATS_V2_2400 Fields
Source and NotesData TypeIncomplete QueriesComplete Queries
STARTCHAR(10)SEGMENT_NAMESEGMENT_NAME
STARTINT
UNSIGNED
SEGMENT_IDSEGMENT_ID
STARTINT
UNSIGNED
NODE_IDNODE_ID
Derived from CPU,
PIN
INT
UNSIGNED
PINPIN
STARTSMALLINT
UNSIGNED
START_PRIORITY
STARTCHAR(18)PROCESS_NAMEPROCESS_NAME
STARTCHAR(108)SESSION_IDSESSION_ID
STARTCHAR(8)USER_IDUSER_ID
STARTCHAR(128)USER_NAMEUSER_NAME
STARTCHAR(15)CLIENT_IDCLIENT_ID
STARTCHAR(130)APPLICATION_IDAPPLICATION_ID
STARTCHAR(128)DATASOURCEDATASOURCE
ENDVARCHAR(160)QUERY_ID when availableQUERY_ID
STARTCHAR(30)STATEMENT_IDSTATEMENT_ID
ENDCHAR(36)STATEMENT_TYPESTATEMENT_TYPE
'COMPLETE',
'INCOMPLETE',
'MULTIROW',
'ERRTERMINATION',
derived from
STATEMENT
STATUS and
SEQUENCE
NUMBER
CHAR(14)STATEMENT_STATESTATEMENT_STATE
Y or NCHAR(1)QUERY_TEXT_IS_MULTIROWQUERY_TEXT_IS_MULTIROW
END, else START,
else NULL
CHAR(6)ERROR_CODEERROR_CODE
STARTSMALLINT
UNSIGNED
SEQUENCE_NUMSEQUENCE_NUM
STARTSMALLINT
UNSIGNED
SEQUENCE_SIZESEQUENCE_SIZE
90 Pre-R2.4 SP2 Query Statistics Views
- HP Part Number: 621366-001 1
- Published: May 2010 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- List of Figures 6
- List of Tables 7
- List of Examples 8
- About This Document 9
- Notation Conventions 10
- Notation Conventions 11 11
- Related Documentation 12
- • Connectivity 13
- • Reference 13
- Publishing History 14
- HP Encourages Your Comments 14
- 1 Introduction 15
- 16 Introduction 16
- Installation 17
- Obtaining Prepackaged Queries 17
- Starting the Repository 17
- 3 Repository Views 19
- ODBC Session Data 33
- Processing Node Statistics 38
- Process Statistics 40
- Table Statistics 47
- Disk Statistics 50
- EMS Events 53
- Management 55
- SPACE_Q_CATALOG_SIZE_VW1 62
- SPACE_Q_DISK_FULL_VW1 62
- SPACE_Q_OBJECT_GROWTH_VW1 63
- SPACE_Q_PARTITION_FULL_VW1 63
- SPACE_Q_SYSTEM_DETAILS_VW1 63
- SPACE_Q_SYSTEM_TOTAL_SIZE_VW1 63
- SPACE_Q_TABLES_BY_SCHEMA_VW1 64
- SPACE_Q_TABLE_FULL_VW1 64
- SPACE_Q_TABLE_SIZE_VW1 64
- SPACE_Q_TOP_10_TABLE_SIZE_VW1 65
- Overview 67
- 0030'; 72
- Sample Query Result 82
- Releases of the Repository 83
- Query Statistics for R2.4 SP1 85
- New Fields in QUERY_STATS_VW1 117
- New Fields in SQL_TEXT_VW1 117
- New Space Management Views 117
- Glossary 125
Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.4 Software
Software Hp Smart Update Manager Bedienungsanleitung
(130 Seiten)
(130 Seiten)
Whirlpool R 24 S (EU) podręczniki
Instrukcje obsługi i podręczniki użytkownika dla Lodówki Whirlpool R 24 S (EU).
Dostarczamy 1 pdf podręczników Whirlpool R 24 S (EU) do pobrania za darmo według typów dokumentów: Instrukcja Obsługi
Kommentare zu diesen Handbüchern