HP Neoview Release 2.5 Software - Manual (Page 54)

Table 3-9 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)
Description Data Type Field Name
Timestamp, in Local Civil Time, when the
partition was last modified LARGEINT LAST_MODIFIED_LCT_JTS
Timestamp, in Local Civil Time, when the
partition was last opened LARGEINT LAST_OPEN_LCT_JTS
Timestamp, in Local Civil Time, when the
partition was dropped LARGEINT DROP_TIME_LCT_JTS
The application-defined code INT UNSIGNED FILE_CODE
Owner of the file CHAR(64) FILE_OWNER_NAME
One of these categories:
SQL Permanent Space
SQL System Space
SQL Volatile Space
Transform Ghost Objects
Transporter Staging Tables
CHAR(128) CATEGORY_TYPE
User or System CHAR(20) CATEGORY_NAME
Size allocated by the file system LARGEINT ALLOCATED_SIZE_BYTES
Percentage of disk space currently in use NUMERIC(128, 2) FULL_PCT
Sample Query Views for Space Management
You can use these sample query views to obtain various reports from the Repository views for
space management. These sample queries are provided as views named SPACE_Q_query-name
in the NEO.HP_METRICS schema. To return space management data from one of the sample
query views, run a SELECT statement like this one:
SELECT * FROM NEO.HP_METRICS.SPACE_Q_query-name;
For example, to see the SPACE_Q_CATALOG_SIZE_VW1 view, use this query:
SELECT * FROM NEO.HP_METRICS.SPACE_Q_CATALOG_SIZE_VW1;
For descriptions of the sample query views, see the next sections.
SPACE_Q_CATALOG_SIZE_VW1
Table 3-10 SPACE_Q_CATALOG_SIZE_VW1
This report provides the bytes used, bytes allocated, slack percentage, and number of schemas
for each catalog on the Neoview platform. Description:
LAST_CHECK_NOUPDATE_LCT_TS
LAST_CHECK_NOUPDATE_UTC_TS
CATALOG_NAME
BYTES_USED
BYTES_ALLOCATED
SLACK_PCT
NUM_SCHEMAS Columns Included:
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 Views Used:
54 Repository Views