Space_q_partition_full_vw1, Space_q_system_details_vw1, Space_q_system_total_size_vw1 – HP Neoview Release 2.5 Software User Manual
Page 56: Space_q_tables_by_schema_vw1
SPACE_Q_PARTITION_FULL_VW1
Table 3-14 SPACE_Q_PARTITION_FULL_VW1
This report provides partition fullness information, including the percentage of partition space
that is currently full for each partition, from biggest to smallest.
Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
SEGMENT_NAME
PARTITION_NAME
PARTITION_FULL_PCT
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
SPACE_Q_SYSTEM_DETAILS_VW1
Table 3-15 SPACE_Q_SYSTEM_DETAILS_VW1
This report provides detailed space information for the schemas on the Neoview platform,
including whether the objects in the schema are partitioned or non-partitioned, the number
of objects in the schema, the schema size in megabytes from biggest to smallest, and the
percentage of schema space that is currently full for each schema.
Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
SCHEMA_NAME
SPACE_TYPE
NUM_OBJECTS
SCHEMA_SIZE_MB
SCHEMA_FULL_PCT
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
SPACE_Q_SYSTEM_TOTAL_SIZE_VW1
Table 3-16 SPACE_Q_SYSTEM_TOTAL_SIZE_VW1
This report displays the total amount, in gigabytes, of system-wide storage space for users.
Description:
SYSTEM_SIZE_GB
Columns Included:
None (internal tables only)
Views Used:
SPACE_Q_TABLES_BY_SCHEMA_VW1
Table 3-17 SPACE_Q_TABLES_BY_SCHEMA_VW1
This report lists the tables in each schema on the Neoview platform.
Description:
SCHEMA_NAME
OBJECT_NAME
Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
Views Used:
56
Repository Views