Information for LOB fields reported by dbanalys

Information for LOB fields reported when running DBANALYS.
Size of BLOB and CLOB reported with PROUTIL -C dbanalys.
PROUTIL DBANALYS statistics for LOB objects.
How to find the space used by LOB objects in dbanalys reports
When are lob sizes reported in TABANALYS
 

Since OpenEdge 11.6 LOB support in database analysis reports was introduced.

1.  Enhanced database analysis utilities PROUTIL DBANALYS and TABANALYS include LOB data.
2.  When LOB data are found, a “LOB Summary” follows the “Record Block Summary” in the report and LOB data are also included in the combined summary.
3.  When the -csoutput parameter is used on the analysis command line, LOB data is written to a new *.lob.txt file
4.  When a DBANALYS and TABANALYS report is run for a specified area [area-name] :

• When LOB data are not found, only the “Record Block Summary” is printed.
• When LOB data are found without the associated table data, the following message is printed:

Example: 11.7.5 DBANALYS Report

RECORD BLOCK SUMMARY                                                    
RECORD BLOCK SUMMARY FOR AREA "Mislob": 17                                                          
                                             -Record Size (B)-           ---Fragments--- Scatter    
Table                      Records    Size   Min   Max  Mean                Count Factor  Factor    
PUB.testdata                   500   18.9K    37    39    38                  500    1.0     1.3    
                                                                                                    
                                  LOB SUMMARY                                                       
LOB SUMMARY FOR AREA Mislob: 17                                                                     
                                                               ---    LOB Size   ---                
Table                      LOBs     Size      Min      Max     Mean                                 
PUB.testdata:27                                                                                     
    blobdata:5              500   732.9M     1.4M     8.2M    4.8M                                  
                                                                                                    
                              INDEX BLOCK SUMMARY                                                   
INDEX BLOCK SUMMARY FOR AREA "Mislob": 17                                                           
Table                      Index  Fields Levels         Blocks    Size  % Util  Factor              
PUB.testdata                                                                                        
  testIDX                     67       1      2              3    4.4K    37.2     2.3              
                                                                                                    
                             DATABASE SUMMARY                                                       
SUMMARY FOR AREA "Mislob": 17                                                                       
                             Records              Indexes              LOBs               Combined  
NAME                        Size  Tot %         Size  Tot %         Size  Tot %          Size  Tot %
PUB.testdata               18.9K    2.6         4.4K    0.6       732.9M   96.8        732.9M  100.0

For OpenEdge versions prior to 11.6:

• No information for LOB fields is reported when running dbanalys or tabanalys
• The space used by LOB objects is not accounted for in dbanalys reports
• When using analys reports for restructuring database objects with new area structures, Blob/Clobs in the area are often neglected.
• An ABL code example to report on the space currently occupied by LOB Objects is provided in Article:
   How to report of the space used by LOBS?