Db2 for z/OS

Db2 for z/OS on IBM Z

Db2 for z/OS on IBM Z

Leading enterprise data server technology powering business critical transactions and analytics

 View Only
Back to discussions
Expand all | Collapse all

Best Way to Combine Db2 SMF Data

  • 1.  Best Way to Combine Db2 SMF Data

    Posted Tue August 18, 2020 10:01 PM

    Hello,

     We need to produce a report on SERVER DDF traffic into Db2 for z/OS in the following format:

     DATE, TME(lowest interval), LPAR, ALIAS, MEMBER, TRANSACTION_NAME, DDF_HWM_DBAT, DDF_HWM_CONDBAT

     All of that data can be found here.

    SMF_10101

    SMF_10000

    SMF_10000_QDST

    The trick is to line it all up and present it to management, confidently. 

    I've heard a lot in my shop about why it can't be done.

    I don't really believe it, so I'd like to ask here:
    Can someone please provide input on how I can confidently achieve a summary such as the one I mention above?

    One idea I have is to connect the QWHSLUUV varaible between the 100 & 101 records.  Does that variable match among the record types?

     

    Another I have is in regard to SMF_TIME, but I'm thinking record cutting would foil that one, but I'm not sure.

     

     

    Thanks,



    ------------------------------
    Jonathan Brown
    ------------------------------


  • 2.  RE: Best Way to Combine Db2 SMF Data

    Posted Mon September 27, 2021 05:29 PM
    Hi Jonathan,

    I don't have much experience in this subject, but I think if you get this information in variables through REXX you can align it and produce a report

    att

    ------------------------------
    Diego de Franco Matos
    ------------------------------

    Original Message


Related Content