OMEAGMON XE for Db2 PE has streamlined the process for configuring the runtime environment. In September 2020, IBM delivered this enhancement for the Z Monitoring Suite. The ISPF-driven configuration process that still exists, is called PARMGEN. The new feature, Configuration Manager, is a...
What sometimes prevents users from exploiting new Db2 features is how can they recover from an error when using that new feature. For example, if using the new insert partition feature to insert a partition into the middle of a range-partitioned table, how would you recover to a point prior to...
How effective is your mainframe data management today? Do you have individual, separate products that require time and effort to learn and manage? Ineffective day-to-day data management can impact cost, efficiency, productivity, and profitability. Imagine a modernized data management...
Typically, in Db2 Admin Tool, the way to display catalog information about a Db2 object is to use the System Catalog panel (Option 1 on the main Db2 Administration Menu panel). From that panel, you can select the object type and any filtering criteria: However, did you know that you can also...
#Db2ZAI #Db2Tools #OMEGAMON #IBMZ #Db2 Business cycles are accelerating, new technologies are rapidly improving how organizations compete, and data-driven organizations are challenging and disrupting customary business approaches => New business and IT dynamics are driving...
Most Db2 for z/OS organizations are running the latest version of the product (Version 12). Where are you with the implementation Db2 12 and Function Level features and functions you need to take advantage of the benefits they can deliver to both you and your organization? Many enterprises are...
Support for TEMPLATEs for COPY with Db2 Recovery Expert Db2 Recovery Expert has an option to capture a new recovery base after running a recovery. Previously the COPY statements generated by Db2 Recovery Expert (ARY) would use explicitly allocated datasets with a sizing provided during...
Did you know that SQL Performance Analyzer gives you the ability to use virtual index configurations to calculate the impact that those change might have on the cost of your SQL? SQLPA supports the ability to both virtually drop real indexes and/or create new virtual indexes. This gives you the...
Learn how to create/drop virtual indexes without impact to improve your SQL statements. This article was written by Tom Hubbard #Db2Tools #db2sqlpa
Testing Virtual Indexes with IBM SQL Performance Analyzer.pdf
Db2 Administration Tool: Identification of object conflict in change management scenario Show information for superseded change (APAR PH22548) The Change Management function in Db2 Administration Tool (AOC) simplifies the process of recording and tracking the changes that you...