Hp Neoview Release 2.5 Software Manuel d'utilisateur télécharger pdf (Page 54)

Table 3-9 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions (continued)

DescriptionData TypeField Name

Timestamp, in Local Civil Time, when the

partition was last modified

LARGEINTLAST_MODIFIED_LCT_JTS

Timestamp, in Local Civil Time, when the

partition was last opened

LARGEINTLAST_OPEN_LCT_JTS

Timestamp, in Local Civil Time, when the

partition was dropped

LARGEINTDROP_TIME_LCT_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

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_VW1Views Used:

54 Repository Views

1 2 ... 49 50 51 52 53 54 55 56 57 58 59 ... 141 142

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 54

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.5 Software