I just happen to be mucking around with this recently as well...I wasn't aware you could use 64-bit on DB2 5.2, and I'd recommend you upgrade to version 7 or 8 if you plan on using the "newer" facilities.
You can have 32 and 64 bit instances on the same machine. Install the 64 bit version of the db2 software. The default is to create a 32 bit instance unless you specify -w 64 (db2setup will NOT create a 64 bit instance). Create an instance using -w 64. Create another without the -w 64. I'm not aware of there being a Windows 64 bit version...yet Here are a few restrictions with 64-bit stuff. Note the last 2 statements. You cannot restore a 32-bit database image into a 64-bit instance, or a 64-bit database image into a 32-bit instance. Following are restrictions that pertain to upgrading a 32-bit instance to a 64-bit instance: Remote databases (TYPE != SQL_INDIRECT) that are cataloged at this instance are skipped. These databases will not have their local database directories migrated. Since 32-bit/64-bit client/server communication is not supported in this release, these databases, although cataloged, will not be connectable from the instance after the instance has been upgraded. The db2iupdt utility returns a warning message (SQL1706W) if any such databases exist. Upgrading a 32-bit instance that has local databases (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 upgrade must be cataloged before the instance is upgraded. 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 restrictions: 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 </cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2v7q9db2q906.htm>. 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 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 tim --- Farah Shire <[EMAIL PROTECTED]> wrote: > > > > > Guys; > I have in compatibility issue... I have win2000 DB2 > 7.2 Fixpak 8 32bit, and > I'm trying to connect to AIX 5.2 fixpak 8 64 bit and > I'm getting this > error. > A CONNECT or ATTACH statement failed > because of a > client/server incompatibility between 32 > bit and 64 bit > platforms. > So, my question is, can you have 64bit and 32 bit on > a same > machine(aix5.2). There's no 64 bit for Windows2000? > And, if you can (64 and 32 bit on same machine), how > would you do it? > > > Farah Shire > Database Administration - IBM Global Services > [EMAIL PROTECTED] > (704) 594-8241 or T/L 794-8241 > Pager 1-800-759-8352 PIN 1875048# > > (NONE OF US IS GOOD AS ALL OF US!!!) > > - > ::: When replying to the list, please use > 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to > [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
