AVILOOK Output

At normal database termination, the statistics gathered during AVILOOK processing are written to the database job log.

The following screen is an example of the output provided by AVILOOK.

16:56:07 ***** A D A B A S  VISTA SERVICES 8.2.1 *****                2006-05-29
                   - Avilook File Statistics -                         V14120M1

   DBID: 231   (TEST-V8-DB)
   File: 2                                          Started: 2006-05-29 09:09:20
                                                     Paused:         
          

       CC    Desc    Command Count                  CC    Desc    Command Count
       L3     AA              2836
       S1     AB              1324
       L3     BC                24
       L9     S1                26



  Other Commands not listed above: 1558


  Command ==>
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12
       Help        Exit  Refr                                            Menu

This screen shows statistics on the command type and quantity of key-based accesses against the file (for example, S1, L3, and L9 commands). The statistics are displayed in descending order by command code (CC) and Adabas two-character field name (Desc).

In the example, there are 2836 accesses to file 2 using an L3 command with the Adabas field AA as the primary sequence field. Such a file, where the predominant access is by a single key, may benefit from being partitioned using the Adabas field AA as the Adabas Vista partitioning field.