RRDI with 64 BIT Database on same server?
I am seeing slightly contradictory information about this and am looking for advice: I have 64 BIT versions of Websphere, DB2 and the JTS applications running on a 64 BIT Windows server. I have now installed the 64 BIT version of RRDI on the same server but am having difficulties creating its database. There are warnings in the documentation that the database connection needs to be 32-BIT, but I have also seen suggestion that this is only if the database is on a remote server, by implication that it can be 64 BIT if it is on the same server. Anyone know which is correct?
If I have to downgrade my DB2 to 32 BIT, any advice on doing this - I don't have any real data in the system yet, but would rather not have to start again from scratch if it can be avoided - the installation up to this point has not been easy!
Ali
Accepted answer
as far as I know the default DB2 Server installation should include both the 32 and 64 bit client libraries; so since the DB2 server is on the same system as RRDI you probably don't need to install a separate DB2 client.
Best Regards
Francesco
Comments
I will support what Francesco mentioned. Not too long back I tried a similar setup and I didn't have to worry about the 32bit client or drivers. The only concerning thing for this kind of deployments where everything is on a single server are the system resources. You may want to make sure you have enough memory in the box.
Regarding resources - yes, I will keep an eye on that. At the moment (without RRDI) under test it is paging memory occasionally but not constantly and not excessively. It is on a flexible server system so I can upgrade the resources and move parts to other servers if we need to. We are expecting a very small number of specialist users though so I don't want the complication and overhead of multiple servers if I don't really need it.
Ali
2 other answers
Let me add a few more details to answer your question. The first thing that I wanted to point out is regarding topology. The topology you describe sounds like a single server topology which is useful for trial or evaluation deployments. See http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.rrdi.admin.doc/topics/c_topology_rrdi_single_server.html
For production, you want to look into the following two choices: standard departmental topology or enterprise department topology. In both of these choices, DB2 is on its own database server and RRDI is on its own application server apart from the JTS and other CLM applications.
The next thing I want to point out is the topic where this database client connection is discussed: Installing in a 64-bit or 32-bit mode on a 64-bit OS. Also important is the database planning topic. According to these topics,on Windows, a 32-bit database client must be installed regardless of whether the report server and the database are local or remote. You do not need to downgrade db2 to 32-bit.
Comments
Alastair Beadle
Jul 31 '13, 3:13 a.m.Thanks all for the info. So I don't need to change the DB2 installation, may need to change the drivers to 32BIT but they may actually already be present.
I have a PMR in about my database creation problems, which perhaps are not related to the 32BIT/64BIT issue after all. So I will leave my 64BIT database alone for the moment and see what advice I get from the PMR (they are aware of this forum topic as well). I will post back here when I know more.
Thanks Again.
Ali.