RE: DB2 Symmetric Multiprocessing (SMP)

Jim,

Most of our apps is 3rd party, all old code, very little SQL.

One process, old PMR, I remember that had an issue.

Cpyfrmimpf submits multiple jobs if DB2 Symmetric Multiprocessing is enabled.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Thursday, April 16, 2015 12:00 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 Symmetric Multiprocessing (SMP)

Well if your applications do not utilize SQL much then SMP is not going to help much.

A good reason to suggest more SQL usage, but then again there is that whole political/inertia thing too.


--
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 10:43 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 Symmetric Multiprocessing (SMP)

Jim,

Could not justify the i5/OS licenses.
Last I checked it was 44,000 for each i5/OS license per core.
I have an 8 core, all active, only 3 lic for i5/OS. Other 5 are active doing nothing.

Also, when I reviewed my MPG perf stats, (graphs, current day, CPU, cores
used) history shows that the 2nd .5 on Produciton LPAR is hardly used.
I researched this, and it was correct.
Depending on the apps that are being run, the additional cores would not be used.
Majority of our work is RPG and RPGLE.
Very little SQL.

From what I've been told, and the MPG stats support it, we will hardly ever use anything beyond the 1st core.

Paul

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

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.


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