User ManualTable of ContentsFront cover1Contents5Notices9Trademarks10Preface11The team that wrote this book11Acknowledgements12Become a published author13Comments welcome13Chapter 1. Introduction to DB2 deployment151.1 DB2 deployment overview161.2 DB2 9.5 for UNIX, Linux, and Windows products171.2.1 DB2 Server products171.2.2 DB2 clients and drivers181.2.3 DB2 standalone and connect products211.2.4 Other DB2 products221.3 Deployment considerations241.3.1 New environment versus environment with existing DB2 installation251.3.2 DB2 version considerations301.3.3 DB2 product considerations311.3.4 License considerations341.3.5 Authorization considerations361.3.6 Configuration considerations401.3.7 Other considerations40Chapter 2. DB2 server deployment432.1 Server deployment planning442.1.1 System requirement442.1.2 User and group required in deployment442.1.3 Non-root/non-Administrator installation462.1.4 DB2 configuration profile and database profile482.1.5 Considerations for a partitioned database532.2 DB2 server deployment methods562.2.1 DB2 Setup wizard572.2.2 db2_install602.2.3 Response file622.2.4 Payload file deployment (for Linux and UNIX)712.3 Mass deployment of DB2 server using a script722.3.1 Setup of SSH and NFS732.3.2 DB2 license772.3.3 Creating the deployment script782.3.4 Windows deployment scripts872.4 Fix pack deployment892.4.1 Fix pack overview902.4.2 Mass deployment of DB2 fix pack with a script92Chapter 3. DB2 client deployment1033.1 Client deployment planning1043.1.1 Select the right client type1043.1.2 Footprint1053.1.3 Reducing the size of the install image1053.1.4 Configuration and customization1063.1.5 Compatibility1073.1.6 Licensing1083.1.7 How to deploy the DB2 client1083.2 IBM Data Server Client, Runtime Client, Driver for ODBC, CLI, and .NET1083.2.1 IBM data server client installation methods1093.2.2 Client instance on the DB2 server1113.2.3 Reducing the installation image1113.2.4 Mass deployment of IBM data server client product1143.3 Thin Client deployment145Chapter 4. Deploying applications with DB21514.1 Introduction to application deployment package1524.1.1 IBM Data Server Driver for JDBC and SQLJ1524.1.2 IBM Data Server Driver for ODBC, CLI, and .NET, and IBM Data Server Driver for ODBC and CLI1574.2 Java1644.3 Deploying C/C++ applications1684.3.1 CLI and ODBC1684.3.2 Sample application1704.3.3 Considerations for deployment of CLI and ODBC applications1724.3.4 Deploying a CLI application along with ODBC CLI driver1734.3.5 Embedded SQL and Administrative API1834.4 PHP1834.4.1 PDO_IBM1844.4.2 IBM_DB21844.4.3 Installation of IBM PHP drivers1844.4.4 PHP1854.4.5 Sample application1884.4.6 Deploying a PHP application with the DB2 drivers1894.5 Ruby1954.5.1 IBM IBM_DB gem1954.5.2 Installation of IBM_DB gem1954.5.3 Creating a sample Ruby application1974.5.4 Deploying a Ruby application with the DB2 drivers1974.5.5 Help and support2024.6 Python2034.6.1 IBM_DB driver2034.6.2 IBM_DB_DBI wrapper2034.6.3 IBM_DB_SA adaptor2044.6.4 Installation of IBM Python drivers2044.6.5 Creating a sample Python application2064.6.6 Deploying a Python application with the DB2 drivers2074.6.7 Help and support2134.7 Perl2134.7.1 DBD::DB22134.7.2 Installation of IBM Perl driver2144.7.3 Creating a sample Perl application2164.7.4 Deploying a Perl application with the DB2 drivers2174.7.5 Help and support2224.8 .NET222Chapter 5. Deploying pre-configured databases2275.1 Introduction2285.1.1 Sample database2295.2 Deploying a database using scripts2305.2.1 Collecting information about the database2315.2.2 Using a shell script2365.2.3 Using an application2425.3 Deploying a database using a backup image2455.4 Populating the database2465.4.1 Using SQL statements2465.4.2 Using DB2 utilities2495.5 Updating an existing installation2545.5.1 Updating non-table objects2555.5.2 Updating table objects2565.5.3 Automating update using DB2 metadata with a Java application2605.5.4 Alternatives: DB2 tools2655.6 Samples overview2655.6.1 Scripts2665.6.2 Shell scripts2665.6.3 Java applications269Appendix A. Sample applications273A.1 C/C++273A.2 PHP276A.3 Ruby277A.4 Python278A.5 Perl279Appendix B. Additional material281Locating the Web material281Using the Web material282System requirements for downloading the Web material282How to use the Web material282Related publications283IBM Redbooks283Other publications283Online resources286How to get Redbooks287Help from IBM287Index289Back cover298Size: 3.72 MBPages: 298Language: EnglishOpen manual
