HP Neoview Release 2.5 Software - Manual (Page 50)

Table 3-8 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)
Description Data Type Field Name
Timestamp, in Local Civil Time, when the
partition was last opened LARGEINT LAST_OPEN_LCT_JTS
Timestamp, in Coordinated Universal Time,
when the partition was last opened LARGEINT LAST_OPEN_UTC_JTS
Timestamp, in Local Civil Time, when the
partition was dropped LARGEINT DROP_TIME_LCT_JTS
Timestamp, in Coordinated Universal Time,
when the partition was dropped LARGEINT DROP_TIME_UTC_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
VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1
The Space Management Client in HPDM accesses this view to obtain aging historical data about
the table partitions. You can also run queries directly against this view. For sample queries, see
“Sample Query Views for Space Management” (page 54) .
Table 3-9 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions
Description Data Type Field Name
Timestamp, in Local Civil Time, indicating
when information in this row was checked
against the system values but did not need
any Repository update
Example: 2010-01-26 07:48:09.967095
LARGEINT LAST_CHECK_NOUPDATE_LCT_JTS
Timestamp, in Local Civil Time, indicating
when this row was updated in the
Repository
Example: 2010-01-26 07:47:28.795392
LARGEINT LAST_UPDATE_LCT_JTS
Timestamp, in Coordinated Universal Time,
indicating when information in this row was
checked against the system values but did
not need any Repository update
Example: 2010-01-26 15:48:09.967095
LARGEINT LAST_CHECK_NOUPDATE_UTC_JTS
Timestamp, in Coordinated Universal Time,
indicating when this row was updated in the
Repository
Example: 2010-01-26 15:47:28.795392
LARGEINT LAST_UPDATE_UTC_JTS
50 Repository Views