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:
Sent: Mon February 05, 2024 02:13 PM
From: Thomas Shimek
Subject: Omegamon Performance Warehouse
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:
Sent: Sat February 03, 2024 03:05 AM
From: Aleksa Shop
Subject: Omegamon Performance Warehouse
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:
Sent: Wed December 27, 2023 02:55 AM
From: Jørn Thyssen
Subject: Omegamon Performance Warehouse
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:
Sent: Thu December 21, 2023 11:21 AM
From: Thomas Shimek
Subject: Omegamon Performance Warehouse
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
------------------------------