File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-120
INFO STATISTICS Listing Format Examples

To display the FUP INFO, STATISTICS, PARTIAL listing for a key-sequenced,
partitioned file with 48989 records and an EOF of 6983680:
-INFO SPECIALK,STAT,PARTIAL 10
$GRAIN.CEREAL.SPECIALK 17 Feb 2001, 11:44
*****PARTIAL STATISTICS: 10% OF FILE*****
AVG # AVG AVG %
LEVEL BLOCKS RECS RECS SLACK SLACK
2 1 14 14.0 3760 92
1 1 75 75.0 2054 50
DATA 166 4840 29.2 1363 33
FREE 0
BITMAP 1

To display the FUP INFO, STATISTICS, PARTIAL listing for a partitioned SQL/MX
table:
-INFO WWVL3T00, STAT, PARTIAL 30
(DETAIL option listing displays first, followed by this)
***** PARTIAL STATISTICS: 30% OF FILE *****
AVG # AVG AVG %
LEVEL BLOCKS RECS RECS SLACK SLACK PART
1 1 1 1.0 4036 99
$D1103.ZSDL2BDF.WWVL3T00
DATA 1 19 19.0 3170 77
FREE 0
BITMAP 1
1 1 3 3.0 4012 98
$D1103.ZSDL2BDF.J4XL3T00
DATA 3 179 59.7 1299 32
FREE 0
BITMAP 1

To display the FUP INFO, STATISTICS, PARTONLY listing for a partitioned
SQL/MX table using ANSI name:
-INFO 'TABLE
CAT_ANSINAME01.SCH_ANSINAME01.TAB1',STAT,PARTONLY
$DATA05.ZSDHKPKT.CGJC4500 16 Nov 2005, 0:38
SQL ANSI TABLE
ANSI NAME CAT_ANSINAME01.SCH_ANSINAME01.TAB1
RESOURCE FORK \DRP42.$DATA05.ZSDHKPKT.CGJC4501
SYSTEM METADATA \DRP42.$DATA05.ZSD0
VERSION 1200
TYPE K
FORMAT 2
CODE 550
EXT ( 16 PAGES, 64 PAGES, MAXEXTENTS 160 )
PACKED REC 12
BLOCK 4096
KEY ( COLUMN 0, ASC )
INDEX ( 0, \DRP42.$DATA05.ZSDHKPKT.DK8CK600 )
PART ( 0, \DRP42.$DATA05.ZSDHKPKT.CGJC4500 )
PART ( 1, \DRP42.$DATA1.ZSDHKPKT.J1C73500 )
PART ( 2, \DRP42.$DATA2.ZSDHKPKT.KD973500 )