cancel
Showing results for 
Search instead for 
Did you mean: 

bigint datatype with DB2

kulandai
Champ in-the-making
Champ in-the-making
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?

Thanks,
Joseph
1 REPLY 1

frederikherema1
Star Contributor
Star Contributor
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.