AnsweredAssumed Answered

Upgrade from 3.3.1 to 4.2.2: Lots of Documents

Question asked by docderivative on Apr 21, 2015
Latest reply on Apr 22, 2015 by docderivative
Hi

We have a large (we feel it's large) 3.3.1 Alfresco installation holding approx. 50 million documents.  This installation runs on a single Linux machine and uses DB2 for its database.

I am not sure how to proceed with the upgrade…

Looking at the differences between 3.3.1 and 4.2.2 it seems that there are a number of steps that re-create the big ALF Tables

TABLE_NAME                 ROWCOUNT
ALF_NODE_ASPECTS              320 Million
ALF_NODE_PROPERTIES           250 Million
ALF_NODE                      60 Million
ALF_CHILD_ASSOC               50 Million

I don't think our current installation has big enough DB2 transaction log space to actually execute the DB2 upgrade scripts.

Any hints?  Do other people have similar size installations?

How did they upgrade?  How long did it take?  Do we need to create a new prod installation and then transfer deltas after the progress has completed?

Thanks in advance
DrD

Outcomes