Professional Web Applications Themes

How can know the transaction per second - IBM DB2

What command should should I use get the load on DB2? SNAPSHOT? EVENTMONITOR?...

  1. #1

    Default How can know the transaction per second

    What command should should I use get the load on DB2?
    SNAPSHOT?
    EVENTMONITOR?
    richardshen@canada.com Guest

  2. #2

    Default Re: How can know the transaction per second

    Exactly what load do you want to know? If you want to know
    transaction/second, then I would use the event monitor since through that
    you will know for sure. With the snapshot, you can have for example 400
    transactions in 10 seconds but you take a snapshot every minute. Thus the
    calculation would come down to:
    transactions/second
    400/60 = 6.66 transactions/second through the snapshot information. But
    since out of the 60 seconds, you only had 10 seconds of work and 50 seconds
    idle, your true throughput would be:
    400/10 = 40 transactions/second.

    Hope this helps.
    <com> wrote in message
    news:google.com... 


    Erik Guest

  3. #3

    Default Re: How can know the transaction per second

    Erik is correct, however snapshot monitor is much cheaper than running a
    transaction evmon. The info you're looking for is from the database
    snapshot, and is basic data (means it's collected as part of basic
    processing). If you have an environment where you're just looking at rax
    tx numbers over time, consider using the database snapshot.

    Erik Hendrix wrote: 
    >
    >
    >[/ref]

    Sean Guest

Similar Threads

  1. WS-Transaction
    By moko in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 13th, 12:25 AM
  2. Transaction Log
    By Shamim in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: August 22nd, 06:25 AM
  3. Transaction
    By basidati in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: August 8th, 03:41 PM
  4. Transaction id and transaction isolation
    By Alex in forum Informix
    Replies: 3
    Last Post: July 23rd, 09:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139