We are using DB2 database and considering using Activiti for workflow. We noticed that in Activiti setup database tables, some fields are having bigint as datatype. We are using older version of DB2 as of now and there is no support for bigint.
Can I change this datatype to integer and will it affect?
Depends on the size of "integer" in the old DB2, compared with the new versions… Most of the time, these columns are used for revision-information on the entities, so these won't grow that high, although this should be checked on a per-column basis.