Db2 Tools for zOS

 View Only
  • 1.  Omegamon Performance Warehouse

    Posted Fri December 22, 2023 11:29 AM

    I'm curious to know if anyone uses the Omegamon Performance warehouse feature.  We are having lots of issues getting it to work, getting deadlocks in data sharing, and I'm just trying to figure out if it's worth all the effort to get it working.   Any advice or opinions would be appreciated.  

    Thank you.



    ------------------------------
    Thomas Shimek
    ------------------------------



  • 2.  RE: Omegamon Performance Warehouse

    IBM Champion
    Posted Wed December 27, 2023 02:56 AM

    Hi Thomas, 

    Do I understand correctly that you'd like to capture deadlocks/timeouts and save them in the OMEGAMON performance database?

    Or do you get a deadlock trying to create & populate the tables? 



    ------------------------------
    Jørn Thyssen
    Principal Solutions Advisor
    Rocket Software
    ------------------------------



  • 3.  RE: Omegamon Performance Warehouse

    Posted Thu December 28, 2023 11:00 AM

    We don't use the OM Performance Warehouse for anything and are not sure how/when we should. We have been running Db2 standalone until recently when we created a data sharing group with two members, When the collector was restarted it ran the started jobs to create the warehouse in the new data sharing group, as expected, but for some reason the two members get deadlocked with each other on the DB2PM.CONTRLF resource.  We have altered that object to use row-level locking and still get deadlocks.  I didn't mention that I have opened case  TS014901833 for this issue.  



    ------------------------------
    Thomas Shimek
    ------------------------------



  • 4.  RE: Omegamon Performance Warehouse

    Posted Thu December 28, 2023 11:56 AM

    PS: Norbert Jenninger just replied with a resolution to this problem.  Apparently the PWH should only be set to YES in one of the data sharing groups.  We will try that and close the ticket if it eliminates the problem.

    Thank you.  



    ------------------------------
    Thomas Shimek
    ------------------------------



  • 5.  RE: Omegamon Performance Warehouse

    Posted Thu January 04, 2024 10:50 AM

    Hi Thomas,

    Thanks for posting the update with a solution to resolve this. Can you please update us once you've had a chance to try it, so that other members can be helped by this approach as well?

    Sonia Singh
    Data Community Manager



    ------------------------------
    Sonia Singh
    ------------------------------



  • 6.  RE: Omegamon Performance Warehouse

    Posted Mon February 05, 2024 12:39 PM

    If you are dealing with capturing deadlocks or timeouts and storing them in an OMEGAMON performance database, you might need to follow specific procedures or use tools provided by OMEGAMON or the underlying platform.



    ------------------------------
    Admin from [URL="https://softwareshopk.com"]Software Shop.[/URL]
    ------------------------------



  • 7.  RE: Omegamon Performance Warehouse

    Posted Mon February 05, 2024 02:13 PM

    We got this resolved with IBM Support.  We had set PERFORMANCEWAREHOUSE=YES in both members of the data sharing group which caused some corruption to occur.  We changed one of the members to NO, dropped the DB2PM database and bounced the stc, which recreated the DB2PM database.  I'm still trying to decide if it is a useful enough feature to go through all of this though.  



    ------------------------------
    Thomas Shimek
    ------------------------------



  • 8.  RE: Omegamon Performance Warehouse

    IBM Champion
    Posted Tue February 06, 2024 03:31 AM

    Hi Thomas, just to make sure: there is a Performance Database (PDB) and a Performance Warehouse (PWH) in OMEGAMON Db2. Both features are optional. PDB is used to store performance metrics from SMF, GTF or user initiated traces over a longer period of time. The structure of the PDB tables and the Db2 load statements are predefined by OMEGAMON Db2, but a user can decide which tables should be created and loaded. On the other hand, it is the DBA's responsibility to maintain the tables, remove outdated records etc.

    PWH is a set of tables that is managed by the OMEGAMON Db2 data collector STC. The user specifies some configuration parameters (e.g. storage group, buffer pool) but does not need to take care of the schema changes. PWH is used for some internal OMEGAMON Db2 processing (for example, the EXPLAIN interface between OMEGAMON Db2 and IBM SQL Performance Analyzer) and provides the underlying infrastructure when a user initiates batch reporting from the Windows-based Performance Expert Client instead of traditional JCL coding. But, in general, you would not directly access the PWH tables with SQL but use the OMEGAMON Db2 user interfaces instead. 



    ------------------------------
    Christoph Theisen
    Rocket Software
    ------------------------------



  • 9.  RE: Omegamon Performance Warehouse

    IBM Champion
    Posted Tue February 06, 2024 04:58 AM

    The PWH is useful, repectively is needed, if you want to use the IBM Db2 SQL PA launch capability from your 3270 (enh3270, Classic) real-time monitoring panels, or if you want to use the PE Client PWH GUI Processes (CRD, Report, & Load).

    Regards Norbert Jenninger  

     

    Sent from Mail for Windows

     

    ================================
    Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
    Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
    Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
    Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
    ================================

    This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.