12/21/95
 
  Instance/Database Migration for DB2/6000
 
 
 
  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 explains how to migrate an instance and a
       database from version 1 of DB2/6000 to version 2 and is
       applicable to AIX versions 3.2.5 and 4.1.
 
       1.  Login as SYSADM for the Version 1 instance and perform
           the following:
 
           a.  Ensure all databases to be migrated are cataloged.
 
           b.  Stop all applications and do a db2 terminate and
               db2stop.
 
       2.  Login as root and execute the following command:
 
           # /usr/lpp/db2_02_01/instance/db2imigr <instance_to_be_migrated>
 
           This command will migrate the version 1 instance to
           version 2.  Once an instance has been migrated to
           version 2 it is unusable under version 1.
 
       3.  Migrate the database from version 1 to version 2.
 
           a.  Login as the instance owner who was migrated in step
               2.
 
           b.  Ensure that the database manager is started by
               typing db2start.
 
           To migrate your database type the following command:
 
           $ db2 migrate database <database-alias> user <userid> using <passwd>
 
           where:
 
           DATABASE  Specifies the alias of the database to be
                     migrated to the currently installed version of
                     the database manager.
 
           USER      Identifies the user name under which the data-
                     base is to to be migrated.
 
 
                             Instance/Database Migration for DB2/6000  1
 
 
                                                                12/21/95
 
           USING     The password used to authenticate the user
                     name. If the password is omitted, the user is
                     prompted to enter it.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  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.
  below.
 
  have found errors in it, or if you want to express your opinion about
  it (such as organization, subject matter, appearance) or make sug-
 
  If you need technical assistance, contact your local branch office,
  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
 
  When you send comments to IBM, you grant IBM a nonexclusive right to
  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 #: