Rigido
ADSM.ORG Senior Member
Hi Protectors
few weeks ago I opened a pmr, then a second and, finally, a third one for performance problems on two servers.
So, why am I writing on the "Capacity Planning" section?
Both server were updated to 8.1.11 and DB & LOG (256GB) increased as we started to use DCs and abandoned VTL, storage is HDS enterprise class all flash.
First server started to have issues with expire inventory and blocked sessions, second server started to have issues with "db backup", long lasting sessions and both servers had "ACTIVE LOG FULL" condition/crash (especially one).
After days of analysis, data collection, servermon files, crash and "crash recovery", support made us set DB2_USE_ALTERNATE_PAGE_CLEANING to ON, then increase ACTIVE LOG size to 512GB (on a 600GB filesystem) and, now, to increase active log filesystem size to 2TB!
We think problems begun as servers started to delete extents and, as we are talking of one hundred SAP HANA TDP daily full/differential backups (db sizes vary from few GBs to 9TB) I think there will be millions of extents to delete every day.
So, questions are:
few weeks ago I opened a pmr, then a second and, finally, a third one for performance problems on two servers.
So, why am I writing on the "Capacity Planning" section?
Both server were updated to 8.1.11 and DB & LOG (256GB) increased as we started to use DCs and abandoned VTL, storage is HDS enterprise class all flash.
First server started to have issues with expire inventory and blocked sessions, second server started to have issues with "db backup", long lasting sessions and both servers had "ACTIVE LOG FULL" condition/crash (especially one).
After days of analysis, data collection, servermon files, crash and "crash recovery", support made us set DB2_USE_ALTERNATE_PAGE_CLEANING to ON, then increase ACTIVE LOG size to 512GB (on a 600GB filesystem) and, now, to increase active log filesystem size to 2TB!
We think problems begun as servers started to delete extents and, as we are talking of one hundred SAP HANA TDP daily full/differential backups (db sizes vary from few GBs to 9TB) I think there will be millions of extents to delete every day.
So, questions are:
- Will DB2 really use free 1,5TB on the active log filesystem?
- Is it possible we reached a "design" limit and we should starting to think to split workload?
- What is your biggest installation?