RE: DB2 Symmetric Multiprocessing (SMP) -- MIDRANGE-L

Paul,

Not knowing the configuration you have, If you can find your way clear to
add that .5 processor to the production partition then I think you'll see
some real differences, having given SMP the resources it needs, (in concert
with the other items I've cited). With 1.5 processors it really is not
doing that much for you.

On a single core partition it has no ability to affect processing so you are
correct, no joy there.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Steinmetz, Paul
Sent: Thursday, April 16, 2015 9:47 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 Symmetric Multiprocessing (SMP)

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.

--
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.