DB2 Consulting, DB2 Performance, DB2 Training - Martin Hubel Consulting Inc.
Fight The Right Fires! PDF Print
What We Do
Since 1992, Martin Hubel Consulting Inc. has been helping customers with difficult performance problems, recovery issues, design, consulting and training for DB2 on z/OS, AIX, Sun, Linux and Windows. We also have extensive experience tuning vendor applications such as PeopleSoft and Siebel. This work can be on-site at your location or remotely from ours.

Fight The Right Fires!
As a DBA, when was the last time you had enough time to do everything you needed to do? With availability targets rising and user demands increasing, there is little time left to look at system and application performance issues.

We have the talent AND the tool to help tune DB2 applications on the Linux and Unix platforms. Our SQL Sleuth tool, exclusive to MHC, accurately captures the most expensive SQL statements, based on resource usage and execution frequency, to truly show what your applications are doing!
 Logo

This tool is in available now, and can be run on your data at our site or installed on your machines. Please click the SQL Tuning link for further information.
 
DB2 Performance Audits PDF Print E-mail

We provide DB2 system and application audits to ensure operational integrity and optimal performance. The audits can be done remotely from our location or on-site. We identify key areas for improvement, provide a written report, and are available for questions following the review. For DB2 LUW, we have developed our own technology, SQL Sleuth, that finds performance problems that otherwise might be missed. We have experience in OLTP systems, data warehouses, and vendor packages such as PeopleSoft and Siebel. Our performance audits include:

  • Tuning bufferpools for optimal performance
  • Performing index analysis
  • Reviewing and adjusting system and database settings
  • Identifying system and application bottlenecks
  • Optimize tablespace and other physical design settings
  • Recommendations for future growth
  • Identify highest use and worst performing SQL using SQL Sleuth (DB2 LUW)
Last Updated ( Thursday, 13 December 2007 00:30 )
 
DB2 Remote Administration PDF Print E-mail

No matter how big or small your need is we can help. Many organizations are not large enough to justify the cost of a full-time DBAs. Also, database administration requires experienced professionals, with sufficient backup to cover vacations and emergencies. We offer a cost-effective alternative. Prices start at $499 per year for basic monitoring, maintance, upgrade, and fixpack installation. Our remote administration services can provide the following:

  • 24/7 monitoring of database status
  • Database and infrastructure design
  • Performance monitoring and tuning, including the use of our SQL Sleuth tool
  • Development support
  • Database maintenance and administration
  • Backup and disaster recovery support
  • Installation of fixpaks and other maintenance
  • Development of scripts to automate routine processes
  • Maintain clusters (Windows and HACMP)
  • All Advanced certified DB2 DBA's with at least 7 years industry experience

To find out more please use our contact us page
 
DB2 System Audits PDF Print E-mail
We provide DB2 system and application audits to ensure operational integrity and optimal performance. These audits are available for DB2 for z/OS, AIX, Linux and Windows. The audits can be done remotely from our location or we can come to you. In one, two or more days, we identify key areas where improvement can make a difference. We always provide a written report and are available for questions following the review. Training and skills transfer are important deliverables as well.
 
DB2 HADR Setup and Consulting PDF Print E-mail

Replication is an effective way to ensure availablity of mission critical applications. Many companies are evaluating replication alternatives, among them DB2 High Availability Disaster Recovery (HADR). HADR is a cost effective solution that protects against data loss by replicating data and schema changes from a primary to a standby server.

We review your applications and environment and evaulate different replication alternatives. We help you ensure that you get the best solution for your business in the following ways:

  • Evaluate replication alternatives
  • Work with your network administrator to properly setup and secure HADR
  • Transfer skills and knowledge
  • Provide 24/7 remote monitoring of HADR status
  • Provide support during outages
  • Document proper operation of HADR
 

Main Menu

Login Form
Copyright Martin Hubel Consulting Inc.