DB2 - L

 View Only
  • 1.  QPS in Db2 for z/OS?

    Posted Apr 01, 2022 09:49 AM

    We have been asked… What is the maximum # of queries per second we run in DB2?

    Further explained as … He isn't looking for max capabilities, but actual daily business on average how many queries per second are we doing to support FDOT business.

    We are stymied! Do you know of any way to identify this?



    ------------------------------
    Michael McBride
    Florida Department of Transportation
    ------------------------------


  • 2.  RE: QPS in Db2 for z/OS?

    Posted Apr 01, 2022 10:07 AM

    Between 0 and 1 billion.

     

    That must be an April Fool's question from management. What would they do with that knowledge?

     

     

    Larry Jardine

    Database Advisor, Aetna, a CVS Health Company

    CVS
    CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments.

     






  • 3.  RE: QPS in Db2 for z/OS?

    Posted Apr 01, 2022 10:38 AM
    LOL, I just took a look at one production data sharing group.

    About 505,000 per second.

    However, I have a single application that executes a very simple and stupid process once per month and it alone does about 600,000 updates per second.

    I hate saying "it depends" so I now say "I don't know". There really is no answer to the question.

    Happy Friday!
    Dan




  • 4.  RE: QPS in Db2 for z/OS?

    Posted Apr 01, 2022 11:35 AM

    Michael - Just make up a number – no one will know anyway.  Wonder if this is for our Florida Governor!..-��

     

    Image

     

    Thx

    Suresh

     

     






  • 5.  RE: QPS in Db2 for z/OS?

    Posted Apr 01, 2022 11:46 AM
    Even those numbers are impressive!

    I'm tempted to ask "what's the question BEHIND the question?"

    Phil G

    Sent from my iPad