Running Activiti on DB2 for System i

[sebastian_s]

Hello folks,

while searching the forums today for information on running Activiti on DB2 for System i I found the following post stating that it can be used and it is even QA'ed: http://forums.activiti.org/comment/11941#comment-11941

However I am not able to run all of the SQL scripts to create the engine's database structures on DB2 for System i since there are problems with the "generated as" clauses. I looked up the syntax in the SQL reference manual for DB2 and found that syntax used with the "generated as" clauses is indeed not supported. The same problem is described here (although this is an issue relative to DB2 on z/OS):

http://jira.codehaus.org/browse/ACT-817

So what is the state of the DB2 for System i support of Activiti?

Best regards
Sebastian

[jbarrez]

We run QA on DB2, but on a red hat linux system.

Is DB2 on System I so different from other DB2 installs?

[sebastian_s]

Hello Joram,

especially regarding to the SQL being used it is not really different at all. However there are some restrictions/differences when it comes to the check constraints - as described above. We are already using Activiti on DB2 LUW - we are running on Linux as well but we also need support for DB2 for System i.

We are interested in contributing support for DB2 on System i.

Regards
Sebastian

[trademak]

Hi Sebastian,

We are always interested in contributions like this, but the issue is that we won't be able to run QA on System i. So it will be hard to maintain that contribution. Would you be able to do QA on System i with a continuous build system that we can access?

Best regards,

[sebastian_s]

Hi Tijs,

I am taking this into discussion here. You'll receive a private message from me.

Best regards
Sebastian