I am trying to add an index to a document class' field, but - after some minutes - I receive the error TransactionRolledBackException.
I suspect that's because this class already has thousands of created objects. In fact, whenever I try to create a index for a new class, I do not receive this error. I also suspected that it was just a timeout for FEM, while the index creation proceeds in the background, but this is not true, because I tried this creation 4 days ago, with no results. Closing and reopening the FEM, the parameter always shows the missing index:
Is there some parameter to set in order to avoid the timeout, or is it possible to create an index directly on the DB2?