× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



When you configure an LPAR you set 2 values, Total processing units and
Virtual processors, as far as i understood it if you set 2 virtual
processors with 1.0 proc units you presented 2 cores with 0.5 power each to
the OS which enabled you to use multithread albeit at a lower single
threaded performance. In that case, couldn't you just test SMP modifying
the amount of processors?

On Thu, Apr 16, 2015 at 1:07 PM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
wrote:

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.

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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.