12/08/95 Making an Instance for DB2 (v1.1-1.2) on AIX 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 how to make an instance for DB2 v1.1 and v1.2 and is applicable to AIX versions 3.2.5 and 4.1. STEPS TO MAKING AN INSTANCE 1. Login as root. 2. Create a group and user for the database instance owner, such as: mkgroup sysadm1 mkuser pgrp=sysadm1 groups=sysadm1 home=/home/inst1 inst1 passwd inst1 (set the password for inst1) NOTE: The group and user name have restrictions in their naming. Documentation can be found in the DB2 "Installation Guide". These restriction vary slightly across platforms. In this example inst1 is the instance owner and sysadm1 is the group. 3. Instance Command: /usr/lpp/db2_01_01_0000/instance/db2instance inst1 Once you run this command a new directory tree will be created under /home/inst1/sqllib. This should not be altered or used outside of the database. 4. Edit the .profile created in /home/inst1. vi /home/inst1/.profile Add the following line: . /home/inst1/sqllib/db2profile NOTE There is a "." before "/home...". If you forget the "." then the command will not update your current shell. Making an Instance for DB2 (v1.1-1.2) on AIX 1 12/08/95 5. You have now completed the process of making an instance. You can now proceed to issue a db2start, after logging in as the instance owner. FURTHER CONSIDERATIONS If you have never worked with DB2 or any other relational DB you may want to request the supplement to this document titled "Creating the SAMPLE Data Base (v1) for AIX" from your support center. Making an Instance for DB2 (v1.1-1.2) on AIX 2 12/08/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 (instance.v11-12.dbs) Making an Instance for DB2 (v1.1-1.2) on AIX 3