AnsweredAssumed Answered

Problem with act_ru_execution table at export/import db2 database

Question asked by emmanuelb on Feb 5, 2014
Latest reply on Feb 10, 2014 by jbarrez
Hi, we have a problem when export/import db2 database with the column uni_business_key from table act_ru_exectution.
We need to export database, then drop and recreate the database, and then import.

We view that when import, db2 dont execute this part of query:

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) )",

So, when startup our application we have this error:
SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=3, TABLEID=13, COLNO=11

Outcomes