HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Static Screen 

This screen lists information about indexes, referential constraints, and
hash structures for each table contained in a DBEFileSet.


            

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

Field Definitions 

DBEFILESET       The name of the DBEFileSet.

HASH?            An asterisk in this field indicates a hashed table.  A
                 table is hashed if the UNIQUE HASH ON or HASH ON
                 CONSTRAINT clauses are included in the CREATE TABLE
                 statement.

IMAGE?           An asterisk in this field indicates that 
                 the table is stored in a TurboIMAGE data set instead of
                 in ALLBASE/SQL DBEFileSets.

NUMIDX           The number of indexes and referential constraints
                 defined on the table.

TYPE             The table type, as defined by the CREATE TABLE
                 statement.  You can use the ALTER TABLE statement to
                 change the table type. 

OWNER.TABLE      The names of the tables contained within the DBEFileSet.
                 Long column data is stored in internal ALLBASE/SQL
                 tables which have no entries in SYSTEM.TABLE. To
                 construct a name for these tables, SQLMON appends the
                 column number of the long column to the table name.  For
                 example, the PURCHDB.REPORTS(3) entry represents the
                 table that holds the long column data of the third
                 column of the PURCHDB.REPORTS table.

MPE/iX 5.0 Documentation