Jim,
I have DB2 Symmetric Multiprocessing (SMP) on our Production LPAR, 1.5 core, but can never test on our R&D LPAR 1.0 core.
I have noticed some processes will multi thread on Production, but single thread on R&D.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Thursday, April 16, 2015 9:32 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 Symmetric Multiprocessing (SMP)
That product is always delivered on a DVD by itself and then only to those that order it. I do not believe it is keyed; however, it does "phone home"
to IBM occasionally and report its usage.
Remember that to have any real effect there has to be more than one core assigned to the partition in question.
As to monitoring Steve already showed you how PDI can help you see what's going on. Remember my missive about keeping at least 14 days' worth of performance collections? Now you know another reason. If you make this big change to your system you'd like to go to the boss and say "by the way, the investment we made in DB/2 Symmetric Multiprocessing has done this" Since you know have the before picture, you can look at the after picture as well and show the improvement.
Another thing to think about I don't think Steve pointed out. All your queries are going to re-optimize since the world according to SQL just
changed somewhat radically. Keep a watch on the index advisor. You may
want to kill some of the indexes and build new ones once this is running.
Memory is also going to be affected some, so watch paging/faulting. You might want to add some memory to that partition to unleash the power you just gave it.
--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, April 16, 2015 8:06 AM
To: midrange-l@xxxxxxxxxxxx
Subject: DB2 Symmetric Multiprocessing (SMP)
I was reading the article "Getting More Value out of Your POWER8 Cores" at
http://www.mcpressonline.com/performance-monitoring-&-tuning/in-the-wheelhou
se-getting-more-value-out-of-your-power8-cores.html
and I'm thinking "Hey, I'm running all Power 8's. My production rack is all SSD's and has an entitlement at ESS for it. Couldn't find a key at ESS but my BP said that it doesn't use a key.
Before I load it up and fire it off any suggested before/after performance monitoring?
DB2 Symmetric Multiprocessing (SMP)
http://www-03.ibm.com/systems/power/software/i/db2/products/smp.html
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
