TEST - HOWMESSY REPORT - 07/17/01
DATA BASE NAME SET NAME SET NBR TYPE CAPACITY ENTRIES LOAD FACTOR SECONDARIES MAX BLOCKS BLOCK FACT SORT PRI HIGH WATER SEARCH FIELD MAX CHAIN AVE CHAIN STD DEV EXP BLKS AVE BLKS INEFF PTRS ELONG
APB001.APDATA.TEST VENDOR 3 M 7507 4047 53 21 7 0 4 VENDORNO 5 1.28 .55 1.00 1.25 20.91 1.25
WRKPAY 11 D 260 14 5 0 0 14 ! 10 DIVNO 14 14.00 .00 2.00 2.00 7.14 1.00
VENDSRCH 21 D 7521 4047 53 0 0 4047 ! 23 NAMESRCH 61 3.00 4.23 1.01 2.81 60.32 2.79
CITYSRCH 436 5.47 20.26 1.08 4.44 62.94 4.10
STATESRCH 1384 62.26 197.45 3.38 25.20 38.87 7.45
ZIPSRCH 802 8.00 39.95 1.18 5.60 57.57 4.74
GLB001.GLDATA.TEST XACDPT 10 D 5004 252 5 0 0 252 S 9 DVDPT 156 126.00 42.43 14.50 120.00 94.44 8.28
DEPTNO 156 126.00 42.43 14.50 120.00 94.44 8.28
SEARCHKEY 192 126.00 93.34 14.50 125.00 98.41 8.62
DIVNO 252 252.00 .00 28.00 250.00 98.81 8.93
ACCOUNT 2 1.62 .49 1.00 1.62 38.10 1.62
JCPLDB.MACSDATA.TEST ZIP-MAST 1 A 62417 43690 70 31 1 0 91 ZIP-CODE 6 1.46 .73 1.00 1.00 .16 1.00
LINE-XREF 4 D 362480 90598 24 0 0 90598 ! 23 ORDER-NO 140 2.60 3.17 1.00 1.15 5.85 1.15
MACACT.MACSDATA.TEST MACS-ACCOUNTS 1 M 281 50 17 2 3 0 1 SEARCH-ID 2 1.02 .14 1.02 2.00 100.00 1.96
MACITM.MACSDATA.TEST CHAIN-ACTIONS 10 A 809 98 12 6 0 0 119 CHAIN-ACTION 2 1.07 .25 1.00 1.17 16.67 1.17
MOD-ACCESS 27 M 853 389 45 22 2 0 6 USER-ID 4 1.30 .56 1.00 1.07 5.62 1.07
UPSELL 29 M 4751 2146 45 18 2 0 5 UPSELL-KEY 5 1.23 .48 1.00 1.09 8.33 1.09
WHSE-LOCS 31 M 21613 11155 51 21 1 0 21 WAREHOUSE-LOC 5 1.28 .55 1.00 1.00 .16 1.00
OFFER-ITEMS 34 M 7307 3338 45 19 1 0 10 OFFER-ITEM 5 1.25 .51 1.00 1.01 .76 1.01
PO-HEADER 43 M 21613 7803 36 11 18 0 13 PO-NUMBER 3 1.13 .35 1.00 1.55 52.95 1.55
ZONES 44 M 10831 4715 43 58 644 0 5 ZONE-SEARCH 5 2.40 1.06 1.00 2.77 89.50 2.77
PH-DOLLARS 45 M 919 403 43 20 1 0 7 PH-SM-RANGE 4 1.25 .52 1.00 1.17 14.81 1.17
USER-SNAPSHOT 48 M 1201 213 17 7 3 0 2 USER-DATE 3 1.09 .32 1.01 1.47 41.18 1.45
KIT-INDEX 53 D 45036 908 2 0 0 908 ! 54 EDP-NO 7 1.90 1.03 1.00 1.01 .55 1.01
COMPONENT-NO 9 1.23 .74 1.00 1.06 5.07 1.06
INV-DETAILS 54 D 25020 7022 28 0 0 7898 S ! 36 EDP-NO 50 3.01 4.14 1.00 2.85 61.44 2.84
WAREHOUSE-LOC 153 2.33 5.21 1.00 2.23 52.55 2.21
CHAINS 56 D 759 98 12 0 0 98 S ! 11 CHAIN-NO 8 7.54 1.66 1.00 2.46 19.39 2.46
CORRESPONDENCE 63 D 2016 401 19 0 0 401 S ! 18 CORR-CODE 30 12.53 8.95 1.25 3.16 17.21 2.53
PO-DETAILS 65 D 35010 20116 57 0 0 20116 S ! 15 PO-NUMBER 146 2.79 4.53 1.02 1.15 5.35 1.12
EDP-NO 41 3.83 4.25 1.03 3.12 55.51 3.03
VENDOR-NO 928 28.41 83.77 2.51 7.99 24.59 3.18
VENDOR-ITEMS 68 D 45000 23634 52 0 0 23634 S ! 9 EDP-NO 6 1.02 .17 1.00 1.02 2.05 1.02
ITEM-NO 5 1.00 .08 1.00 1.00 .20 1.00
VENDOR-NO 996 15.39 57.84 2.35 3.89 18.77 1.66
EDP-ITEM-XREF 69 D 405195 131184 32 0 0 176403 ! 85 EDP-NO 8 5.67 .68 1.00 3.67 47.18 3.67
REF-ITEM-NO 3 1.21 .41 1.00 1.00 .32 1.00
INVENTORY-TRANS 70 D 262632 90963 34 0 0 90963 ! 24 EDP-NO 393 23.82 28.79 1.59 16.99 67.13 10.69
TRANSACTION-NO 2123 5.56 20.32 1.06 1.88 15.75 1.77
FROM-REF 11418 11.56 188.45 1.33 3.27 19.65 2.46
ADDED-DATA-4 79 D 437400 150625 34 0 0 150625 ! 30 GENERIC-SEARCH 10692 4303.57 3761.75 144.11 144.37 3.33 1.00
MACMAN.MACSDATA.TEST AB-ROUTING-DETL 11 M 117937 45849 38 20 1 0 23 AB-ZIP-CODE 6 1.26 .53 1.00 1.04 3.32 1.04
FX-ROUT-DETAIL 12 M 134887 52451 38 21 15 0 3 FX-WHSE-ZIP 7 1.27 .57 1.01 1.80 64.89 1.78
WAREHOUSE-MASTER 13 M 251 20 7 10 9 0 1 WHSE-CODE 2 1.11 .32 1.11 2.00 100.00 1.80
SHIPPER-DATA 14 M 751 79 10 10 2 0 2 CO-DIV-WHSE-SM 3 1.11 .36 1.01 1.29 25.00 1.27
CODIVSMAUTO 17 A 379 111 29 6 0 0 81 CO-DIV-SM 2 1.07 .25 1.00 1.14 14.29 1.14
SHIP-METHODS 19 D 375 111 29 0 0 111 ! 5 CO-DIV 34 22.20 13.52 5.00 10.60 43.24 2.12
CO-DIV-SMGROUP 12 2.85 3.40 1.21 2.03 36.04 1.68
UPS-ROUT-DETAIL 20 M 46807 22309 47 23 1 0 20 UPS-WHSE-ZIP 6 1.30 .59 1.00 1.06 5.25 1.06
MACORD.MACSDATA.TEST ORDER-SEARCH 8 A 122533 57828 47 20 0 0 35 XREF-NO 6 1.27 .55 1.00 1.00 .04 1.00
OH-ADDITIONS 17 M 37811 19918 52 22 3 0 17 FULL-ORDER-NO 5 1.28 .55 1.00 1.02 1.36 1.02
PICK-LOT-HEADER 18 M 81097 28970 35 16 1 0 14 LOT-NO 5 1.19 .45 1.00 1.00 .09 1.00
CUST-XREF 26 D 2520 871 34 0 0 871 35 CUST-EDP 2 1.00 .03 1.00 1.00 .11 1.00
XREF-NO 21 1.02 .69 1.00 1.00 .23 1.00
ORDER-HEADER 27 D 37800 19948 52 0 0 19948 ! 10 CUST-EDP 484 415.58 135.09 42.00 413.83 99.34 9.85
ORDER-SUB-HEAD 28 D 244950 110913 45 0 0 110913 S ! 15 ORDER-NO 52 5.56 5.55 1.07 1.64 11.56 1.54
BO-FILE 33 D 3000 10 0 0 0 698 ! 30 EDP-NO 2 1.11 .33 1.00 1.11 10.00 1.11
ACTIONS 34 D 841 104 12 0 0 109 ! 29 CUST-EDP 11 2.81 2.00 1.00 2.38 49.04 2.38
PROCESSING 40 D 21000 615 2 0 0 7422 ! 6 ACTION-SEARCH 343 87.86 121.22 15.29 79.00 88.78 5.17
RETURNS 41 D 816 85 10 0 0 85 ! 17 CONTROL-1 9 2.83 2.78 1.00 1.10 3.53 1.10
ORDER-XREF 45 D 113490 57897 51 0 0 57897 ! 26 XREF-NO 14 1.00 .06 1.00 1.00 .09 1.00
PICK-LOT-DETAIL 47 D 787320 284841 36 0 0 284852 ! 10 LOT-NO 116 10.04 11.21 1.52 1.92 9.16 1.26
SGBASE.SGADATA.TEST BAROMETERS 4 M 167 67 40 17 2 0 6 BAR-NAME 3 1.22 .50 1.00 1.20 16.67 1.20
ERR-MSG-CAT 6 M 9587 3983 41 19 2 0 19 ERR-MSG-NO 5 1.24 .52 1.00 1.03 2.20 1.03
SCREEN-ELEMENTS 7 D 106582 44750 41 0 0 44750 S ! 23 SCREEN-NAME 149 27.19 26.04 1.72 6.13 18.88 3.56
SCREEN-SOFTKEYS 8 D 1690 697 41 0 0 697 S ! 13 SCREEN-NAME 11 1.76 1.51 1.00 1.36 20.23 1.36
CODE-DESC 9 D 2592 1099 42 0 0 1099 12 CODE-KEY 13 1.02 .39 1.00 1.01 1.18 1.01
TYPE 107 8.33 14.33 1.39 5.01 48.13 3.59
PRINT-ELEMENTS 10 D 64550 25982 40 0 0 26338 S ! 25 SCREEN-NAME 199 28.40 23.08 1.64 6.81 20.45 4.16
USER-SCREEN-EL 12 D 5000 261 5 0 0 261 S ! 25 SCREEN-NAME 96 52.20 25.22 2.40 4.00 5.75 1.67
USER-PRINT-EL 13 D 5000 35 0 0 0 35 S ! 25 SCREEN-NAME 35 35.00 .00 2.00 2.00 2.86 1.00
SGHELP.SGADATA.TEST SCREEN-ELEMS 1 A 3761 2631 69 27 1 0 33 SCREEN-ELEM 6 1.37 .65 1.00 1.01 .42 1.01
HELP-DETAILS 2 D 4332 3031 69 0 0 3033 S ! 1 SCREEN-ELEM 15 1.15 .77 1.15 1.15 13.23 1.00