Using DB2 Universal Database on 64-bit Platforms
The following restrictions pertain to updating a 32-bit instance to a
64-bit instance:
- Remote databases (TYPE != SQL_INDIRECT) that are cataloged at the
32-bit instance are skipped. The local database directories for these
databases will not be migrated. Since communication between 32-bit and
64-bit clients and servers is not supported in this release, the 32-bit
databases, although cataloged, will not be connectable from the instance after
the instance has been updated. The db2iupdt utility returns
a warning message (SQL1706W) if any such databases exist.
- Upgrading a 32-bit instance that has local databases (with TYPE ==
SQL_INDIRECT) with one or more spatial indexes defined is not supported
(SQL1706N, word size migration failed). You must drop spatial indexes
from 32-bit instances, and then recreate them in 64-bit instances.
- All databases local to the instance that you intend to update
must be cataloged before the instance is updated.
- Existing user-defined functions (UDFs) and stored procedures must be
rebuilt in 64-bit instances.
- Existing SQL procedures must be dropped and recreated in 64-bit
instances.
Additional 64-bit restrictions:
- A 32-bit database image cannot be restored into a 64-bit
instance.
- A 64-bit database image cannot be restored into a 32-bit
instance.
- The db2setup command cannot be used to create 64-bit
instances. This command can, however, be used to create 32-bit
instances, which can be manually migrated to 64-bit instances. For
information about creating 64-bit instances, or migrating 32-bit instances,
see Chapter 3, Instance Creation, Migration, and Update Scenarios.
- In a DB2 UDB Enterprise - Extended Edition (EEE) environment, all nodes
must be 64-bit nodes (not a mix of 32-bit and 64-bit nodes).
- The snmp_agent is currently not supported on 64-bit
installations.
The following elements are not supported in this release:
- JDBC
- Control Center
- Query Patroller
- DCE
- Replication
- DB2 Extenders
- Data Links Manager
- Java stored procedures
- Java user-defined functions
- SQLJ
- Federated databases
Unsupported programming languages are:
- Perl
- COBOL
- REXX
- FORTRAN (Solaris)
Unsupported communication protocols are:
- SNA
- Syncpoint Manager
- IPX
Unsupported connections are:
- A 64-bit client to a 32-bit server
- A 32-bit client to a 64-bit server
[ Top of Page | Previous Page | Next Page ]