Docstoc

TRIM A PERFORMANCE MONITOR FOR ADABAS AND NATURAL

Document Sample
TRIM A PERFORMANCE MONITOR FOR ADABAS AND NATURAL Powered By Docstoc
					DataBase
Detective




            No More - No
                Less
                             Part 1
            Mountain East User Group
               February 27, 2004



  David Del Rio
  DataBaseDetectiv@Mindspring.com
  949-644-0399 - office
  949-293-9157 - mobile




                                       1
DataBase
Detective




            No More - No Less

     A method for optimizing
      Periodic Group access
    (and Multiple Fields also!)




                                  2
DataBase
Detective




     Periodic Group access
         via NATURAL
    has significant ADABAS
          OVERHEAD
            possible.




                             3
DataBase
Detective




              ADABAS CALLs:

            CALL ADABAS USING

               Control Block
               Format Buffer
               Record Buffer
               Search Buffer
               Value Buffer
                ISN Buffer




                                4
DataBase
Detective




            UserView / Data :



             Format Buffer
             Record Buffer




                                5
DataBase
Detective




    Reduce the Number of
 fields or occurrences in the
   Format Buffer (Userview)
      passed to ADABAS



                                6
DataBase
Detective




            7
DataBase
Detective




            8
DataBase
Detective




            9
DataBase
Detective




            10
DataBase
Detective




            11
DataBase
Detective




            12
DataBase
Detective




            13
DataBase
Detective




            14
DataBase
Detective




            15
DataBase
Detective




            16
DataBase
Detective




            17
DataBase
Detective




            18
DataBase
Detective




            19
DataBase
Detective




            20
DataBase
Detective




            21
DataBase
Detective




            22
DataBase
Detective




            23
DataBase
Detective




            24
DataBase
Detective




            25
DataBase
Detective




            26
DataBase
Detective




            27
DataBase
Detective




            28
DataBase
Detective




            29
DataBase
Detective




            30
DataBase
Detective




            31
DataBase
Detective




            32
DataBase
Detective




            33
DataBase
Detective




            34
DataBase
Detective




                 Now -
            some programs for
                 study !




                                35
DataBase
Detective




            36
DataBase
Detective




            37
DataBase
Detective




            38
DataBase
Detective




            39
DataBase
Detective




            40
DataBase
Detective




            41
DataBase
Detective




            42
DataBase
Detective




            43
DataBase
Detective




            44
DataBase
Detective




            45
DataBase
Detective




            46
DataBase
Detective




            47
DataBase
Detective




            48
DataBase
Detective




            49
DataBase
Detective




            50
DataBase
Detective

                     Some Batch
                       Timings
    •   1NEXT FINALTIM
    •   1Page    1                          03-06-01
        05:54:30
    •   0KEEN          20028900     780 3 0086/01/12
        0086/01/12
    •    ABOUT TO START LOOP -        05:54:30.8
    •    END 1, 001, COUNT =   50000 05:58:41.9 00:04:11
    •    ABOUT TO START LOOP -        05:58:41.9
    •    END 2, 005, COUNT =   50000 06:03:02.0 00:04:20
    •    ABOUT TO START LOOP -        06:03:02.0
    •    END 3, 030, COUNT =   50000 06:07:45.4 00:04:43
    •    ABOUT TO START LOOP -        06:07:45.4
    •    END 4, 099, COUNT =   50000 06:13:35.8 00:05:50
    •    ABOUT TO START LOOP -        06:13:35.8
    •    END 5, 191, COUNT =   50000 06:20:58.1 00:07:22
        <<<<<




                                                           51
DataBase
Detective
            So – That is it when
               you need all
             occurrences ?




                                   52
DataBase
Detective
            Now for an alternate
                    way

    • Use two calls (only when
      necessary)
    • Ranges are ‘fixed’




                                   53
DataBase
Detective




            54
DataBase
Detective




            55
DataBase
Detective




            56
DataBase
Detective




            57
DataBase
Detective




            58
DataBase
Detective




            59
DataBase
Detective




       Now comes two reads
               :
         REPORT mode




                             60
DataBase
Detective




            61
DataBase
Detective




            62
DataBase
Detective




            63
DataBase
Detective




            64
DataBase
Detective




            65
DataBase
Detective




                Now for a
               precaution -

            PE Level approach




                                66
DataBase
Detective




            67
DataBase
Detective




            68
DataBase
Detective




            69
DataBase
Detective




            70
DataBase
Detective




            71
DataBase
Detective




            72
DataBase
Detective




            73
DataBase
Detective




            74
DataBase
Detective




            75
DataBase
Detective




            76
DataBase
Detective




            77
DataBase
Detective




            78
DataBase
Detective




            79
DataBase
Detective




            80
DataBase
Detective

            Some Batch Timings –
               Group Level

    •   NEXT FINALGRP - Range on Group level
    •   Page    1                          03-05-31
    •   KEEN          20028900     780 3 0086/01/12
        0086/01/12
    •   ABOUT TO START LOOP -         16:15:20.9
    •   GRP 1, 001, COUNT =    50000 16:19:33.2 00:04:12
    •   ABOUT TO START LOOP -         16:19:33.2
    •   GRP 2, 005, COUNT =    50000 16:24:01.5 00:04:28
    •   ABOUT TO START LOOP -         16:24:01.5
    •   GRP 3, 030, COUNT =    50000 16:29:15.8 00:05:14
    •   ABOUT TO START LOOP -         16:29:15.8
    •   GRP 4, 099, COUNT =    50000 16:36:38.2 00:07:22
    •   ABOUT TO START LOOP -         16:36:38.2
    •   GRP 5, 191, COUNT =    50000 16:46:48.9 00:10:10




                                                           81
DataBase
Detective

              So - Is that it ?!

                 Read ALL
                occurrences

              or TWO calls to
                 ADABAS ?

            Please go to Part 2 !




                                    82

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:2/3/2012
language:English
pages:82