| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 | alter table ACT_RU_TASK     add CATEGORY_ varchar(255);Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');        drop index ACT_UNIQ_RU_BUS_KEY;-- DB2 *cannot* drop columns. Yes, this is 2013.-- This means that for DB2 the columns will remain as they are (they won't be used)-- alter table ACT_RU_EXECUTION drop colum UNI_BUSINESS_KEY;-- alter table ACT_RU_EXECUTION drop colum UNI_PROC_DEF_ID;Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');alter table ACT_RE_DEPLOYMENT     add TENANT_ID_ varchar(255) default '';    Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_DEPLOYMENT');alter table ACT_RE_PROCDEF     add TENANT_ID_ varchar(255) not null default '';    Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');alter table ACT_RU_EXECUTION    add TENANT_ID_ varchar(255) default '';    Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');  alter table ACT_RU_TASK    add TENANT_ID_ varchar(255) default '';    Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');   alter table ACT_RU_JOB    add TENANT_ID_ varchar(255) default '';    Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_JOB');  alter table ACT_RE_MODEL    add TENANT_ID_ varchar(255) default '';    Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_MODEL');  alter table ACT_RU_EVENT_SUBSCR   add TENANT_ID_ varchar(255) default '';     alter table ACT_RU_EVENT_SUBSCR   add PROC_DEF_ID_ varchar(64);         Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EVENT_SUBSCR');     alter table ACT_RE_PROCDEF    drop unique ACT_UNIQ_PROCDEF;    alter table ACT_RE_PROCDEF    add constraint ACT_UNIQ_PROCDEF    unique (KEY_,VERSION_, TENANT_ID_);      Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');update ACT_GE_PROPERTY set VALUE_ = '5.15' where NAME_ = 'schema.version';
 |