DB2 z/OS support

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

pero

This kind of query is not supported by DB2 version 9.1 for z/OS database:

create table ACT_RU_EXECUTION (
    ID_ varchar(64) not null,
    REV_ integer,
    PROC_INST_ID_ varchar(64),
    BUSINESS_KEY_ varchar(255),
    PARENT_ID_ varchar(64),
    PROC_DEF_ID_ varchar(64),
    SUPER_EXEC_ varchar(64),
    ACT_ID_ varchar(255),
    IS_ACTIVE_ smallint check(IS_ACTIVE_ in (1,0)),
    IS_CONCURRENT_ smallint check(IS_CONCURRENT_ in (1,0)),
    IS_SCOPE_ smallint check(IS_SCOPE_ in (1,0)),
   UNI_BUSINESS_KEY varchar (255)  not null  generated always as (case when "BUSINESS_KEY_" is null then "ID_" else "BUSINESS_KEY_" end),
   UNI_PROC_DEF_ID varchar (64)  not null  generated always as (case when "PROC_DEF_ID_" is null then "ID_" else "PROC_DEF_ID_" end),
    primary key (ID_)
);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The problem is that "case" expression is not supported under "generated always as" for this DB2 version.
I see that ACT_RU_EXECUTION table for other databases(postgres) doesn't contain UNI_BUSINESS_KEY and UNI_PROC_DEF_ID columns at all.
What if we don't define those columns on our db2? Will activiti still work?

Is there some other solution to this problem possibly?

Thanks.

jbarrez

Yes - Activiti will still work.

The only 'problem' which you will have, is that there will be no check on the uniqueness of the process instance business key - which means you will have to force that uniqueness in the logic of your app.