HP Neoview Release 2.5 Software - Manual (Page 131)

F History of Field Changes for Repository
This is a chronological history of changes to Repository.
• “Summary of Changes for Repository 2.4 SP2” (page 131)
• “Summary of Changes For Repository 2.4 SP1” (page 132)
• “Summary of Changes for Repository 2.4” (page 133)
• “Summary of Field Definition Changes for Repository 2.3” (page 133)
• “Summary of Field Definition Changes for Repository 2.2” (page 135)
Summary of Changes for Repository 2.4 SP2
These changes have been made to views between Repository 2.4 SP1 and Repository 2.4 SP2. If
you have already modified queries to reflect the new views in Repository 2.4 SP2, ignore this
section.
New Fields in QUERY_STATS_VW1
Description DataType Field Name
Cumulative node busy time, in
seconds, for all disk processes involved
in executing the query.
Example: 0.000000039592999999999996 FLOAT(54) DEFAULT NULL DISK_PROCESS_BUSY_TIME_SEC
Node processing time, in seconds,
from the time the execution starts to
the time the results are returned. It
does not include CPU time consumed
by SQL executor child processes (ESPs)
or disk processes for the query.
Example: 0.040214 FLOAT(54) DEFAULT NULL MASTER_EXECUTION_TIME_SEC
New Fields in SQL_TEXT_VW1
Description DataType Field Name
Primary Key
ANSI timestamp, in Local Civil Time,
indicating when query execution
began (that is, the time when an
execute statement is issued for the
prepared query).
Example: 2010–02–02 07:47:28.795392
TIMESTAMP(6) NO DEFAULT EXEC_START_LCT_TS
Primary Key
ANSI timestamp, in Coordinated
Universal Time, indicating when query
execution began.
Example: 2010–02–02 15:47:28.795392
TIMESTAMP(6) NO DEFAULT EXEC_START_UTC_TS
New Space Management Views
• “VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1” (page 47)
• “VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1” (page 50)
• “Sample Query Views for Space Management” (page 54)
Summary of Changes for Repository 2.4 SP2 131