Zuverlässige Massenanalyse von Zugriffsmodulen bezüglich Performance nach definierten Qualitätskriterien

Erfahrungsbericht der

(mit Hinweisen zur performance- und qualitätsgesicherten DB2 Migration)

Download (PDF)

Anwendungsmigration zu DB2 9 - Be Prepared

EarlyPrecheck bereits mit V8 Produktionssystem: Überprüfung Ihrer Applikationen auf Zugriffpfad-Änderungen vor der Migration auf V9

Mit Hilfe eines speziellen Regelwerkes sind wir nun in der Lage, die Auswirkungen von DB2 9 bereits vor der Migration Ihres Produktionssystems - sowohl für statisches als auch dynamisches SQL - zu erkennen und zu bewerten...
mehr

16. September 2008 - SOFTWARE ENGINEERING repräsentiert ab sofort DBI (Database-Brothers, Inc.) auf dem deutschen Markt

  

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

Produkte
Pressemitteilung

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

Was ist neu in Bind ImpactExpert (BIX)?

• Package Stability Support

Frühjahr 2008:

On Recovery Service Levels
von Craig Mullins und 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..."

Artikel (PDF, 1,03 MB)
(Download der vollständigen Ausgabe auf www.idug.org)

Oktober/November 2008:

  

DB2 Database Maintenance and Recovery:
Getting Past the Common Misconceptions
(von Brenda Honeycutt und 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..."

Artikel (PDF, 121 KB)

Juni/Juli 2008:

  

The Rise of Dynamic SQL
(von 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."

Artikel (PDF, 338 KB)

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

April/Mai 2008:

  

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

DB2-Koryphäe empfiehlt die Nutzung der RTS und ermutigt zum Einsatz von RTS-basierten Wartungslösungen:

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

Artikel (PDF, 1,04 MB) / siehe auch RealTimeMaintain

Dez 2007/Januar 2008:

  

The Mathematics of Bad Luck:
Risk Management in a DB2 Environment
(von 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."

Artikel (PDF, 1,52 MB)

Okt./Nov. 2007:

  

DB2 Database Maintenance 2007:
Embracing On-Demand Requirements
(von 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."

Artikel (PDF, 1,06 MB)

  

Ein neues Magazin für CIO's und IT-Manager im IBM Mainframe-Umfeld... mehr

SOFTWARE ENGINEERING GmbH stellt 6 Patent-Anträge in Europa und den USA, zum Schutz unserer innovativen, technologischen Entwicklungen für:

• die Erstellung von "Performance Indexes" auf Basis von realer Produktionlast
• "Point in time recovery" von SAP R/3
• die Auswertung und den Vergleich von zehntausenden SQL-Anweisungen zur detaillierten Analyse von Modifikationen
• die Echtzeit-Wartung von Datenbanken
• die Sortierung von Datensätzen mit Sortierbegriffen bis zu 32K.
• Algorithmus zur Ermittlung lohnender Column Distribution Statistics zur SQL Zugriffspfadverbesserung.

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