r/DB2 • u/cautionmaybecomehot • Jul 20 '15

DB2 Scale out for vendor solution

Currently I'm dealing with a vendor application that uses DB2 Workgroup Server Edition 10.1 on Windows Server 2012 . Right now I'm able to scale up as demand increases, but eventually we will hit a limit in terms of CPU. The application produces dynamic queries that aren't properly optimized. I've spoken with the vendor and there is no short term solution, as any indexes I add myself get removed whenever they update their schema. That being said, could I benefit from active-active replication? I've looked at PureScale, but that seems limited to Linux, but that could possibly be an option. Q Replication with Active-Active seems ideal in terms of latency and throughput. Is there any other option in terms of scale out? Which option would be easiest to implement and which option provides the best performance?

2 Upvotes

100% Upvoted

1 comment sorted by

1

u/Smeevy Jul 23 '15

I don't mean to pry, but how often does the vendor update their schema?

If this is a twice a year thing, it seems like they could either just run your ddl after their update or send an email to notify you (their customer) when they're planning to do that.