How to get Redbooks, Help from IBM | IBM DB2 specification

DB2 Perl Database Interface http://www.ibm.com/software/data/db2/perl

Comprehensive Perl Archive Network

http://www.cpan.org http://www.cpan.org/modules/by-category/07_Database_Interfaces/DBI

Apache HTTP Server Project http://httpd.apache.org

Perl.apache.org

http://perl.apache.org/docs/1.0/guide/

PHP scripting language http://www.php.net/

IBM Tivoli System Automation for Multiplatforms

http://publib.boulder.ibm.com/tividd/td/ITSAFL/SC33-8272-01/en_US/PDF/HALBA U01.pdf

How to get Redbooks

You can search for, view, or download Redbooks, Redpapers, Technotes, draft publications and Additional materials, as well as order hardcopy Redbooks, at this Web site:

ibm.com/redbooks

Help from IBM

IBM Support and downloads

ibm.com/support

IBM Global Services

ibm.com/services

Related publications 273

Image 287

IBM DB2 manual How to get Redbooks, Help from IBM

Contents

DB2 Deployment Guide Page SG24-7653-00 DB2 Deployment Guide First Edition October Contents Iv DB2 Deployment Guide Ruby NET Contents Vi DB2 Deployment Guide C/C++ PHP Ruby Python Perl Copyright License Vii General Parallel File System PSeries TrademarksInformix Redbooks logo Cloudscape InfoSphere OS/400 WebSphere EServer Team that wrote this book Preface DB2 Deployment Guide AcknowledgementsIBM Toronto Laboratory, Canada Jian, John, and Carsten Preface Become a published authorComments welcome IBM Austria Xii DB2 Deployment Guide Introduction to DB2 deployment DB2 deployment overview DB2 Express Edition DB2 9.5 for UNIX, Linux, and Windows products1 DB2 Server products DB2 Express-C and DB2 Express-C FTL Edition IBM Data Server Runtime Client 2 DB2 clients and driversDB2 Workgroup Server Edition DB2 Enterprise Server Edition IBM Data Server Driver for Jdbc and Sqlj IBM Data Server Driver for ODBC, CLI, and .NET DB2 Products and components Download Downloadable DB2 products and components 3 DB2 standalone and connect products IBM Database Enterprise Developer Edition Dede Other DB2 products DB2 product availability InfoSphere Warehouse as 10 DB2 Deployment Guide Deployment considerations Introduction to DB2 deployment 12 DB2 Deployment Guide Nature of the client and applicationSupported client /server matrix Hardware requirements for Version Client/server relationshipHardware and software considerations 14 DB2 Deployment Guide Software requirement for DB2 Introduction to DB2 deployment 16 DB2 Deployment Guide 2 DB2 version considerations 3 DB2 product considerations DB2 for LUW Server product listing Features and functions 18 DB2 Deployment Guide DB2 9.5 server product overview 20 DB2 Deployment Guide License considerationsAuthorized User license Processor Value Units per core Processor Value Unit license 22 DB2 Deployment Guide Authorization considerations Limitations Requirements and limitations on Linux and Unix platformsRequirements 24 DB2 Deployment Guide Requirements and limitations in Windows platforms Key differences Hkeycurrentuser 26 DB2 Deployment Guide Configuration considerationsOther considerations Installation method Windows Linux or Unix Installation methods 28 DB2 Deployment Guide DB2 server deployment 30 DB2 Deployment Guide Server deployment planningSystem requirement User and group required in deployment DB2 server deployment DB2 Users and groups on Linux and UnixInstance owner user Fenced user Windows security Non-root/non-Administrator installationNon-root installation on UNIX/Linux Administration server user Elevated privileges installation on Windows 34 DB2 Deployment Guide 4 DB2 configuration profile and database profile DB2 Configuration Assistant 36 DB2 Deployment Guide Example 2-1 File generated by DB2 configuration Assistant This local instance Db2cfexp and db2cfimpOptions for db2cfexp Information Standard output Database configurationDb2look command options Specify database name Example 2-2 db2look output Considerations for a partitioned database 40 DB2 Deployment Guide Licensing for a partitioned database Users and groups in a partitioned database environment Remote shell 42 DB2 Deployment Guide Communication settingsDB2 server deployment methods Example 2-3 TCP/IP ports 1 DB2 Setup wizard 44 DB2 Deployment Guide DB2setup launchpad Set user information 46 DB2 Deployment Guide 2 db2install Example 2-4 The output of command db2install 48 DB2 Deployment Guide Response file Example 2-5 Format of a response file 50 DB2 Deployment Guide Creating a response file using the DB2 Setup wizard Instance Example 2-6 Using db2rspgn 52 DB2 Deployment Guide Creating a response file from the sample response file Example 2-7 The response file generated from sample Instance 54 DB2 Deployment Guide Deploying DB2 server with application 56 DB2 Deployment Guide Example 2-8 The value of keyword Interactive is changed Will be transformed to this format Payload file deployment for Linux and Unix 58 DB2 Deployment Guide Mass deployment of DB2 server using a script Example 2-9 NFS file sets on AIX Setup of SSH and NFSInstalling SSH on managed machines 60 DB2 Deployment Guide Enabling SSH automatic login for root user Example 2-14 Files generated by above commands 62 DB2 Deployment Guide Example 2-16 Public key is kept in authorizedkeys on Baltic 2 DB2 license NFS configurationExample 2-17 Verify NFS configuration from command line 64 DB2 Deployment Guide Creating the deployment script Logic of the mass deployment script Example 2-18 Source code of db2srvinstall 66 DB2 Deployment Guide DB2 server deployment 68 DB2 Deployment Guide Following command line syntax is used for db2srvinstall Command line options 70 DB2 Deployment Guide Example 2-19 NFS path where db2 image has been extractedExample 2-20 Copy response file to NFS path Running a mass deployment Example 2-21 Mass deployment using db2install 72 DB2 Deployment Guide Example 2-22 Mass deployment using response file Example 2-23 DB2 copies existing on baltic Example 2-24 Install path conflicts with existing DB2 copyWindows deployment scripts 74 DB2 Deployment Guide Example 2-26 Sample Windows deployment script output Fix pack deployment 76 DB2 Deployment Guide Fix pack overview Stopping all DB2 processes before deployment Environment Mass deployment of DB2 fix pack with a scriptDeployment method Tasks after fix pack deployment Network topology of mass fix pack deployment Script logic and command line options 80 DB2 Deployment Guide Logics of DB2 fix pack mass deployment script Example 2-27 Source code of fix pack mass deployment script Sample deployment script 82 DB2 Deployment Guide DB2 server deployment 84 DB2 Deployment Guide Starting fixpack deployment on machine %s using %s...\n 86 DB2 Deployment Guide Example 2-28 Performing the mass deployment of DB2 fix pack Example 2-29 List the installed DB2 copies 88 DB2 Deployment Guide DB2 client deployment Option B IBM DB2 clients Client deployment planningSelect the right client type Option a IBM Data Server Driver DB2 client deployment Reducing the size of the install imageFootprint 92 DB2 Deployment Guide Configuration and customizationConfiguration profile Db2cli.ini initialization file Client /Server compatibility CompatibilityMultiple instance compatibility 94 DB2 Deployment Guide How to deploy the DB2 clientLicensing IBM data server client installation methods 96 DB2 Deployment Guide DB2 Setup wizardDb2install script Response file install Client instance on the DB2 server Reducing the installation imageDb2iprune command line utility 98 DB2 Deployment Guide Example 3-1 Entries in the .prn file Considerations for a pruned DB2 installation 100 DB2 Deployment Guide Mass deployment of IBM data server client productIBM data server client deployment on Windows SMS Administration Console Administrator Console Package Definition window Welcome screen Selecting DB2 package definition Specify source directory for selected package Source Files window Completing the Create Package from Definition Wizard 106 DB2 Deployment Guide 11 Start software distribution 12 Welcome to the Distribute Software Wizard 15 Advertise a Program window 14 Selecting distribution points 16 Select a Program to Advertise window 19 Advertise to Subcollections window 18 Advertisement Name window 20 Advertisement Schedule window 112 DB2 Deployment Guide 22 Completing the Distribute Software Wizard window 23 Configuration Manager Console 114 DB2 Deployment Guide 25 Create Package from Definition Wizard window 27 Create Package from Definition Wizard window 116 DB2 Deployment Guide 28 Source Files window 29Source Directory window 118 DB2 Deployment Guide 30 Completing the Create Package from Definition Wizard 31 Create Package from Definition Wizard window Distributing DB2 install packages using the Microsoft Sccm 33 Welcome to the Distribute Software Wizard window 32 Starting software distribution 34 Packages window 122 DB2 Deployment Guide 36 Advertise a Program window 37 Select a Program to Advertise window 124 DB2 Deployment Guide 38 Advertisement Target window 39 Advertisement Name window 126 DB2 Deployment Guide 40 Advertise to Subcollections window 41 Advertisement Schedule window 128 DB2 Deployment Guide 42 Assign Program window 43 Distribute Package Wizard window 130 DB2 Deployment Guide IBM data server client deployment on Linux and UnixExample 3-2 Push deployment script Thin Client deployment 132 DB2 Deployment Guide 45 Select the features to install 46 Sharing the code server directory Creating a thin client response file 134 DB2 Deployment Guide Setting up thin clients using the thnsetup command Network drive. This parameter is mandatory on Windows XP 136 DB2 Deployment Guide 137 Deploying applications with DB2 138 DB2 Deployment Guide Introduction to application deployment packageIBM Data Server Driver for Jdbc and Sqlj Prerequisites Deploying applications with DB2 LOS/400 PTFs for Unicode UTF-8 support 140 DB2 Deployment Guide Installation procedureIBM Data Server Driver for Jdbc and Sqlj files Library file names for different platforms Database server configuration setup 142 DB2 Deployment Guide Bm.db2.luw.apdv.java.doc/doc/t0024156.html 144 DB2 Deployment Guide Deploying applications with DB2 146 DB2 Deployment Guide Installing IBM Data Server Driver for Odbc and CLIInstalling IBM Data Server Driver for ODBC, CLI, and .NET DB2 registry variables supported as environment variables Configuring IBM Data Server Driver for Odbc and CLI 148 DB2 Deployment Guide Diagnostic variablesMiscellaneous variables Connection variables Set PATH=clidriverpath\binclidriverpath\lib%PATH% 150 DB2 Deployment Guide JavaLicense requirements Prerequisites 152 DB2 Deployment Guide Deployment procedure for a Java applicationExample 4-2 Deployment structure for our Java application Example 4-4 Successful test of our deployed application 154 DB2 Deployment Guide Deploying C/C++ applicationsCLI and Odbc Odbc vs. CLI Comparison of CLI and Odbc Isolation level mapping between Odbc and DB2 Sample application Logic of sample application 158 DB2 Deployment Guide Connecting to databaseConsiderations for deployment of CLI and Odbc applications Redistributable driver files Preparing the redistributable driver files Example 4-5 Content of redist.txtDeploying a CLI application along with Odbc CLI driver 160 DB2 Deployment Guide Example 4-6 Script file bldpkg Deploying applications with DB2 162 DB2 Deployment Guide Example 4-8 Verify package contentPreparing the application executable file Compile and link the application in one step Example 4-9 a successful connection using itsocliapp Preparing the deployment package Example 4-10 a failed connect test using itsocliappExample 4-11 The complete contents of installimage Example 4-12 Source codes of script appinstall 166 DB2 Deployment Guide Deploying the application package to the target system 168 DB2 Deployment Guide Example 4-14 Deploy application using scrip appinstallt Example 4-15 Verify the connection after deployment Embedded SQL and Administrative APIPHP 170 DB2 Deployment Guide Installation of IBM PHP driversPdoibm IBMDB2 IBM Data Server Driver for CLI support Installation procedure on Linux and Unix4 PHP Prerequisites 172 DB2 Deployment Guide Example 4-16 Lines to added to php.ini fileExample 4-17 Output of php -m Installation procedure on Windows 174 DB2 Deployment Guide Deploying a PHP application with the DB2 drivers Example 4-18 a successful connection using itsophpapp.phpExample 4-19 Failed connection using itsophpapp.php 176 DB2 Deployment Guide Example 4-20 Deployment script phpappinstallPreparing the PHP application package Deploying applications with DB2 178 DB2 Deployment Guide Example 4-22 Package generation for phpdeploy Example 4-21 Contents of phpdeploy directory 180 DB2 Deployment Guide Example 4-23 Deploying using script phpappinstallDeploying the DB2 PHP application Example 4-24 Verifying deployed PHP application IBM Ibmdb gem Installation of Ibmdb gemRuby 182 DB2 Deployment Guide Installation procedure for Linux, UNIX, and Windows Deploying a Ruby application with the DB2 drivers Example 4-25 Successful connection using itsorubyapp.rbExample 4-26 Failed connection using itsorubyapp.rb Creating a sample Ruby application 184 DB2 Deployment Guide Example 4-27 Code of script rubyappinstallPreparing the Ruby application package Deploying applications with DB2 186 DB2 Deployment Guide Example 4-29 Package generation for rubydeploy Example 4-28 Contents of rubydeployment directoryDeploying the DB2 Ruby application 188 DB2 Deployment Guide Example 4-30 Deploying using script rubyappinstallExample 4-31 Testing deployed Ruby application Help and support Ibmdbdbi wrapper PythonIbmdb driver 190 DB2 Deployment Guide Installation of IBM Python driversIbmdbsa adaptor Installation procedure 192 DB2 Deployment Guide Example 4-32 Successful connection using itsopyapp.pyCreating a sample Python application Deploying a Python application with the DB2 drivers Example 4-33 Failed connection using itsopyapp.py 194 DB2 Deployment Guide Example 4-34 Code of script pyappinstallPreparing the Python application package Deploying applications with DB2 196 DB2 Deployment Guide Example 4-36 Package generation for pythondeploy Example 4-35 Contents of pythondeploy directoryDeploying the sample Python application 198 DB2 Deployment Guide Example 4-37 Deploying using script pyappinstall Example 4-38 Verifying deployed Python application PerlDBDDB2 200 DB2 Deployment Guide Installation of IBM Perl driverPrerequisites to installing DBDDB2 Example 4-39 Installing DBI on Linux and Unix Example 4-41 Installation commands for installing DBDDB2 Installation procedure for Linux and Unix 202 DB2 Deployment Guide Installation procedure for WindowsExample 4-42 a successful connection using itsoperlapp.pl Creating a sample Perl application Preparing Perl driver and redistributable DB2 driver files Example 4-43 Failed connection using itsoperlapp.plDeploying a Perl application with the DB2 drivers 204 DB2 Deployment Guide Example 4-44 Code of script perlappinstallPreparing the Perl application package Deploying applications with DB2 Example 4-46 Package generation for perldeploy Example 4-45 Contents of perldeploy directory Deploying the DB2 Perl application Example 4-47 Deployment using script perlappinstall 208 DB2 Deployment Guide NETExample 4-48 Verifying deployed Perl application Deployment procedure for a .NET application 210 DB2 Deployment Guide Example 4-49 Response file contentExample 4-50 Silent install of the IBM Data Server Driver Example 4-51 Call to testconn20 and the resulting output 212 DB2 Deployment Guide 213 Deploying pre-configured databases 214 DB2 Deployment Guide Using a backup imageIntroduction 215 Using scriptsDeploying pre-configured databases Sample database 216 DB2 Deployment Guide Deploying a database using scripts 217 Collecting information about the databaseDatabase creation Database layout 218 DB2 Deployment Guide Example 5-2 Itsodb layout buffer pool and table spaces Example 5-4 DDL statement for creating the Department table Database objects219 Creating a database with the output from db2look Example 5-5 Using db2look to get DDL statementsDb2look Dependencies between database objects Example 5-6 Check and set integrity on our sample database 221 222 DB2 Deployment Guide Using a shell scriptCommand line processor options CLP return codes and the impact of the -s option CLP return codes223 224 DB2 Deployment Guide Unix script Example C Windows scriptExample a Example B 226 DB2 Deployment Guide 227 Complete Windows example 228 DB2 Deployment Guide Using an applicationStep Example 5-10 Executing a script from within Java Creating the database from Java229 230 DB2 Deployment Guide Creating database layout and database objects from Java 231 Deploying a database using a backup imageJava sample applications 232 DB2 Deployment Guide Using SQL statementsPopulating the database 233 Using a shell script 234 DB2 Deployment Guide Using an applicationExample 5-13 Run the Java sample applications Exporting data Using DB2 utilities Different import modes Importing dataImport utility 237 Load utility 238 DB2 Deployment Guide Db2move utility 239 Exporting data with db2moveImporting data with db2move Loading data with db2move 240 DB2 Deployment Guide Updating an existing installation 241 Updating non-table objects 242 DB2 Deployment Guide Updating table objectsPreparing data Altering the table 243 Using the stored procedure altobjExample 5-20 Using altobj to change the table itso.staff 244 DB2 Deployment Guide Using a custom script Example 5-21 Custom script to change itso.staff 245 246 DB2 Deployment Guide DB2 metadata for database layout DB2 metadata for some of the database objects Java sample application Automating updateWhere to find the dependent objects for a table 247 248 DB2 Deployment Guide Comparing two database configurationsBuilding the dependency map 249 Big picture of the application 250 DB2 Deployment Guide Overview of the Java application 251 Samples overviewAlternatives DB2 tools Scripts containing DDL and SQL statements ScriptsShell scripts Shell scripts 253Supportive shell scripts Argument. Example cexe createdb.cmd Log filepopulatedb.log Log file export.logLog file importdb.log Log file loaddb.log Java applications Java applications255 Configuration of the ITSO2 database Print out both database configurations to stdoutCompare two database configurations and list new tables Database given as argument to meet the configuration Modified to reflect the target environment. Example 25710 Shell scripts to start Java applications Target environment. Example 258 DB2 Deployment Guide Example A-1 Sample CLI application C/C++259 260 DB2 Deployment Guide Appendix A. Sample applications 262 DB2 Deployment Guide Example A-2 Sample PHP application Example A-3 Sample Ruby application 264 DB2 Deployment Guide Example A-4 Sample Python application Example A-5 Sample Perl application 266 DB2 Deployment Guide 267 Locating the Web material System requirements for downloading the Web material Using the Web materialHow to use the Web material 269 IBM RedbooksOther publications IBM DB2 270 DB2 Deployment Guide Related publications 272 DB2 Deployment Guide Online resourcesLinux Other Help from IBM How to get Redbooks 274 DB2 Deployment Guide Prn extension SymbolsNumerics 275 148 Db2setup Db2sorcvbuf 147147 Db2cfexp Db2cfimp Db2chgpath Db2cli.ini 167 103Page Msdtc Page Page DB2 Deployment Guide Page Page DB2 Deployment Guide