Up and Running with DB2 on Linux

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 25 June 2008

cover image

ISBN-10: 0738485314
ISBN-13: 9780738485317
IBM Form #: SG24-6899-01
(544 pages)

More options

Rate and comment

Authors: Whei-Jen Chen, Christian Hideaki Kondo, Helmut Riegler, Lifang LF Liu, Veiko Spranger


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.

Table of contents

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

Follow IBM Redbooks

Follow IBM Redbooks