DEFRAG (Defragment Index) › DEFRAG › Sample Report: DEFRAG

Sample Report: DEFRAG

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ********************************************************************************
 
                    CONTROL CARD(S)
                    .........1.........2.........3.........4.........5.........6.........7.........8
       Π           DEFRAG  DBID=781
 
                    FUNCTION=DEFRAG
                      DBID=00781
 
 
       Ž

Œ

The command exactly as entered.



An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.

Ž

Any messages related to syntax processing.

Date: mm/dd/ccyy    ********************************************************************************         Page:     2
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
Base:   781         ******************************************************************************** Directory: cxxname
 
                                                     DEFRAG REPORT
               BLOCKS         BLOCKS         BLOCKS         BLOCKS         PERCENT
KEY ID         BEFORE       COMBINED        DELETED          AFTER         DELETED  NOTES
 
     1             65             23             23             42           35.38
     2            240             26            174             66           72.50
     3              0              0              0              0            0.00
     4              0              0              0              0            0.00
     8             45             29             29             16           64.44
    11             10              0              0             10            0.00
    12             16              0              0             16            0.00
 39321              1              0              0              1            0.00  INDEX FREE SPACE
 39327              1              0              0              1            0.00  DATA FREE SPACE
TOTALS            378             78            226            152           59.78

Note: In the report all user keyids which are processed have statistics printed. Any special keyid (those with notes, that is, INDEX FREE SPACE and DATA FREE SPACE) only print statistics if it has at least one DXX block. This example does not contain an exhaustive list of the special keyids.

Also, note that there is a printed statistic of "blocks deleted". This contains two things. The first is DXX blocks which DEFRAG found already deleted but which the index queue has not yet processed. The second are blocks which the DEFRAG itself deletes. These are typically blocks which are combined with other blocks, but they may also be something like a cleanup of logically deleted entries which were still physically present in the DXX when DEFRAG ran. Hence DEFRAG can be used as a form of DXX TSN cleanup.