beautypg.com

Space_q_disk_full_vw1, Space_q_num_guardian_files_vw1, Space_q_object_growth_vw1 – HP Neoview Release 2.5 Software User Manual

Page 55

background image

SPACE_Q_DISK_FULL_VW1

Table 3-11 SPACE_Q_DISK_FULL_VW1

This report provides disk fullness information, including the percentage of disk space that is
currently in use from biggest to smallest and the percentage of user-allocated space that is
currently full.

Description:

LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
SEGMENT_NAME
DISK_NAME
DISK_FULL_PCT
USER_FULL_PCT

Columns Included:

NEO.HP_METRICS.DISK_STATS_V1
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
(and an internal table)

Views Used:

SPACE_Q_NUM_GUARDIAN_FILES_VW1

Table 3-12 SPACE_Q_NUM_GUARDIAN_FILES_VW1

This report provides the number of files on each segment.

Description:

SEGMENT_NAME
NUM_GUARDIAN_FILES_PER_SEG

Columns Included:

NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 (and an internal table)

Views Used:

SPACE_Q_OBJECT_GROWTH_VW1

Table 3-13 SPACE_Q_OBJECT_GROWTH_VW1

This report provides historical data of object growth for a given time period, from the earliest
to the most recent time, and includes the current, average, maximum, and minimum sizes, in
megabytes, of the objects on the Neoview platform.

Description:

LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
OBJECT_NAME_SPACE
OBJECT_TYPE
ROW_TYPE
OBJECT_CURR_SIZE_MB
OBJECT_AVG_SIZE_MB
OBJECT_MAX_SIZE_MB
OBJECT_MIN_SIZE_MB

Columns Included:

NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1

Views Used:

Space Management Views and Sample Query Views for Space Management

55