Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 50)

Table 3-8 SPACE_PARTITION_DETAIL_VW1 Field Definitions (continued)

DescriptionData TypeField Name

Timestamp, in Local Civil Time, when the

partition was last opened

LARGEINTLAST_OPEN_LCT_JTS

Timestamp, in Coordinated Universal Time,

when the partition was last opened

LARGEINTLAST_OPEN_UTC_JTS

Timestamp, in Local Civil Time, when the

partition was dropped

LARGEINTDROP_TIME_LCT_JTS

Timestamp, in Coordinated Universal Time,

when the partition was dropped

LARGEINTDROP_TIME_UTC_JTS

The application-defined codeINT UNSIGNEDFILE_CODE

Owner of the fileCHAR(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 SystemCHAR(20)CATEGORY_NAME

Size allocated by the file systemLARGEINTALLOCATED_SIZE_BYTES

Percentage of disk space currently in useNUMERIC(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

DescriptionData TypeField 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

LARGEINTLAST_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

LARGEINTLAST_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

LARGEINTLAST_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

LARGEINTLAST_UPDATE_UTC_JTS

50 Repository Views

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 141 142

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 50

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.5 Software