Alfresco with IBM DB2

[cyberheap]

Hello!

We will be launching Alfresco on a client's system which "unfortunately" is IBM based, so DB2…

I'am currently researching the issues with the configuration, and I would like to get the general idea,
on how much it is acctualy worth to go with the DB2 configuration just to meet an environment standard
(probably more of a commercial requirement anyways), or would it be better to advise the client about the issues,
and try to convince him to go with a Alfresco officialy supported DB?

I've been browsing thru the forums on the DB2 topic and the "instructions" on the Alfresco Wiki,
and it seems there have been both problems and successes.

I would like to get any recent firsthand info on successful/unsuccessful Alfresco configurations with DB2,
if the configuration was successful, what issues had to be addressed (in addition to the ones mentioneted on the forums), etc. ?

Has anyone found the instructions on the Alfresco Wiki helpful and what other issues had to be addressed?

Any info would be helpful!

Thank you all!

Sincerly,
Primoz

[jbarmash]

Here are the supported version that were tested for Alfresco Enterprise. 
http://www.alfresco.com/services/support/stacks/2.1/

It would be MUCH better to go with Alfresco officially supported DB. 

We rely on hibernate for DB access layer, and even though it's making a lot of the translations to account for different databases, there could be a LOT of hidden issues that will get uncovered if you run on unsupported DB.  For example, I just spend a few days moving a customer of an old version of Sybase to MySQL, because they were having performance issues. 

It's not so much about configuration - I am sure that's possible to do (although haven't done it myself).  Even if you get that to work in the short term, It's what kind of issues you'll run into  a month or two from now when the system comes under load.

[cyberheap]

Thank you for you answer jbarmash.

I'am fully aware of the issues you are mentioning and we will (strongly) recommend to go with a supported stack.

I was mostly trying to get any first hand info on successfull DB2 configurations and experiences on how the configuration behaves under load.
So if anyone is currently using DB2 with Alfresco, any info would be greatly appreciated.

Thank you,
Primoz

[jett]

It's been 5 years but just in case you still want to use Community with DB2, I created an AMP file that would allow this: https://github.com/jett/db2-alfresco

My initial test shows that it is working. Still need ot thoroughly test it though in case any quirks come out.