Find the DB Size

[kingganesh04]

How can i find out the exact DB Size?

I used promon <dbname> then activities

Result:
DB Size 1352 MB BI Size 2168 K AI Size 0 K (Is it correct size?)

1. What is DB Szie and BI Size AI Size?

2. When some one asks me what is the size of the particular DB?
How can i find out?

 

[taqvia]

When you run promon it gives you the db size.

But to get a more clearer picture run a dbanalys against the databse. This will give you the true size of tables sum up all space for all areas this will give you more accurate info.


Arshad

 

[TomBascom]

It depends on why you want to know.

The PROMON number is the sum of the utilization in all of your storage areas. It's not very useful except perhaps as a very rough estimator.

If you need to know how much data you have then the answer re: dbanalys is appropriate. If you need to know how much disk space you have allocated and how soon you might need to allocate more then you need to pull that information out of various meta-schema tables.

 

[kingganesh04]

In the below content what is the size you mean to say?

PROGRESS Version 9.1E04 as of Fri Apr 14 22:54:32 EDT 2006

PROGRESS Database Analysis
Database: /dbs/db/tha/aat/aatcomzuq
Blocksize: 8192
Options: ixanalys tabanalys
Date: Wed Jan 21 09:49:32 2009
[Warning] database in use - reported statistics are approximations. (2486)
AREA "Control Area" : 1 BLOCK ANALYSIS
-------------------------------------------------
31 block(s) found in the area.

AREA "Schema Area" : 6 BLOCK ANALYSIS
-------------------------------------------------
3327 block(s) found in the area.

BLOCK ANALYSIS
--------------
1 master block(s) found in the database.
0 area block(s) found in the database.
1 control block(s) found in the database.
2 object block(s) found in the database.



RECORD BLOCK SUMMARY

RECORD BLOCK SUMMARY FOR AREA "Control Area" : 1
-------------------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
_Area 3 142.0B 44 53 47 3 1.0 1.0
_AreaExtent 3 181.0B 59 61 60 3 1.0 1.0
------------------------------------------------------------
Subtotals: 6 323.0B 44 61 53 6 1.0 1.0


RECORD BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.xxaddon_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxappr_hist 141 10.4K 73 76 75 141 1.0 2.2
PUB.xxaud_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxbgt_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxbo_pr_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxbuycc_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxbuy_mstr 11 1.5K 134 149 139 11 1.0 1.0
PUB.xxcmd_det 32 2.0K 62 66 64 32 1.0 2.4
PUB.xxcommdty_mstr
553 56.8K 63 147 105 553 1.0 1.5
PUB.xxdel_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxdept_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxdylic_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxdz_mstr 11 1023.0B 93 93 93 11 1.0 1.8
PUB.xxexload_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxexsusp_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxgrm_ms 1 42.0B 42 42 42 1 1.0 1.0
PUB.xxgr_det 12 1.2K 99 108 103 12 1.0 1.0
PUB.xxintf_ctrl 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxlcctrl_hist 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxlfc_mstr 1 54.0B 54 54 54 1 1.0 1.0
PUB.xxlicautl_mstr
0 0.0B 0 0 0 0 0.0 0.0
PUB.xxlicdutl_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxlicsite_mstr
1 58.0B 58 58 58 1 1.0 1.0
PUB.xxlicuact_mstr
1851 81.1K 35 48 44 1851 1.0 3.1
PUB.xxlicusg_det 161500 9.3M 53 62 60 161500 1.0 1.1
PUB.xxlicutl_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxlic_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxlvr_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxmon_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxmrc_ctrl 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxmrd_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxmr_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxoamd_hist 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxpcm_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxpird_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxpir_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxpjt_det 307 42.5K 103 186 141 311 1.0 2.3
PUB.xxpnrd_det 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxpnr_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxpobo_amd 14 1.3K 94 98 94 14 1.0 1.7
PUB.xxprct_ctrl 1 65.0B 65 65 65 1 1.0 1.0
PUB.xxprh_hist 307 64.0K 173 238 213 307 1.0 1.3
PUB.xxprj_mstr 95 16.3K 146 199 175 95 1.0 1.9
PUB.xxrfq_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxrout_det 14 406.0B 29 29 29 14 1.0 2.0
PUB.xxscm_mstr 37 2.2K 46 71 60 37 1.0 1.0
PUB.xxsco_mstr 1742 185.0K 76 124 108 1742 1.0 3.1
PUB.xxsmnd_det 1264 177.8K 92 661 144 1264 1.0 3.2
PUB.xxssa_mstr 15 2.8K 124 211 188 15 1.0 4.2
PUB.xxsusra_det 4169 245.1K 52 62 60 4169 1.0 2.7
PUB.xxsusr_mstr 1474 268.2K 121 287 186 1474 1.0 3.0
PUB.xxterm_mstr 34 4.4K 111 148 132 34 1.0 2.3
PUB.xxud_mstr 317 30.1K 76 99 97 317 1.0 1.9
PUB.xxuser_mstr 0 0.0B 0 0 0 0 0.0 0.0
PUB.xxusr_cc_mstr 115 47.4K 317 507 422 115 1.0 2.0
_Db 1 627.0B 627 627 627 1 1.0 1.0
_Field 2839 500.7K 152 286 180 3055 1.1 4.6
_Field-Trig 0 0.0B 0 0 0 0 0.0 0.0
_File 191 39.3K 156 522 210 231 1.2 5.0
_File-Trig 0 0.0B 0 0 0 0 0.0 0.0
_Index 177 16.7K 88 106 96 184 1.0 4.5
_Index-Field 363 23.2K 64 68 65 363 1.0 3.8
_Sequence 0 0.0B 0 0 0 0 0.0 0.0
_StorageObject 242 8.4K 32 38 35 242 1.0 3.9
_Sysattachtbls 0 0.0B 0 0 0 0 0.0 0.0
_Sysbigintstat 0 0.0B 0 0 0 0 0.0 0.0
_Syscalctable 1 6.0B 6 6 6 1 1.0 1.0
_Syscharstat 0 0.0B 0 0 0 0 0.0 0.0
_Syschkcolusage 0 0.0B 0 0 0 0 0.0 0.0
_Syschkconstrs 0 0.0B 0 0 0 0 0.0 0.0
_Syscolauth 0 0.0B 0 0 0 0 0.0 0.0
_Syscolstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysdatatypes 16 522.0B 24 44 32 16 1.0 2.3
_Sysdatestat 0 0.0B 0 0 0 0 0.0 0.0
_Sysdbauth 2 32.0B 12 20 16 2 1.0 4.3
_Sysdblinks 0 0.0B 0 0 0 0 0.0 0.0
_Sysfloatstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysidxstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysintstat 0 0.0B 0 0 0 0 0.0 0.0
_Syskeycolusage 0 0.0B 0 0 0 0 0.0 0.0
_Sysncharstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysnumstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysnvarcharstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysprocbin 0 0.0B 0 0 0 0 0.0 0.0
_Sysproccolumns 202 8.6K 38 51 43 202 1.0 1.2
_Sysprocedures 12 730.0B 53 69 60 12 1.0 2.5
_Sysproctext 0 0.0B 0 0 0 0 0.0 0.0
_Sysrealstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysrefconstrs 0 0.0B 0 0 0 0 0.0 0.0
_Syssmintstat 0 0.0B 0 0 0 0 0.0 0.0
_Syssynonyms 0 0.0B 0 0 0 0 0.0 0.0
_Systabauth 243 14.0K 42 80 59 243 1.0 3.9
_Systblconstrs 0 0.0B 0 0 0 0 0.0 0.0
_Systblstat 0 0.0B 0 0 0 0 0.0 0.0
_Systimestat 0 0.0B 0 0 0 0 0.0 0.0
_Systinyintstat 0 0.0B 0 0 0 0 0.0 0.0
_Systrigcols 0 0.0B 0 0 0 0 0.0 0.0
_Systrigger 0 0.0B 0 0 0 0 0.0 0.0
_Systsstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysvarcharstat 0 0.0B 0 0 0 0 0.0 0.0
_Sysviews 42 6.2K 73 1090 151 42 1.0 3.1
_User 0 0.0B 0 0 0 0 0.0 0.0
_View 0 0.0B 0 0 0 0 0.0 0.0
_View-Col 0 0.0B 0 0 0 0 0.0 0.0
_View-Ref 0 0.0B 0 0 0 0 0.0 0.0
------------------------------------------------------------
Subtotals: 178350 11.1M 6 1090 65 178617 1.0 3.1


------------------------------------------------------------
Totals: 178356 11.1M 6 1090 65 178623 1.0 3.1

2838 RM block(s) found in the database.
51.84% of the RM block space is used.



INDEX BLOCK SUMMARY

INDEX BLOCK SUMMARY FOR AREA "Control Area" : 1
-------------------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
_Area
_Area-Number 1027 1 1 1 34.0B 0.4 1.0
_AreaExtent
_AreaExtent-Area 1028 2 1 1 40.0B 0.5 1.0

INDEX BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
PUB.xxaddon_mstr
xxaddon_idx01 12 2 1 1 3.0B 0.0 1.0
PUB.xxappr_hist
xxappr_indx1 39 5 1 1 1.7K 21.0 1.0
xxappr_indx2 40 6 1 1 1.5K 19.2 1.0
xxappr_indx3 41 5 1 1 3.3K 41.2 1.0
PUB.xxaud_det
xxaud_dataset 9 10 1 1 3.0B 0.0 1.0
xxaud_entry 8 1 1 1 3.0B 0.0 1.0
xxaud_user 10 3 1 1 3.0B 0.0 1.0
PUB.xxbgt_mstr
xxbgt_indx1 42 3 1 1 3.0B 0.0 1.0
PUB.xxbo_pr_mstr
xxbo_nbr 44 4 1 1 3.0B 0.0 1.0
xxbo_pc_nbr 43 5 1 1 3.0B 0.0 1.0
PUB.xxbuycc_det
xxbuycc_indx1 45 2 1 1 3.0B 0.0 1.0
PUB.xxbuy_mstr
xxbuy_indx1 46 1 1 1 178.0B 2.2 1.0
PUB.xxcmd_det
xxcmd_idx1 47 4 1 1 679.0B 8.3 1.0
PUB.xxcommdty_mstr
xxcommdty_idx1 48 2 1 1 5.3K 67.0 1.0
xxcommdty_idx2 49 1 1 1 5.0K 63.0 1.0
PUB.xxdel_mstr
xxdel_indx1 11 2 1 1 3.0B 0.0 1.0
PUB.xxdept_mstr
xxdept_indx01 13 2 1 1 3.0B 0.0 1.0
PUB.xxdylic_mstr
xxdylic_mkt_indx 14 1 1 1 3.0B 0.0 1.0
PUB.xxdz_mstr
xxdz_indx1 50 2 1 1 168.0B 2.1 1.0
xxdz_indx2 51 1 1 1 111.0B 1.4 1.0
PUB.xxexload_mstr
xxexl_index 28 2 1 1 3.0B 0.0 1.0
xxexl_index1 29 3 1 1 3.0B 0.0 1.0
PUB.xxexsusp_det
xxexs_pk 30 3 1 1 3.0B 0.0 1.0
PUB.xxgrm_ms
xx_grid 76 2 1 1 26.0B 0.3 1.0
PUB.xxgr_det
xxgr_grp_usr 77 3 1 1 206.0B 2.5 1.0
PUB.xxintf_ctrl
xxintf_idx 27 3 1 1 3.0B 0.0 1.0
PUB.xxlcctrl_hist
xxlcctrl_indx01 24 3 1 1 3.0B 0.0 1.0
PUB.xxlfc_mstr
xxlfc_func 26 1 1 1 22.0B 0.3 1.0
PUB.xxlicautl_mstr
default 25 0 1 1 3.0B 0.0 1.0
PUB.xxlicdutl_det
xxlicdutl_idx01 15 4 1 1 3.0B 0.0 1.0
PUB.xxlicsite_mstr
xxlicsite_idx01 16 1 1 1 18.0B 0.2 1.0
PUB.xxlicuact_mstr
xxlicuact_idx01 17 3 2 7 25.4K 45.4 2.3
PUB.xxlicusg_det
xxlicusg_idx01 18 4 2 295 2.2M 95.6 1.5
PUB.xxlicutl_mstr
xxlicutl_indx01 19 6 1 1 3.0B 0.0 1.0
PUB.xxlic_mstr
xxlic_idx01 20 1 1 1 3.0B 0.0 1.0
PUB.xxlvr_det
default 23 0 1 1 3.0B 0.0 1.0
PUB.xxmon_mstr
xxmon_idx01 21 5 1 1 3.0B 0.0 1.0
PUB.xxmrc_ctrl
default 54 0 1 1 3.0B 0.0 1.0
PUB.xxmrd_det
xxmrd_indx1 55 2 1 1 3.0B 0.0 1.0
PUB.xxmr_mstr
xxmr_indx1 56 1 1 1 3.0B 0.0 1.0
PUB.xxoamd_hist
default 57 0 1 1 3.0B 0.0 1.0
PUB.xxpcm_mstr
xxpcm_part 59 4 1 1 3.0B 0.0 1.0
xxpcm_rfq 58 6 1 1 3.0B 0.0 1.0
PUB.xxpird_det
xxpird_indx1 60 2 1 1 3.0B 0.0 1.0
PUB.xxpir_mstr
xxpir_indx1 61 1 1 1 3.0B 0.0 1.0
PUB.xxpjt_det
xxpjt_ind1 78 3 1 1 2.9K 37.0 1.0
PUB.xxpnrd_det
xxpnrd_idx1 63 3 1 1 3.0B 0.0 1.0
PUB.xxpnr_mstr
xxpnr_idx1 64 2 1 1 3.0B 0.0 1.0
PUB.xxpobo_amd
xxpobo_indx1 65 1 1 1 141.0B 1.7 1.0
PUB.xxprct_ctrl
default 66 0 1 1 17.0B 0.2 1.0
PUB.xxprh_hist
xxprh_index 67 4 1 1 6.8K 85.8 1.0
PUB.xxprj_mstr
xxprj_indx1 79 2 1 1 920.0B 11.3 1.0
xxprj_indx2 69 4 1 1 1.9K 24.0 1.0
xxprj_indx3 70 3 1 1 1.9K 24.0 1.0
PUB.xxrfq_mstr
xxrfq_indx1 71 1 1 1 3.0B 0.0 1.0
PUB.xxrout_det
xxrout_indx1 72 2 1 1 144.0B 1.8 1.0
PUB.xxscm_mstr
xxscm_choice 38 2 1 1 372.0B 4.6 1.0
PUB.xxsco_mstr
xxsco_idx1 31 1 2 4 17.0K 53.3 2.1
xxsco_idx2 32 2 2 4 16.3K 51.1 2.2
xxsco_idx3 33 2 2 4 20.4K 64.0 2.0
PUB.xxsmnd_det
xxsmnd_idx1 34 3 2 3 15.0K 62.7 2.0
PUB.xxssa_mstr
xxssa_indx1 36 2 1 1 728.0B 8.9 1.0
PUB.xxsusra_det
xxsusra_idx1 37 3 2 11 72.1K 82.2 1.7
PUB.xxsusr_mstr
xxsusr_idx1 35 1 2 3 14.4K 60.2 2.0
PUB.xxterm_mstr
xxterm_indx1 73 2 1 1 580.0B 7.1 1.0
PUB.xxud_mstr
xxud_indx1 74 4 1 1 4.6K 57.7 1.0
PUB.xxuser_mstr
xxuser_indx1 22 3 1 1 3.0B 0.0 1.0
PUB.xxusr_cc_mstr
xxusr_idx1 80 2 1 1 3.1K 39.0 1.0
_Db
_Database 1023 1 1 1 17.0B 0.2 1.0
_Field
_Field-Name 3 2 2 9 41.8K 58.3 2.1
_Field-Position 4 2 2 7 25.6K 45.9 2.3
_File/Field 2 2 2 8 36.0K 56.4 2.1
_Field-Trig
_Field-Trig-DBK 1020 1 1 1 3.0B 0.0 1.0
_Field-Trig-Rpos 1021 3 1 1 3.0B 0.0 1.0
_File
_Db/File 1022 3 1 1 3.8K 48.1 1.0
_Dump-Name 1024 3 1 1 1.7K 21.7 1.0
_File-Name 1 1 1 1 2.8K 34.6 1.0
_File-Number 1032 1 1 1 1.7K 21.2 1.0
_File-Trig
_File-Trig 1000 2 1 1 3.0B 0.0 1.0
_Index
_File/Index 5 2 1 1 3.6K 44.8 1.0
_Index-Name 999 1 1 1 2.6K 32.5 1.0
_Index-Number 1033 1 1 1 1.6K 19.7 1.0
_Index-Field
_Field 7 1 1 1 3.0K 37.3 1.0
_Index/Number 6 2 1 1 3.6K 44.8 1.0
_Sequence
_Seq-Name 1025 2 1 1 3.0B 0.0 1.0
_StorageObject
_Object-Id 1026 3 1 1 2.1K 26.9 1.0
_Sysattachtbls
_Idxsysattachtbls 1071 1 1 1 3.0B 0.0 1.0
_Sysbigintstat
_Idxsysbigintstat 1063 2 1 1 3.0B 0.0 1.0
_Syscalctable
_Idxsyscalctable 1070 1 1 1 17.0B 0.2 1.0
_Syscharstat
_Idxsyscharstat 1046 3 1 1 3.0B 0.0 1.0
_Syschkcolusage
_Idxchkcolcolusage 1041 3 1 1 3.0B 0.0 1.0
_Idxchkcolusage 1039 3 1 1 3.0B 0.0 1.0
_Syschkconstrs
_Idxchkconstrs 1038 3 1 1 3.0B 0.0 1.0
_Syscolauth
_Idxsyscolauth 1059 4 1 1 3.0B 0.0 1.0
_Syscolstat
_Idxsyscolstat 1045 3 1 1 3.0B 0.0 1.0
_Sysdatatypes
_Idxsysdatatypes 1069 1 1 1 152.0B 1.9 1.0
_Sysdatestat
_Idxsysdatestat 1047 3 1 1 3.0B 0.0 1.0
_Sysdbauth
_Idxsysdbauth 1066 1 1 1 37.0B 0.5 1.0
_Sysdblinks
_Idxsysdblinks 1068 1 1 1 3.0B 0.0 1.0
_Sysfloatstat
_Idxsysfloatstat 1058 3 1 1 3.0B 0.0 1.0
_Sysidxstat
_Idxsysidxstat 1044 2 1 1 3.0B 0.0 1.0
_Sysintstat
_Idxsysintstat 1048 3 1 1 3.0B 0.0 1.0
_Syskeycolusage
_Idxkeycolusage 1037 4 1 1 3.0B 0.0 1.0
_Sysncharstat
_Idxsysncharstat 1056 3 1 1 3.0B 0.0 1.0
_Sysnumstat
_Idxsysnumstat 1050 3 1 1 3.0B 0.0 1.0
_Sysnvarcharstat
_Idxsysnvarcharstat 1057 3 1 1 3.0B 0.0 1.0
_Sysprocbin
_Idxsysprocbin 1064 2 1 1 3.0B 0.0 1.0
_Sysproccolumns
_Idxsysproccolumns 1072 1 1 1 313.0B 3.8 1.0
_Sysprocedures
_Idxsysprocedures 1065 1 1 1 178.0B 2.2 1.0
_Sysproctext
_Idxsysproctext 1074 1 1 1 3.0B 0.0 1.0
_Sysrealstat
_Idxsysrealstat 1052 3 1 1 3.0B 0.0 1.0
_Sysrefconstrs
_Idxrefcnstrsref 1042 3 1 1 3.0B 0.0 1.0
_Idxrefconstrs 1040 3 1 1 3.0B 0.0 1.0
_Syssmintstat
_Idxsyssmintstat 1051 3 1 1 3.0B 0.0 1.0
_Syssynonyms
_Sysprvsynidx 1034 3 1 1 3.0B 0.0 1.0
_Syspubsynidx 1035 1 1 1 3.0B 0.0 1.0
_Systabauth
_Idxsystabauth 1060 4 1 1 7.3K 91.1 1.0
_Idxsystabauth1 1061 1 1 1 2.3K 29.1 1.0
_Systblconstrs
_Idxtblconstrs 1036 3 1 1 3.0B 0.0 1.0
_Systblstat
_Idxsystblstat 1043 2 1 1 3.0B 0.0 1.0
_Systimestat
_Idxsystimestat 1053 3 1 1 3.0B 0.0 1.0
_Systinyintstat
_Idxsystinyintstat 1062 2 1 1 3.0B 0.0 1.0
_Systrigcols
_Idxsystrigcols 1073 1 1 1 3.0B 0.0 1.0
_Systrigger
_Idxsystrigger 1067 1 1 1 3.0B 0.0 1.0
_Systsstat
_Idxsystsstat 1054 3 1 1 3.0B 0.0 1.0
_Sysvarcharstat
_Idxsysvarcharstat 1055 3 1 1 3.0B 0.0 1.0
_Sysviews
_Viewidx 1031 3 1 1 744.0B 9.1 1.0
_User
_Userid 0 1 1 1 3.0B 0.0 1.0
_View
_View-Name 994 1 1 1 3.0B 0.0 1.0
_View-Col
_Vcol-Position 996 2 1 1 3.0B 0.0 1.0
_View-Col 995 2 1 1 3.0B 0.0 1.0
_View-Ref
_View-Ref 997 2 1 1 3.0B 0.0 1.0
_Vref-View 998 1 1 1 3.0B 0.0 1.0
-----------------------------------------------------------
Totals: 479 2.6M 68.4 1.5

479 index block(s) found in the database.
68.41% of the index block space is used.



DATABASE SUMMARY

SUMMARY FOR AREA "Control Area" : 1
-------------------------------------------------------
Records Indexes Combined
NAME Size Tot % Size Tot % Size Tot %
_Area 142.0B 0.0 34.0B 0.0 176.0B 0.0
_AreaExtent 181.0B 0.0 40.0B 0.0 221.0B 0.0

SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
Records Indexes Combined
NAME Size Tot % Size Tot % Size Tot %
PUB.xxaddon_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxappr_hist 10.4K 0.1 6.5K 0.0 16.9K 0.1
PUB.xxaud_det 0.0B 0.0 9.0B 0.0 9.0B 0.0
PUB.xxbgt_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxbo_pr_mstr 0.0B 0.0 6.0B 0.0 6.0B 0.0
PUB.xxbuycc_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxbuy_mstr 1.5K 0.0 178.0B 0.0 1.7K 0.0
PUB.xxcmd_det 2.0K 0.0 679.0B 0.0 2.7K 0.0
PUB.xxcommdty_mstr 56.8K 0.4 10.4K 0.1 67.2K 0.5
PUB.xxdel_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxdept_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxdylic_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxdz_mstr 1023.0B 0.0 279.0B 0.0 1.3K 0.0
PUB.xxexload_mstr 0.0B 0.0 6.0B 0.0 6.0B 0.0
PUB.xxexsusp_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxgrm_ms 42.0B 0.0 26.0B 0.0 68.0B 0.0
PUB.xxgr_det 1.2K 0.0 206.0B 0.0 1.4K 0.0
PUB.xxintf_ctrl 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxlcctrl_hist 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxlfc_mstr 54.0B 0.0 22.0B 0.0 76.0B 0.0
PUB.xxlicautl_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxlicdutl_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxlicsite_mstr 58.0B 0.0 18.0B 0.0 76.0B 0.0
PUB.xxlicuact_mstr 81.1K 0.6 25.4K 0.2 106.5K 0.8
PUB.xxlicusg_det 9.3M 68.0 2.2M 16.1 11.5M 84.1
PUB.xxlicutl_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxlic_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxlvr_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxmon_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxmrc_ctrl 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxmrd_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxmr_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxoamd_hist 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxpcm_mstr 0.0B 0.0 6.0B 0.0 6.0B 0.0
PUB.xxpird_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxpir_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxpjt_det 42.5K 0.3 2.9K 0.0 45.4K 0.3
PUB.xxpnrd_det 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxpnr_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxpobo_amd 1.3K 0.0 141.0B 0.0 1.4K 0.0
PUB.xxprct_ctrl 65.0B 0.0 17.0B 0.0 82.0B 0.0
PUB.xxprh_hist 64.0K 0.5 6.8K 0.0 70.8K 0.5
PUB.xxprj_mstr 16.3K 0.1 4.7K 0.0 21.0K 0.1
PUB.xxrfq_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxrout_det 406.0B 0.0 144.0B 0.0 550.0B 0.0
PUB.xxscm_mstr 2.2K 0.0 372.0B 0.0 2.5K 0.0
PUB.xxsco_mstr 185.0K 1.3 53.7K 0.4 238.7K 1.7
PUB.xxsmnd_det 177.8K 1.3 15.0K 0.1 192.8K 1.4
PUB.xxssa_mstr 2.8K 0.0 728.0B 0.0 3.5K 0.0
PUB.xxsusra_det 245.1K 1.8 72.1K 0.5 317.2K 2.3
PUB.xxsusr_mstr 268.2K 1.9 14.4K 0.1 282.6K 2.0
PUB.xxterm_mstr 4.4K 0.0 580.0B 0.0 5.0K 0.0
PUB.xxud_mstr 30.1K 0.2 4.6K 0.0 34.7K 0.2
PUB.xxuser_mstr 0.0B 0.0 3.0B 0.0 3.0B 0.0
PUB.xxusr_cc_mstr 47.4K 0.3 3.1K 0.0 50.5K 0.4
_Db 627.0B 0.0 17.0B 0.0 644.0B 0.0
_Field 500.7K 3.6 103.4K 0.7 604.1K 4.3
_Field-Trig 0.0B 0.0 6.0B 0.0 6.0B 0.0
_File 39.3K 0.3 10.0K 0.1 49.3K 0.4
_File-Trig 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Index 16.7K 0.1 7.7K 0.1 24.4K 0.2
_Index-Field 23.2K 0.2 6.5K 0.0 29.7K 0.2
_Sequence 0.0B 0.0 3.0B 0.0 3.0B 0.0
_StorageObject 8.4K 0.1 2.1K 0.0 10.5K 0.1
_Sysattachtbls 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysbigintstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Syscalctable 6.0B 0.0 17.0B 0.0 23.0B 0.0
_Syscharstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Syschkcolusage 0.0B 0.0 6.0B 0.0 6.0B 0.0
_Syschkconstrs 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Syscolauth 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Syscolstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysdatatypes 522.0B 0.0 152.0B 0.0 674.0B 0.0
_Sysdatestat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysdbauth 32.0B 0.0 37.0B 0.0 69.0B 0.0
_Sysdblinks 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysfloatstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysidxstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysintstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Syskeycolusage 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysncharstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysnumstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysnvarcharstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysprocbin 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysproccolumns 8.6K 0.1 313.0B 0.0 8.9K 0.1
_Sysprocedures 730.0B 0.0 178.0B 0.0 908.0B 0.0
_Sysproctext 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysrealstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysrefconstrs 0.0B 0.0 6.0B 0.0 6.0B 0.0
_Syssmintstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Syssynonyms 0.0B 0.0 6.0B 0.0 6.0B 0.0
_Systabauth 14.0K 0.1 9.6K 0.1 23.6K 0.2
_Systblconstrs 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Systblstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Systimestat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Systinyintstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Systrigcols 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Systrigger 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Systsstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysvarcharstat 0.0B 0.0 3.0B 0.0 3.0B 0.0
_Sysviews 6.2K 0.0 744.0B 0.0 6.9K 0.0
_User 0.0B 0.0 3.0B 0.0 3.0B 0.0
_View 0.0B 0.0 3.0B 0.0 3.0B 0.0
_View-Col 0.0B 0.0 6.0B 0.0 6.0B 0.0
_View-Ref 0.0B 0.0 6.0B 0.0 6.0B 0.0
-----------------------------------------------------------
Total 11.1M 81.3 2.6M 18.7 13.7M(This is the size) 100.0
Size key:
B = bytes
K = kilobytes
M = megabytes
G = gigabytes
T = terabytes

0 free block(s) found in the database.
0 index table block(s) found in the database.
1 sequence block(s) found in the database.
36 empty block(s) found in the database.
3358 total blocks found in the database.
[Warning] database in use - reported statistics are approximations. (2486)
database analysis complete Wed Jan 21 09:49:34 2009