HP.com home ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 8 SQLMON Screen Reference

Static DBEFile Screen
» 

Technical documentation
Complete book in PDF
» Feedback
 

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

This screen lists the file capacity of each DBEFile in a DBEFileSet.

[dbefile]

To invoke the Static DBEFile screen, use the d command from the Static subsystem or the /st d command from other subsystems.

Field Definitions

DBEFILESET

The name of the DBEFileSet.

The keyword DETACHED means that the DBEFileSet is detached. The keywords DETACHED DBEFILES mean that the DBEFileSet is attached, but some of the DBEFiles within it are detached.

DBEFILESET FULLNESS %

The percentage of file space in use in the DBEFileSet, calculated as follows:

   DBEFILESET FULLNESS %  = (FSUSED PAGES / FSMAX PAGES) * 100
FSUSED PAGES

The number of pages in use in the DBEFileSet. This value is equivalent to the value of the DBEFSUPAGES column of SYSTEM.DBEFILESET plus the number of page table pages in the DBEFileSet. A used page might not be full.

FSMAX PAGES

The maximum number of pages in the DBEFileSet. This value is equal to the DBEFSMPAGES column of SYSTEM.DBEFILESET.

DBEFILE

The name of the DBEFile contained in the DBEFileSet. If the DBEFile has been detached with the SQLUtil DETACHFILE command, the keyword DETACHED appears.

TYP

The type of the DBEFile, as listed below:

TBL

Table data pages, including hash structures and long column data

IDX

Index or referential constraint pages

MIX

Mixed, indicating either table data, index, or referential constraint pages

BD

Whether a DBEFile is bound, indicated by an asterisk. When a table is defined as hashed, a group of primary pages from up to 16 DBEFiles is allocated for it. The DBEFiles are bound, that is, they are unavailable for any other table, index, or referential constraint. You can only insert data for the hashed table itself into these DBEFiles. The last bound DBEFile might have unused space, which ALLBASE/SQL can use for overflow pages for the hash structure.

DBEFILE FULLNESS %

The percentage of file space in use in the DBEFile, calculated as follows:

  DBEFILE FULLNESS % = (USED PAGES / MAX PAGES) * 100
USED PAGES

The number of pages in use in the DBEFile. This value is equivalent to the DBEFUPAGES column of SYSTEM.DBEFILE plus the number of page table pages in the DBEFile.

MAX PAGES

The maximum number of pages in the DBEFile. This value is equivalent to the DBEFMPAGES column of SYSTEM.DBEFILE and is specified with the CREATE DBEFILE statement.

Display Conventions

The full bright, inverse video bars represent the total amount of file space. The quantity of space occupied is indicated by the half bright, inverse video bars, which are delimited on the right with exclamation points.

Related SET Commands

Use the SET DBEFILESET command to improve performance and display only those tables contained in a particular DBEFileSet.



Static Cluster Screen
  		 


Static Hash Screen