Db2 Tools for zOS

 View Only
Expand all | Collapse all

Omegamon Performance Warehouse

  • 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

    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
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


  • 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]
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


  • 8.  RE: Omegamon Performance Warehouse

    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
    ------------------------------

    Original Message


  • 9.  RE: Omegamon Performance Warehouse

    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.




    Original Message


  • 10.  RE: Omegamon Performance Warehouse

    Posted Wed August 07, 2024 03:15 PM
    Edited by Lorraine Rizzuto Tue August 13, 2024 04:32 PM

    The Omegamon Performance Warehouse feature can be complex and may require careful configuration to avoid issues like deadlocks. It might be helpful to consult with IBM support or user forums for specific troubleshooting tips and to assess if the benefits outweigh the setup challenges.please visit physio at home for more information.



    ------------------------------
    illa shiza
    ------------------------------

    Original Message


  • 11.  RE: Omegamon Performance Warehouse

    Posted Thu August 08, 2024 05:45 AM

    Hi Tom, 

    please refer to the documentation: in a Data Sharing the startup parameter PERFORMANCEWAREHOUSE=Y should only be set to 'Y' for one member for creation and maintenance to avoid any cross access conflicts. As shared resource it might be used by all functions from all members w/o having PERFORMANCEWAREHOUSE=Y set..



    ------------------------------
    Norbert Jenninger
    OMEGAMON DB2 consultant
    Rocket Software
    ------------------------------

    Original Message