Using DB2 Universal Database on 64-bit Platforms

Chapter 3. Instance Creation, Migration, and Update Scenarios


Creating a New 64-bit Instance

You can create a 64-bit instance by invoking the db2icrt command, specifying the parameter -w with a value of 64. For example:

   db2icrt -w 64 -u db2fenc1 db2inst1

For more information about the db2icrt command, refer to the DB2 for UNIX Quick Beginnings book, or the Command Reference.


Updating an Existing 32-bit Instance (Version 7.1) to a 64-bit Instance (Version 7.1)

Because there is no way to undo the word size migration of an instance, back up all local databases before attempting a word size instance update. In addition, back up all local databases after updating the word size of the instance to 64-bit. Forward recoverable databases (those whose LOGRETAIN database configuration parameter is set to ON) are put in backup pending state, and you must back them up once the instance has been updated.

You can change a Version 7.1 32-bit instance to a Version 7.1 64-bit instance by invoking the db2iupdt command, specifying the parameter -w with a value of 64. For example:

   DB2DIR/instance/db2iupdt -w 64 db2inst1

where DB2DIR represents /usr/lpp/db2_07_01 on AIX and /opt/IBMdb2/V7.1 on Solaris and HP-UX. For more information about the db2iupdt command, refer to the DB2 for UNIX Quick Beginnings book, or the Command Reference.

For a list of restrictions that apply when you upgrade a 32-bit instance to a 64-bit instance, see Chapter 6, Restrictions.

You cannot revert to a 32-bit instance once you have migrated to a 64-bit instance. To once again work with 32-bit instances, you must drop your 64-bit instances and databases, recreate 32-bit instances, and restore your most recent 32-bit backup images.


Migrating a Down-level 32-bit Instance to a 64-bit Instance

There is no direct migration path from an existing 32-bit (pre-Version 7.1) instance to a 64-bit instance. You must first migrate your pre-Version 7.1 32-bit instance to Version 7.1, and then update it to a 64-bit instance. For information on migrating your 32-bit instance to Version 7.1, see the Quick Beginnings manual for your operating system.

After installing the FixPak, you will find new directories and files in existing components. For example, there will be a DB2DIR/bin64 directory that contains all of the 64-bit binaries. (DB2DIR represents /usr/lpp/db2_07_01 on AIX and /opt/IBMdb2/V7.1 on Solaris and HP-UX.) You can create a 64-bit instance by invoking the db2icrt command, specifying the parameter -w with a value of 64, or change a 32-bit instance to a 64-bit instance by invoking the db2iupdt command, also specifying the parameter -w with a value of 64. For more information about the db2icrt command or the db2iupdt command, refer to the DB2 for UNIX Quick Beginnings book or the Command Reference.


[ Top of Page | Previous Page | Next Page ]