11/22/95 Howto Download & Install Service Packs for DB2/6k 1.2 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-5972. 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 relates the procedure for using FTP to down load the latest service and installing it to your machine. This document is applicable to AIX versions 3.2.5 and 4.1. If you do not have FTP access then you will need to call 1-800-237-5511 and order a PTF on tape/cd media. STEPS 1. Confirm the system's current level of DB2/6000. lslpp -h db2_01_01_0000.db2 To use the document you should see a base level of 1.2.0.*. 2. ftp ps.boulder.ibm.com and Login as "anonymous" with password "userid@internet.address". ftp> cd /ps/products/db2/fixes ftp> ls 200 PORT command successful. ftp> cd db2aixv12 250 CWD command successful. ftp> ls 200 PORT command successful. ftp> get U437718.txt /tmp/U437718.txt ftp> get DB26000_V1.2_APAR_Descr.txt /tmp/DB26000_V1.2_APAR_Descr.txt ftp> bin ftp> get db2_01_01_0000.U437718.Z /tmp/db2_01_01_0000.U437718.Z ftp> quit 3. Print out the document file: lpr -P /tmp/U437718.txt Or, read it on-line with: more /tmp/U437718.txt Howto Download 1 Install Service Packs for DB2/6k 1.2 1 11/22/95 4. Install the image. These instructions supersede the instruction in the txt file that you downloaded. Put the install image in its own directory (optional). mkdir /usr/sys/inst.images uncompress /tmp/db2_01_01_0000.U437718.Z mv /tmp/db2_01_01_0000.U437718 /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 appropriate PTFs for your system by pressing the PF7 key when the PTF is highlighted. 5. Use the following commands to check that the package installed properly. lppchk -v lslpp -h | grep BROKEN Both should return without any messages. 6. Update the instance by issuing the db2instupdt command as 'root': /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 new clp packages are to be used. As instance owner execute the commands: $ db2 bind /u/InstName/sqllib/bnd/@db2ubind.lst BLOCKING ALL $ db2 bind /u/InstName/sqllib/bnd/@ddcsbind.lst BLOCKING ALL Run these commands for each database. 8. Read the file /usr/lpp/db2_01_01_0000/U437718/lpp.README to get a full description of the changes initiated by this service pack. FURTHER CONSIDERATIONS If at any time you find a command not working call back to your support center for further assistance. For further information on downloading Service Pack refer- ence the AIX "System Administrator's Guide". Howto Download 2 Install Service Packs for DB2/6k 1.2 2 11/22/95 READER'S COMMENTS Please fax this form to (512) 823-5972, attention "AIXServ Informa- tion". 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 (415-855-4329 outside U.S., from 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.download.dbs12.dbs) Howto Download 3 Install Service Packs for DB2/6k 1.2 3