There are many ways to use more than 4 GB with 32-bit DB2. These include DB2 EEE, extended memory, or devoting
the memory to file system caching. If you want to read an article on this, monitor
http://www7b.boulder.ibm.com/dmdd/ or send me an e-mail (the article should be published soon).
DRDA can be used against any DB2, including AIX. This allows you to have a 32-bit client connect to a 64-bit
server. (You don't need a 64-bit DRDA client, although that's available too.) DRDA is normally not chosen for
DB2 to DB2 on Unix/Windows, but it does work. We don't test it as thoroughly as the DB2RA protocol used for
workstation to workstation.
ODBC is often used over DRDA. You are right that DRDA in v7/6 is not always as fast as DB2RA. You can do bulk
read and bulk insert in DRDA using Compound SQL.
Don't underestimate file system caching: Solaris and AIX are both very good at this.
> Hi Blair and other DB2 'guritachi',
> Thanks for responding, all. BTW, I do not need 64-bits because I need
> 64-bit numbers (just use long long on any 32-bits platform, I would
> say), rather because our data mining application is in fact a main
> memory database system. We would love to use more than 4GB RAM, and
> ease the problems we encounter sometimes with virtual memory
> management when multiple very large files are mapped into virtual
> memory. And, we do not need Intel engineers by the truckload either,
> as our code is already 64-bit ready after succesful ports to 64-bits
> Solaris and 64-bits IRIX.
> Back to the question of connecting to 32-bits DB2 UDB (on e.g. AIX)
> from within a 64-bits AIX application.
> If that is possible with DRDA/DB2 connect that would be great news!
> I have some detailed questions about DB2 connect/DRDA:
> - are DRDA client libraries indeed available for 64-bits AIX?
> - can you connect with DRDA to DB2 UDB? I had understood that DRDA
> is used for connecting to AS/400 or mainframes only?
> - which versions of 32-bits DB2 UDB can you connect to (6.X/7.X)?
> - we now use the (ODBC like) DB2 API. Can we continue to use this same
> API with DRDA, or should we use another API?
> - is there a performance impact of going through DRDA to DB2 rather
> than directly?
> as an illustration for the latter issue, our application basically
> sequentially reads and writes entire tables from and to DB2. Typically,
> on NT (windoze) when using ODBC, we need an ODBC driver that implements
> 'bulk insert' and 'bulk read' to reach acceptable performance.
> many thanks, again.
> Peter Boncz
> > Nothing is new for 64-bit in 7.2 except:
> > 1. you get 64-bit without a fixpak
> > 2. we have Windows AWE support for large memory bufferpools in the 32-bit world.
> > Until Version 8, your scenario will require DRDA (DB2 Connect) or a three tier app like SAP, where a DB2
> > client with the same bitness as the database engine mediates between the database and the application on the
> > 3rd tier.
> > > Dear DB2 Guri,
> > > In the original DB2 7.1 release on 64-bits platforms, a number of restrictions
> > > were imposed regarding connectivity. In particular, it was impossible to connect
> > > with a 64-bits client to a 32-bits DB2 server, and vice versa.
> > > see: www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d...
> > > I have good reasons to port my application to 64-bit on AIX, but I want to keep
> > > connecting to existing DB2 data sources that are 32-bits. This has held me back
> > > from doing the port for the time being.
> > > Now 7.2 is out, and the 'what's new booklet' mentions again the fact that 64-bits
> > > applications on AIX, Solaris and HP-UX can use DB2. But, what's new here exactly?
> > > see: www.ibm.com/software/data/db2/udb/pdfs/db2v72whatsnew.pdf
> > > now, my *question*:
> > > does anyone know whether connecting from a 64-bits application to 32-bits DB2 will work?
> > > I fear it still won't. Still, this is rather important to me. If it would work, I
> > > suppose you would need to link your application with the 7.2 client libraries
> > > (64-bits version), but is it necessary that the 32-bits DB2 is version 7.2 or would
> > > this even work with older DB2 server versions (in other words, do I need to somehow
> > > convince all my data sources to upgrade to 7.2)?
> > > many thanks,
> > > Peter Boncz
> > > software architect
> > > Data Distilleries BV
> > > www.datadistilleries.com