Summary of the content on the page No. 1
Front cover
DB2 Deployment Guide
Learn to deploy DB2 Data Servers and
Clients
Automate DB2 mass deployment
with scripts
Deploy DB2 with
applications
Whei-Jen Chen
Jian TJ Tang
Carsten Block
John Chun
ibm.com/redbooks
Summary of the content on the page No. 2
Summary of the content on the page No. 3
International Technical Support Organization DB2 Deployment Guide October 2008 SG24-7653-00
Summary of the content on the page No. 4
Note: Before using this information and the product it supports, read the information in “Notices” on page vii. First Edition (October 2008) This edition applies to DB2 for Linux, UNIX, and Windows Version 9.5. © Copyright International Business Machines Corporation 2008. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
Summary of the content on the page No. 5
Contents Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii Trademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ix The team that wrote this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ix Acknowledgements . . . .
Summary of the content on the page No. 6
2.3.2 DB2 license . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 2.3.3 Creating the deployment script . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 2.3.4 Windows deployment scripts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 2.4 Fix pack deployment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 2.4.1 Fix pack overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Summary of the content on the page No. 7
4.5.1 IBM IBM_DB gem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 4.5.2 Installation of IBM_DB gem. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 4.5.3 Creating a sample Ruby application . . . . . . . . . . . . . . . . . . . . . . . . 183 4.5.4 Deploying a Ruby application with the DB2 drivers . . . . . . . . . . . . 183 4.5.5 Help and support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188 4.6 Python . .
Summary of the content on the page No. 8
A.1 C/C++ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 A.2 PHP. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 262 A.3 Ruby . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263 A.4 Python. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264 A.5 Perl . . . . . . . . . .
Summary of the content on the page No. 9
Notices This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, progra
Summary of the content on the page No. 10
Trademarks IBM, the IBM logo, and ibm.com are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. These and other IBM trademarked terms are marked on their first occurrence in this information with the appropriate symbol (® or ™), indicating US registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countr
Summary of the content on the page No. 11
Preface DB2® provides various installation methods as well as features and tools to deploy a large number of clients and servers. Database administrators, application developers, and application architects have a number of available options when deploying DB2 9.5 for Linux®, UNIX®, and Windows® (DB2 for LUW). Focusing on the DB2 V9.5 deployment methodology, this IBM® Redbooks® publication provides general guidance and serves as a reference resource for DB2 based solution deployment. These
Summary of the content on the page No. 12
focuses on DB2 MPP system and performance tuning in complex environments. He also has a job role in a leading critical situation support team for large customers. Prior to joining IBM, he was an application developer providing data warehouse/BI solutions to customers. He is a Certified DB2 Application Developer and Database Administrator. Carsten Block is a Senior IT Specialist with IBM Global Services in Denmark. He has been working in the computer industry for the last 15 years, and has
Summary of the content on the page No. 13
Helmut Riegler IBM Austria Yvonne Lyon, Sangam Racherla, Emma Jacobs International Technical Support Organization, San Jose Center Become a published author Join us for a two- to six-week residency program! Help write a book dealing with specific products or solutions, while getting hands-on experience with leading-edge technologies. You will have the opportunity to team with IBM technical professionals, Business Partners, and Clients. Your efforts will help increase product acceptance and c
Summary of the content on the page No. 14
xii DB2 Deployment Guide
Summary of the content on the page No. 15
1 Chapter 1. Introduction to DB2 deployment In this chapter, we introduce various aspects of DB2 9.5 for Linux, UNIX, and Windows deployment. We present various DB2 9.5 product offerings and items to consider during deployment planning. We discuss the following topics: Various product offerings from DB2 9.5 for Linux, UNIX, and Windows Key items to consider during deployment planning © Copyright IBM Corp. 2008. All rights reserved. 1
Summary of the content on the page No. 16
1.1 DB2 deployment overview Database administrators, application developers, and application architects have a number of available options when deploying DB2 9.5 for Linux, UNIX, and Windows. Planning the deployment of DB2 based solutions among various operating system platforms and DB2 products might appear be a complex endeavor. In order to assist with deployment planning, this book provides general guidance and serves as a reference resource for DB2 based solution deployment. DB2 V9.5
Summary of the content on the page No. 17
1.2 DB2 9.5 for UNIX, Linux, and Windows products One of the first things to consider during deployment planning is to choose the right DB2 product for your enterprise. The DB2 product is available on Windows 2000/2003/XP/Vista, Linux, AIX®, Hewlett-Packard’s HP-UX, Sun™ Microsystems’ Solaris™, OS/400®, i5/OS®, VSE/VM, and z/OS®. The SQL API is common to all platforms for DB2 products, allowing data to be accessed freely across various platforms. The DB2 9.5 with a pureXML™ and relational
Summary of the content on the page No. 18
DB2 Workgroup Server Edition Designed for midsize businesses, it has all of the functionality of DB2 Express plus an optional Query Optimization Feature. It has more extensive licensing and a resource usage limit of 480 Processor Value Unit (PVU) and memory limit of 16 GB. This product is available on AIX, Windows, Linux, HP-UX, and Solaris. DB2 Enterprise Server Edition Scalable to handle large volume transaction processing, it is designed for large businesses. All features available to DB2
Summary of the content on the page No. 19
administration and client/server configuration. Note that GUI tools are available for Windows on x86 32 bit, Windows on x64 (EM64T/AMD64), Linux on x86/ EM64T/AMD64. It also contains tools to assist with application development and contains bind files. The application development tools include application header files, pre-compilers, bind utilities, and sample codes. It was previously known as DB2 Administration Client or DB2 Client. IBM Data Server Driver for ODBC, CLI, and .NET New to DB2
Summary of the content on the page No. 20
Any SQLJ or JDBC application that accesses i5/OS using IBM Data Server Driver for JDBC and SQLJ type 4 connectivity, must ensure that the OS/400 operating system supports the Unicode UTF-8 encoding scheme. Downloadable DB2 products and components are listed in Table 1-1. Table 1-1 Downloadable DB2 products and components DB2 Products and components Download IBM DB2 9.5 Express-C https://www14.software.ibm.com/webapp/iwm/web/ preLogin.do?lang=en_US&source=swg-db2expresscviper2 IBM Data Serv
