11/22/95 Howto Download Service Packs for DB2/6K 1.1 SPECIAL NOTICES Information in this document is correct to the best of our knowledge at the time of this writing. Please send feedback by fax to "AIXServ Information" at (512) 823-4009. Please use this information with care. IBM will not be responsible for damages of any kind resulting from its use. The use of this information is the sole responsibility of the customer and depends on the customer's ability to eval- uate and integrate this information into the customer's operational environment. ABOUT THIS DOCUMENT This document describes the procedure for using FTP to down- load the latest service and installing it to your machine. If you do not have FTP access, call 1-800-237-5511 and order a PTF on tape/cd media. This document is applicable to AIX versions 3.2.5 and 4.1. STEPS 1. Confirm the system's current level of DB2/6000. lslpp -h db2_01_01_0000.db2 This document applies to the base level of 1.1.0.2. 2. Get the latest service pack on your system via FTP. # ftp ps.boulder.ibm.com Login as "anonymous" with password "userid@internet.address". ftp> cd /ps/products/db2/fixes ftp> ls 200 PORT command successful. ftp> cd db2aixv11 250 CWD command successful. ftp> ls 200 PORT command successful. ftp> get U437719.txt /tmp/U437719.txt ftp> get DB26000_V1.1_APAR_Descr.txt /tmp/DB26000_V1.1_APAR_Descr.txt ftp> bin ftp> get db2_01_01_0000.U437719.Z /tmp/db2_01_01_0000.U437719.Z ftp> quit 3. Print out the text file. lpr -P /tmp/U437719.txt Or, you could read it on-line with: Howto Download Service Packs for DB2/6K 1.1 1 11/22/95 more /tmp/U437719.txt 4. Install the image. NOTE: The instructions below super- sede the instructions in the "U437719.txt" file. These instructions have you install the image in its own directory which is optional. mkdir /usr/sys/inst.images uncompress /tmp/db2_01_01_0000.U437719.Z mv /tmp/db2_01_01_0000.U437719 /usr/sys/inst.images cd /usr/sys/inst.images inutoc . smitty install_selectable_all Press PF4 and select /usr/sys/inst.images as the instal- lation media. Press the PF4 key to get a list of the software. Do NOT choose to install "all". Instead, select the appro- priate PTFs for your system by pressing the PF7 key when the PTF is highlighted. 5. Check to ensure that the package was installed with the following commands. # lppchk -v This should return without any messages. # lslpp -h | grep BROKEN This should return without any messages. 6. Update each instance as root with the db2instupdt command for each new level. /usr/lpp/db2_01_01_0000/instance/db2instupdt "instance name" This command is necessary to update the instance with a new version of the sqllib/adm executables. 7. Update the databases where the new packages to be used. Execute these commands as instance owner: $ db2 bind /u/InstName/sqllib/bnd/@db2ubind.lst BLOCKING ALL $ db2 bind /u/InstName/sqllib/bnd/@ddcsbind.lst BLOCKING ALL You will need to run these commands for each database. 8. Once you have the new service pack installed read the file: /usr/lpp/db2_01_01_0000/U437719/lpp.README for a full description of the changes. Howto Download Service Packs for DB2/6K 1.1 2 11/22/95 FURTHER CONSIDERATIONS If at any time you find a command not working call your support center for further assistance. For further information you can reference the AIX "System Administrator's Guide". Howto Download Service Packs for DB2/6K 1.1 3 11/22/95 READER'S COMMENTS Please fax this form to (512) 823-4009, attention "AIXServ Informa- tion". You may also e-mail comments to: elizabet@austin.ibm.com. These comments should include the same customer information requested below. Use this form to tell us what you think about this document. If you have found errors in it, or if you want to express your opinion about it (such as organization, subject matter, appearance) or make sug- gestions for improvement, this is the form to use. If you need technical assistance, contact your local branch office, point of sale, or 1-800-CALL-AIX (for information about support offer- ings). These services may be billable. Faxes on a variety of sub- jects may be ordered free of charge from 1-800-IBM-4FAX. Outside the U.S. call 415-855-4329 using a fax machine phone. When you send comments to IBM, you grant IBM a nonexclusive right to use or distribute your comments in any way it believes appropriate without incurring any obligation to you. NOTE: If you have a problem report or item number, supplying that number may help us determine why a procedure did or did not work in your specific situation. Problem Report or Item #: Branch Office or Customer #: Be sure to print your name and fax number below if you would like a reply: Name: Fax Number: ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ END OF DOCUMENT (howto.downld.11.dbs) Howto Download Service Packs for DB2/6K 1.1 4