Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: Maximum size of transaction

    Hi

    1) Transaction per second


    No of transaction per second = total transaction / total elapsed time.

    total transaction = commits+rollback

    total elapsed time = is the difference between last reset timestamp and snapshot timestamp

    pls correct me

    2) How to find the maximum size of the transaction

    regds
    Paul

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what is meant with "maximum size of the transaction "
    elapsed time ??
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    CREATE EVENT MONITOR (unit of work) statement should help you.
    Regards,
    Mark.

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    thanks mark, will check the event monitor

    guy

    Actually this info was for the Q capture memory parameter. this is from the doc. I got transaction per second details.

    from doc IBM Q rep.

    Use Table 1 as a guide to help you determine the memory limit for each Q Capture
    program. By using these estimates as a guide, you can ensure that the Q Capture
    program has enough memory for your workload and you can prevent the program
    from writing transactions to spill files. The table uses this formula to calculate the
    number of transactions per commit_interval:
    txr/1000 * ci = txci
    Where:
    txr Transaction rate (transactions per second)
    ci Commit_interval
    txci Transactions per commit_interval
    The transactions per commit_interval are used in the following formula to come
    up with the memory limit:
    txci * mtxs = ml
    Where:
    txci Transactions per commit_interval
    mtxs Maximum transaction size
    ml Memory limit in bytes

Posting Permissions

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