• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Real life "large" server

Rigido

ADSM.ORG Senior Member
Joined
Apr 21, 2006
Messages
150
Reaction score
7
Points
0
Location
Rome, Italy
Hi Protectors :cool:
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? o_O
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:
  1. Will DB2 really use free 1,5TB on the active log filesystem?
  2. Is it possible we reached a "design" limit and we should starting to think to split workload?
  3. What is your biggest installation?
Thanks.
 

dietmar

ADSM.ORG Member
Joined
Mar 12, 2019
Messages
20
Reaction score
2
Points
0
Hi,

I could only tell that i help manage a Environment where the Database is 4,5+TB, and the Active Log have to be in an dedicated Filesystem . The Daily Rate change is between 30-40 TB . So i don't know how much u do on your environment, but this is a Windows Server. I guess with a big AIX it should be even faster .

I have been working on a customer which had a HDS 990 full Flash SAN Environment over 2 DC for their VMWARE Infrastructure. During restore i have seen bad Performance (70-80MB/s for each vmdk , Backup (read) was 300-400MB/s ) . Currently we found out that we have 3ms Write delay during hotadd if the Restore is on a Mirrored Data Store . So we tested a local NOT mirrored Data Store and we had 1ms and 140MB/s for each vmdk restore . Customer also set ALUA now but it did not help for now . I am saying this because i prefere local NVMe or dedicated local small Flash Arrays for the DB2 . Any spinning device for the Database is NO option.

good luck , Dietmar
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

DigitalOcean $100 Credit

Support ADSM.ORG and get DigitalOcean FREE credit. DigitalOcean currently offer a $100, 60-day Free Credit for new accounts. Sign-up here:

DigitalOcean Referral Badge

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 20 18.7%
  • Keep using TSM for Spectrum Protect.

    Votes: 65 60.7%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.1%
  • Other (please comement)

    Votes: 9 8.4%

Forum statistics

Threads
31,871
Messages
135,906
Members
21,786
Latest member
london
Top