Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitoring DB2 in a Linux environment.

We describe the DB2 product family and features for Linux, and we provide step-by-step instructions for a single as well as for a multiple partition DB2 system installation and configuration. We discuss how to migrate single and multiple partition DB2 to DB2 Version 9.5, and discuss, in detail, DB2 database administration in a Linux environment, procedures and tools for database backup and recovery, online maintenance, and system monitoring. We cover DB2 integrated tools and their features and use.

We discuss aspects of DB2 application development in the Linux environment and provide general tips about building and running DB2 applications on Linux and the use of DB2 application development tools.

Chapter 1. Introduction

Chapter 2. Installation

Chapter 3. Post-installation tasks

Chapter 4. Migration and fix packs

Chapter 5. IBM Data Studio

Chapter 6. Administering databases

Chapter 7. Monitoring and troubleshooting DB2

Chapter 8. Application development

Appendix A. Issuing commands to multiple database partitions

Appendix B. DB2 Tools Catalog creation