Ibm Db2 Users Manual Deployment Guide

2015-02-02

• Go to the current abstract on ibm.com/redbooks
• Front cover
• Contents
• Notices
  • Trademarks
• Preface
  • The team that wrote this book
    • Acknowledgements
  • Become a published author
  • Comments welcome
• Chapter 1. Introduction to DB2 deployment
  • 1.1 DB2 deployment overview
  • 1.2 DB2 9.5 for UNIX, Linux, and Windows products
    • 1.2.1 DB2 Server products
    • 1.2.2 DB2 clients and drivers
    • 1.2.3 DB2 standalone and connect products
    • 1.2.4 Other DB2 products
  • 1.3 Deployment considerations
    • 1.3.1 New environment versus environment with existing DB2 installation
    • 1.3.2 DB2 version considerations
    • 1.3.3 DB2 product considerations
    • 1.3.4 License considerations
    • 1.3.5 Authorization considerations
    • 1.3.6 Configuration considerations
    • 1.3.7 Other considerations
• Chapter 2. DB2 server deployment
  • 2.1 Server deployment planning
    • 2.1.1 System requirement
    • 2.1.2 User and group required in deployment
    • 2.1.3 Non-root/non-Administrator installation
    • 2.1.4 DB2 configuration profile and database profile
    • 2.1.5 Considerations for a partitioned database
  • 2.2 DB2 server deployment methods
    • 2.2.1 DB2 Setup wizard
    • 2.2.2 db2_install
    • 2.2.3 Response file
    • 2.2.4 Payload file deployment (for Linux and UNIX)
  • 2.3 Mass deployment of DB2 server using a script
    • 2.3.1 Setup of SSH and NFS
    • 2.3.2 DB2 license
    • 2.3.3 Creating the deployment script
    • 2.3.4 Windows deployment scripts
  • 2.4 Fix pack deployment
    • 2.4.1 Fix pack overview
    • 2.4.2 Mass deployment of DB2 fix pack with a script
• Chapter 3. DB2 client deployment
  • 3.1 Client deployment planning
    • 3.1.1 Select the right client type
    • 3.1.2 Footprint
    • 3.1.3 Reducing the size of the install image
    • 3.1.4 Configuration and customization
    • 3.1.5 Compatibility
    • 3.1.6 Licensing
    • 3.1.7 How to deploy the DB2 client
  • 3.2 IBM Data Server Client, Runtime Client, Driver for ODBC, CLI, and .NET
    • 3.2.1 IBM data server client installation methods
    • 3.2.2 Client instance on the DB2 server
    • 3.2.3 Reducing the installation image
    • 3.2.4 Mass deployment of IBM data server client product
  • 3.3 Thin Client deployment
• Chapter 4. Deploying applications with DB2
  • 4.1 Introduction to application deployment package
    • 4.1.1 IBM Data Server Driver for JDBC and SQLJ
    • 4.1.2 IBM Data Server Driver for ODBC, CLI, and .NET, and IBM Data Server Driver for ODBC and CLI
  • 4.2 Java
  • 4.3 Deploying C/C++ applications
    • 4.3.1 CLI and ODBC
    • 4.3.2 Sample application
    • 4.3.3 Considerations for deployment of CLI and ODBC applications
    • 4.3.4 Deploying a CLI application along with ODBC CLI driver
    • 4.3.5 Embedded SQL and Administrative API
  • 4.4 PHP
    • 4.4.1 PDO_IBM
    • 4.4.2 IBM_DB2
    • 4.4.3 Installation of IBM PHP drivers
    • 4.4.4 PHP
    • 4.4.5 Sample application
    • 4.4.6 Deploying a PHP application with the DB2 drivers
  • 4.5 Ruby
    • 4.5.1 IBM IBM_DB gem
    • 4.5.2 Installation of IBM_DB gem
    • 4.5.3 Creating a sample Ruby application
    • 4.5.4 Deploying a Ruby application with the DB2 drivers
    • 4.5.5 Help and support
  • 4.6 Python
    • 4.6.1 IBM_DB driver
    • 4.6.2 IBM_DB_DBI wrapper
    • 4.6.3 IBM_DB_SA adaptor
    • 4.6.4 Installation of IBM Python drivers
    • 4.6.5 Creating a sample Python application
    • 4.6.6 Deploying a Python application with the DB2 drivers
    • 4.6.7 Help and support
  • 4.7 Perl
    • 4.7.1 DBD::DB2
    • 4.7.2 Installation of IBM Perl driver
    • 4.7.3 Creating a sample Perl application
    • 4.7.4 Deploying a Perl application with the DB2 drivers
    • 4.7.5 Help and support
  • 4.8 .NET
• Chapter 5. Deploying pre-configured databases
  • 5.1 Introduction
    • 5.1.1 Sample database
  • 5.2 Deploying a database using scripts
    • 5.2.1 Collecting information about the database
    • 5.2.2 Using a shell script
    • 5.2.3 Using an application
  • 5.3 Deploying a database using a backup image
  • 5.4 Populating the database
    • 5.4.1 Using SQL statements
    • 5.4.2 Using DB2 utilities
  • 5.5 Updating an existing installation
    • 5.5.1 Updating non-table objects
    • 5.5.2 Updating table objects
    • 5.5.3 Automating update using DB2 metadata with a Java application
    • 5.5.4 Alternatives: DB2 tools
  • 5.6 Samples overview
    • 5.6.1 Scripts
    • 5.6.2 Shell scripts
    • 5.6.3 Java applications
• Appendix A. Sample applications
  • A.1 C/C++
  • A.2 PHP
  • A.3 Ruby
  • A.4 Python
  • A.5 Perl
• Appendix B. Additional material
  • Locating the Web material
  • Using the Web material
    • System requirements for downloading the Web material
    • How to use the Web material
• Related publications
  • IBM Redbooks
  • Other publications
  • Online resources
  • How to get Redbooks
  • Help from IBM
• Index
• Back cover