beautypg.com

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

background image

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