Reliable mass analysis of DB2 access modules to assure SQL quality and performance

Experiences - reported by

(includes hints to insure a quality-driven DB2 migration)

Download (PDF)

Application Migration to DB2 z/OS Version 9 - Be Prepared

EarlyPrecheck: Pre-Checking your Access Path Performance while still on a V8 production system

Using a special rule system, the impacts of DB2 version 9 can now be determined and assessed before the migration of your production system for both static and dynamic SQL...
more

September 16, 2008 - DBI (Database-Brothers, Inc.) announced the expansion of its international markets by partnering with SOFTWARE ENGINEERING to serve the German market

  

DBI is an industry leader in distributed DB2 LUW and Oracle database performance best practices methodologies, services, and products that enable companies to accelerate business with clarity. Distributed Database Performance Management Tools from DBI make it easy to rapidly identify, isolate, and resolve performance issues, verify success, and manage performance changes and trends. DBI’s Green IT methods improve performance, productivity, profitability and security while lowering utility costs, saving floor space and reducing IT costs. Our customers typically achieve 30-90 CPU utilization reductions within the first few hours along with measurable response time improvements. Take back control of runaway on demand upgrades, service levels, performance reliability, and costs -- and accelerate your business today.  www.DBIsoftware.com

Products
Press release

Now GA, SPT01 Transparency strengthens Package Stability and allows customers to benefit from its usage without the risk of falling back to surprising performance results.

Product Page

What's new with Bind ImpactExpert (BIX)?

• Package Stability Support

Spring 2008:

On Recovery Service Levels
by Craig Mullins and Brenda Honeycutt (SOFTWARE ENGINEERING)

"Business availability is more than just having a reliable hardware and database platform in place. Even the best high availability environment cannot safeguard itself from logical errors..."

Article (PDF, 1,03 MB)
(Download full issue at www.idug.org)

October/November 2008:

  

DB2 Database Maintenance and Recovery:
Getting Past the Common Misconceptions
(by Brenda Honeycutt and Craig S. Mullins)

"Every DBA strives to maintain a healthy DB2 environment every day. However, there are numerous lingering misconceptions about database health to which many organizations fall prey. These misconceptions occur because DBAs believe in, or apply, concepts that are objectively false..."

Article (PDF, 121 KB)

June/July 2008:

  

The Rise of Dynamic SQL
(by Craig Mullins)

Read this article to find out why "dynamic SQL is a viable option for application development in the 21st Century".

"Have you noticed that dynamic SQL is more popular today than ever before? There are a number of factors contributing to the success of dynamic SQL today. This trend to embrace dynamic SQL is in stark contrast to the mindset of a decade or so ago when the prevailing rule was to avoid it at all costs. . . It's wise to avoid rules that prohibit its use in your shop."

Article (PDF, 338 KB)

Follow Craig Mullins recommendation to use tools that support the analysis of dynamic SQL and their access paths. SQL PerformanceExpert

April/May 2008:

  

Use Real Time Statistics
to Automate Your Database Maintenance
(by Craig Mullins)

DB2 Expert encourages use of RTS and recommends RTS-based automation tools:

"Real Time Statistics (RTS) have been available for several years now, but they're still only nominally implemented. Given all the benefits that can be accrued by using RTS, it's flabbergasting they haven't been more widely embraced by DB2 administrators..."

Article (PDF, 1,04 MB) / see RealTimeMaintain

December 2007/January 2008:

  

The Mathematics of Bad Luck:
Risk Management in a DB2 Environment
(by Karl Henn)

"Risk Management is on everyone's minds, as it's a cornerstone of Business Continuity Planning (BCP). This article will explore the science behind it all;a hands-on example will illustrate how to deal with risk assessment in a DB2 environment."

Article (PDF, 1,52 MB)

October/November 2007:

  

DB2 Database Maintenance 2007:
Embracing On-Demand Requirements
(by Ulf Heinrich)

"Explore five levels of database maintenance and how key enhancements throughout DB2's evolution have corresponded to those levels and facilitated their attainment."

Article (PDF, 1,06 MB)

  

A new magazine for CIOs and IT Manager in enterprises with IBM mainframe systems... more

SOFTWARE ENGINEERING GmbH registers 6 patent applications in Europe and the United States to protect our unique technological inventions for:

• Generating performance indexes based on a real production workload
• Point in time recovery of SAP R/3
• Parsing and comparing tens of thousands SQL statements to pinpoint changes
• Performing realtime maintenance of databases.
• Sorting of data records with sort fields up to 32K.
• Algorithm to identify profitable column distribution statistics for SQL access path improvements.

• ImpactExpert Patent #EU1353278
• SeQuaLizer Patent #EU1353278
• IndexOptimizer Patent #US020188