DB2 Version 10.1 for Linux, UNIX, and Windows

Best practices for DB2 pureScale environments

To help you efficiently set up and use DB2® software with the IBM® DB2 pureScale® Feature software, you can use the best practice papers that are described in this section.

Combining IBM DB2 pureScale with Q Replication for scalability and business continuity

This article presents the considerations, configuration choices, concepts, and technology as well as the deployment and operation procedures that are required for achieving full continuous availability of your DB2® instance with Q Replication. This article specifically covers DB2 pureScale™, but all concepts and commands presented are equally applicable to any other DB2 system.

The article covers the following topics:
  • Q Replication concepts and operation
  • Monitoring, tuning, and troubleshooting replication
  • Sample commands for preparing the databases for replication
  • Downloading and installing WebSphere® MQ
  • Testing WebSphere MQ connectivity
  • Installing and configuring the Q Replication Dashboard

You can download this best practice paper from the IBM developerWorks® website: Combining IBM DB2 pureScale with Q Replication for scalability and business continuity.

DB2 databases and the IBM General Parallel File System

Reduce management costs, add flexibility, and simplify storage management by using the IBM General Parallel File System (GPFS™) software. GPFS software is a high-performance shared-disk file management solution that provides fast, reliable access to a common set of file data. Data can be shared between as few as two computers or as many as hundreds of systems. A GPFS file system brings together mixed server and storage components to provide a common view of enterprise file data. Pairing GPFS file systems and DB2 for Linux, UNIX, and Windows databases creates a powerful platform for your high-performance database systems.

Use the DB2 databases and the IBM General Parallel File System paper to learn about the strategic benefits of GPFS software and the best practices for deploying it with DB2 software. You can download this best practice paper from the IBM developerWorks website: DB2 databases and the IBM General Parallel File System.

DB2 pureScale performance and monitoring webcast

In this technical presentation webcast, IBM Senior Technical Staff Member and performance expert Steve Rees presents a thorough list of best practices to help you configure and monitor a DB2 pureScale environment for optimal performance. The first part of the presentation focuses on some key concepts about DB2 pureScale software to help you understand the configuration decisions you can make to setup your system to achieve optimal performance. The second part of the presentation dives into the topics of monitoring and tuning to ensure your DB2 pureScale environment continues to perform optimally as it grows.

You can view this best practice webcast and download the companion presentation slides and text transcript from the IBM developerWorks DB2 best practices community: DB2 pureScale performance and monitoring.

Deploying Optim Performance Manager in large-scale environments

Large-scale environments often have special considerations when it comes to managing performance. In such environments, it is very important to have a comprehensive, proactive performance management approach. IBM InfoSphere® Optim™ Performance Manager software offers such an approach.

Use the Deploying Optim Performance Manager in large-scale environments paper to learn about best practices for deploying InfoSphere Optim Performance Manager Extended Edition software in large-scale environments, including DB2 pureScale environments. You can download this best practice paper from the IBM developerWorks website: Deploying Optim Performance Manager in large-scale environments.

SAP applications with the DB2 pureScale Feature on SUSE Linux Enterprise Server and IBM System x

Today's rapidly changing business generates increasing demands for flexibility and continuous availability of business applications. The SAP applications with the DB2 pureScale Feature on SUSE Linux Enterprise Server and IBM System x paper describes why a solution stack that includes IBM System x® servers, SUSE Linux Enterprise Server optimized for SAP applications, the IBM DB2 pureScale Feature software, and SAP applications provides an excellent response to these demands. This paper is targeted at both a technical audience and decision makers who want to understand the benefits that are provided through this best-of-breed solution stack. You can download this best practice paper from the IBM developerWorks website: SAP applications with the DB2 pureScale Feature on SUSE Linux Enterprise Server and IBM System x

Securely deploying and configuring the DB2 pureScale Feature by using db2ssh

This technical paper highlights the best practices for securely deploying and configuring the DB2 pureScale Feature by using db2ssh. The db2ssh is a wrapper around the Secure Shell (SSH) protocol and Secure Copy Protocol (SCP). This paper provides the following information:
  • an introduction to db2ssh and its configuration
  • details about various methods for installing and configuring the DB2 pureScale Feature with db2ssh enabled
  • troubleshooting tips to resolve problems.

You can download this best practice paper from the IBM developerWorks website: Securely deploying and configuring the DB2 pureScale Feature by using db2ssh.