CONSULTING

Home

About

Consulting

Training

Robert's Blog

Articles / Videos

Contact

Robert Catterall

 

"Robert did a thorough review and made improvements that immediately boosted our throughput. His long-term recommendations are giving us a great performance benefit."

- George Thompson, DB2 DBA

The DB2 consulting services provided by Catterall Consulting are wide-ranging, but they have in common a single, overarching goal: solve problems.

The DB2 expertise that Catterall Consulting can apply to solve problems comes from over 20 years of experience in working with DB2 using organizations across industries – including banking, financial services, insurance, retail, manufacturing, telecommunications, distribution, health care, and government – and around the world, including North America, Europe, and Asia.  That experience has involved work on a variety of challenging engagements:

  • Implementing and tuning DB2 data sharing groups on parallel sysplex mainframe clusters.
  • Boosting throughput for DB2-based online transaction processing (OLTP) applications.
  • Leveraging DB2 stored procedure functionality for secure and scalable enterprise data-serving.
  • Analyzing and tuning complex queries in DB2 data warehouse/business intelligence systems.
  • Logical and physical database design for DB2-based applications.
  • Improving the performance of applications that utilize DB2 Connect and the DB2 for z/OS Distributed Data Facility.
  • Optimizing DB2 installation parameter settings to improve the performance, availability, and CPU efficiency of DB2 workloads.
  • Designing DB2-based applications according to principles of Service-Oriented Architecture (SOA).
  • Exploiting DB2 XML data-management capabilities.
  • Optimizing the CICS-DB2 interface for OLTP applications.
  • Developing strategies for the archiving and purging of data in DB2 databases.
  • Enhancing DB2 disaster recovery preparedness.

Catterall Consulting has the real-world knowledge needed to successfully address your organization’s DB2-related challenges.

 

© 2009 Catterall Consulting • phone: 770.263.5322 • 6050 Peachtree Parkway • Suite 240-367 • Norcross, GA 30092-3337