It's all about the answers!

Ask a question

Change in Database size after CLM version upgrade 4.0.7 to

Narasimha Reddy (112) | asked Apr 14 '20, 11:01 a.m.
edited Apr 14 '20, 1:05 p.m.


Recently I moved CLM applications to new server and upgraded CLM version from 4.0.7 to 5.0.2 and then
In parallel I updated DB2 version from 9.7 to 10.5 and then to 11.1 

    FYI, I used upgrade scripts in CLM Migration.

After migration, I'm comparing database size of CCM, QM, DW,JTS

After migration I see increase in database sizes for CCM,JTS,QM and decrease in database size of DW database. 

Is there any reason for this behavior ?  

Thank you. 


Dinesh Kumar B commented Apr 15 '20, 2:25 a.m. | edited Apr 15 '20, 2:26 a.m.
how much increase do you see., can you share some numbers.,

also, after the upgrade, did you run any db maintenance operations., operations like db reorg and dbstats may help reclaim any temp/fragmented spaces that are making the db size show larger than actually in use...

Narasimha Reddy commented Apr 15 '20, 12:31 p.m.

   Hi Dinesh,

No I didn't ran any db commands. 
Below find DB sizes

JTS DB --> 0.88 GB (CLM V 4.0.7)  ; 1.07 GB (CLM
CCM DB --> 2.51 GB (CLM V 4.0.7)  ; 3.17 GB (CLM
QM DB --> 3.25 GB (CLM V 4.0.7)  ; 3.6 GB (CLM
DW DB --> 14.35 GB (CLM V 4.0.7)  ; 13.88 GB (CLM

Thank you for your inputs. 


Dinesh Kumar B commented Apr 16 '20, 8:44 a.m.

ok., DW is decreased and the other apps increased marginally, which may just be due to schema changes and also since you haven't run db maintenance activities, this may just be fragmentation and temporary stuff...

One answer

permanent link
Piotr Aniola (3.7k11738) | answered Apr 16 '20, 8:04 a.m.

 This isn't a considerable change.

Every one of hundreds of workitems that were delievered between 407 and 6061 can potentially change the DB structure or data, resulting in a slight DB size change. These are implementation details of the system and not a cause for concern.

Narasimha Reddy commented Apr 16 '20, 8:48 a.m.

 Hi Piotr, 

Thank you for your response. 
JTS, CCM, QM DBs size increased after migration to --> not much concern 
 but DW (data warehouse) DB size decreased after migration to 

I'm concern on DB size change for DW (data warehouse).
are there any specific reason for DW size change ?  


Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.