*********************************************************************** ** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1998. ** ** ALL RIGHTS RESERVED. ** ** ** *********************************************************************** Welcome to IBM* DB2 Universal Database* (DB2*) Image, Audio, and Video Extenders Version 5.2 for HP-UX Version 11 This PTF contains the DB2 Extenders*, which provide a run-time environment for use with DB2 Extenders applications. The PTF also includes a Software Developer's Kit (SDK) for building DB2 Extenders applications. This readme file describes how to install the DB2 Image Extender, DB2 Audio Extender, and DB2 Video Extender packaged with this PTF. All references in this document to "DB2 Extenders" refer to the DB2 Image, Audio, and Video Extenders only. The DB2 Text Extender Version 5.2 for HP-UX is not packaged with this PTF. INSTALLATION REQUIREMENTS _________________________ Before you install the DB2 Extenders in HP-UX, ensure you meet the installation requirements for their server and client components. SERVER REQUIREMENTS The server components for the DB2 Extenders can be installed in an HP-UX 11 server. The server components prerequire the installation of DB2 Version 5.2 (or above) for HP-UX 11. CLIENT REQUIREMENTS The client components for the DB2 Extenders can be installed in an HP-UX 11 client. The client components prerequire installation of the DB2 Version 5.2 (or above) Personal Edition, DB2 Version 5.2 (or above) Client Application Enabler, or DB2 Version 5.2 (or above) Software Developer's Kit for HP-UX 11. INSTALLING THE DB2 EXTENDERS IN HP-UX _____________________________________ 1. Install the product components in the target machine. 2. Establish the DB2 Extenders instance. 3. Establish the DB2 Extenders instance environment. STEP 1 - INSTALL THE PRODUCT COMPONENTS IN THE TARGET MACHINE 1. Log in at the target client or server machine as the root user. 2. cd to a read/writable directory. 3. Download u461707.tar.Z from the ftp site 4. uncompress u461707.tar.Z 5. tar -xvf u461707.tar 6. Run the swinstall program using the command: swinstall This opens the Software Selection window and the Specify Source window. Do the following: a. If necessary, change the Source Host Name. b. Enter the name of your read/writable directory as the value for the Source Depot Path field. c. In the Change Software View field, select Products. d. To return to the Software Selection window, select the OK button. The Software Selection window contains a list of available software to install. e. Highlight the DB2EXT Product if you want to install the Image, Audio, and Video Extenders with documentation in all provided languages. f. If you want to install parts of the Image, Audio, and Video Extenders, choose Open Item from the Actions menu. Highlight fileset and choose mark for Install from the Actions Menu for every fileset you want to install. Select either of the following: DB2EXT.dmbnsrv - Image, Audio, Video Extenders Server DB2EXT.dmbclt - Image, Audio, Video Extenders Client You can install the online documentation regardless of whether you install the Extenders server or client. Table 1 lists online information available for the DB2 Extenders. +---------------------------------------------------------------------------+ | Table 1. DB2 Extenders online information | +-------------------------------------+-------------------------------------+ | ONLINE INFORMATION | LANGUAGE | +-------------------------------------+-------------------------------------+ | de_DE | German | +-------------------------------------+-------------------------------------+ | en_US | English | +-------------------------------------+-------------------------------------+ | fr_FR | French | +-------------------------------------+-------------------------------------+ | ja_JP | Japanese | +-------------------------------------+-------------------------------------+ | ko_KR | Korean | +-------------------------------------+-------------------------------------+ | zh_CN | Simplified Chinese | +-------------------------------------+-------------------------------------+ | zh_TW | Traditional Chinese | +-------------------------------------+-------------------------------------+ g. Choose Install from the Actions menu to begin product installation and to open the Install Analysis window. h. Select the OK button in the Install Analysis window when the Status field displays a Ready message. i. Select the Yes button at the Confirmation window to confirm that you want to install the DB2 Extenders for HP-UX software products. View the Install window to read processing data while the software is being installed. Installation is complete when the Status field indicates Ready and the Note Window opens. The swinstall program loads the fileset, and runs the control scripts for the fileset. The HP-UX operating system provides detailed help for swinstall. Help is available by typing: man swinstall STEP 2 - ESTABLISH THE DB2 EXTENDERS INSTANCE 1. Ensure you are active as the root user. 2. Enter: cd /opt/IBMdb2ex/V5.2 3. Run DMBICRT as follows: ./dmbicrt instanceid __________ where instanceid is an existing DB2 instance user ID or a user ID to be __________ associated with a DB2 instance. Running dmbicrt creates the /u/instanceid/dmb directory. Do not create additional files or __________ directories under /u/instanceid/dmb; these files will be lost if the __________ instance is deleted. As dmbicrt runs, you are prompted to confirm the following: o The request to make instanceid a DB2 instance owner (if it is not __________ already a DB2 instance owner). Respond YES or NO. o The request to create an instance for the DB2 Image, Audio, and Video Extenders for the specified instanceid. Respond YES or NO. __________ 4. Logout. STEP 3 - ESTABLISH THE DB2 EXTENDERS INSTANCE ENVIRONMENT 1. Login as instanceid. __________ 2. Profile scripts for the C shell, Korn shell, and Bourne shell are pro- vided to establish the DB2 Extenders environment: o dmbcshrc for C shell users o dmbprofile for Korn and Bourne shell users. The dmbcshrc and dmbprofile shell scripts contain statements that update paths in your operating system and set environment variables. To establish the DB2 Extenders instance environment, the DB2 Extenders profile script is invoked within the DB2 profile scripts. To ensure this, look for the following line in sallib/db2cshrc: source ${insthome}/dmb/dmbcshrc Or look for the following line in sqllib/db2profile: . ${insthome}/dmb/dmbprofile Invoke the DB2 instance profile within the login profile fo the instanceid user ID. Add the following statements to the end of the __________ login profile: o For the C shell, add the following to .login: setenv LANG en_US.iso88591 source sqllib/db2cshrc o For the Korn and Bourne shells, add the following to the .profile: export LANG=en_US.iso88591 . sqllib/db2profile 3. Logout. CREATING AND MANAGING MULTIPLE INSTANCES ________________________________________ You can create and use multiple instances of the DB2 Extenders server in an HP-UX server. You should create multiple instances if you have created multiple instances of the DB2 server for HP-UX. Each instance of the DB2 Extenders server is associated with an instance of the DB2 server for HP-UX. You can also list the instances of the DB2 Extenders server that are available on a system, select an instance to use, run multiple instances concurrently, and remove instances. CREATING MULTIPLE INSTANCES To create multiple instances of the DB2 Extenders server, repeat "Step 2 - Establish the DB2 Extenders instance" for each instance that you want to create. LISTING INSTANCES Execute the dmbilist command to list all instances of the DB2 Extenders server that are available on a system. The dmbilist command is in /opt/IBMdb2ex/V5.2/instance. To find out which instance is active, enter the following command: echo $DB2MMTOP SELECTING AN INSTANCE You specify which instance of the DB2 Extenders server to use by setting the DB2INSTANCE environment variable to the login name of the instance owner. RUNNING MULTIPLE INSTANCES CONCURRENTLY To run multiple instances of the DB2 Extenders server concurrently, we recommend that you: o Login or su to a user with sysmaint or higher authority for the instance. o Set the environment. o Start the database manager. If you use the su command, specify the - flag to make sure the correct user environment is initialized. For example: su - inst2 REMOVING INSTANCES To remove an instance of the DB2 Extenders server: 1. End all applications that are currently using the instance. 2. Stop extender services and the db2ext command-line processor. Issue the dmbstop and db2ext terminate commands. 3. Backup files in the INSTHOME/dmb directory if needed, such as qbic, where INSTHOME is the home directory of the instance owner. 4. As root, execute the dmbidrop command in /opt/IBMdb2ex/V5.2/instance as follows: dmbidrop instanceName ____________ where instanceName is the name of the instance being dropped. ____________ The dmbidrop command removes the instance entry from the list of instances and erases the INSTHOME/dmb directory. The dmbidrop command does not remove the associated DB2 instance. 5. As root, remove the instance owner's userid and group (if used only for that instance). Do not remove these if you are planning to recreate the instance. * are trademarks or registered trademarks of IBM Corporation.