topic Re: Alfresco with IBM DB2 in Alfresco Archive

Alfresco with IBM DB2

cyberheap — Mon, 31 Mar 2008 09:06:21 GMT

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 sta

Re: Alfresco with IBM DB2

jbarmash — Fri, 04 Apr 2008 05:15:44 GMT

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.

Re: Alfresco with IBM DB2

cyberheap — Fri, 04 Apr 2008 09:03:24 GMT

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

Re: Alfresco with IBM DB2

jett — Mon, 09 Sep 2013 17:18:53 GMT

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.