Availability Guide for Problem Management

Monitoring Objects
Availability Guide for Problem Management–125509
5-11
File Utility Program (FUP)
Figure 5-3. DETAIL Format for NonStop SQL/MP Tables, Indexes, and
ENSCRIBE Files
filename date-and-time
object-type
CATALOG catalog-name
VERSION number
BASE TABLE base-table-name
TYPE file-type
CODE file-code
EXT ( pri-num PAGES, sec-num PAGES,
MAXEXTENTS max-extents)
REC record-length
PACKED REC packed-record-length
RECLENGTH max-record-length
BLOCK block-length
IBLOCK block-length
KEY ( key-descriptor )
SYSKEY
LOCKLENGTH lock-length
DCOMPRESS, ICOMPRESS
{INDEX } (key-spec, FILE alt-fnum, file-name,
{ALTKEY} key-descriptor
{UNIQUE | NO UNIQUE }
, {UPDATE | NO UPDATE}, NULL null-value)
.
.
PART ( part-num , $volume , pri-ext PAGES,
sec-ext PAGES, MAXEXTENTS max-ext,)
firstkey-value
.
ODDUNSTR
REFRESH
AUDIT
BUFFERSIZE
BUFFERED
AUDITCOMPRESS
VERIFIEDWRITES
SERIALWRITES
OWNER group-id, owner-id
SECURITY (RWEP) : rwep, PROGID, CLEARONPURGE, LICENSE
NOPURGEUNTIL: expire-time
SECONDARY PARTITION
DATA MODIF: modif, open-state
CREATION DATE: create-time
REDEFINITION DATE: redefinition-time
LAST OPEN: last-open-time
EOF eof (percent-used % USED)
EXTENTS ALLOCATED: num-ext
INDEX LEVELS: num-index-levels