DB2 with JIRA5 - Yes? No? Maybe?

[Peter Nann]

Can anyone say what the likelihood of success will be upgrading our existing instance JIRA 4 to JIRA 5, keeping DB2?

We have an existing instance of JIRA 4.2.4 running with a DB2 database.

I know official DB2 support was dropped after JIRA 3, but clearly it can work on JIRA 4.

I am new to JIRA, and no DB2 expert, so just hoping that someone who knows more will be able to make a stab at where we are on the "Yes-Maybe-No" continuum.

Thanks.

I notice at least this change below to the DB integration mentioned in upgrade notes, that may have an effect on 'DB2 happiness': (Someone who knows more about DB2 may be able to extrapolate from this note about Oracle)

JIRA servers using Oracle databases require additional configuration

Due to Active Objects changes in JIRA 5.0, any customers with a JIRA server connected to an Oracle database will need to ensure that the database user account (through which JIRA connects to Oracle) has the create sequenceand create trigger Oracle database permissions. To apply these permissions, execute the following Oracle SQL commands with the relevant database user account, before upgrading JIRA to version 5.0:

grant create sequence to <user>;

grant create trigger to <user>;

[RianA · Accepted solution]

Hi Peter,

I believe it's not possible to integrate JIRA 5 with DB2 as it doesn't support Active Object. The DB2 support was dropped because of this reason. If you want to upgrade to JIRA 5.0 from JIRA 4.2.4 using DB2, I would like to suggest you to migrate the database server. You can achieve this by exporting full xml backup of JIRA and restore it back to JIRA 5.0 that runs on supported database platform.

Hope this information helps, and if there's anything unclear or needs explanation please ask.

Best regards,
Josua

[Peter Nann]

Thanks, that was exactly the sort of information I was looking to save me struggling further.

That would be a "no" then!

Not a problem. We'll stay of JIRA 4 for a while and look at a DB migration down the track. Maybe when JIRA 5.1 is out...

Thanks again for the quick, specific answer. Keep up the good work Atlassian!