I was reading this "course"
http://public.dhe.ibm.com/partnerworld/pub/pdf/courses/4aea.pdf
Whatever parallelism that is available without installing IBM DB2 SMP doesn't sound like it will help as it may already be happening. We're going to try it without the licensed program and see what we get, it can't really hurt, so we may as well try. Our software vendor has been adding more embedded SQL and newer middleware component that uses SQL so it's possible that adding DB@ SMP could help, but from the questions and responses I'm getting on my support tickets, they don't appear to have ever tried it in house, even at their hosted solution site.
Coy Krill
Core Processing Administrator/Analyst
Washington Trust Bank
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Thursday, July 09, 2015 12:48
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Anyone Have QQRYDEGREE Turned On Without Having DB2 SMP Installed?
Importance: Low
On 09-Jul-2015 13:05 -0600, Krill, Coy wrote:
<<SNIP>> Further reading outside of the regular OS documentation shows
that without the DB2 SMP licensed program, there will be no benefit.
Source?
I'm checking to see if there is any chance we are entitled and just
don't know it. I'm hoping so, but I'm doubting it and will probably
have to get pricing. Might see if I can get it installed and test
under the 70 day grace period and see if it may be worth the asking
price.
As I had noted, and the doc links should confirm [if not explicitly,
then by allusion], that the IO parallelism is supported without SMP
being installed. For example, note the only mention of SMP in the
following text documenting the special-value option *OPTIMIZE specified
for the Query Degree:
"The query optimizer can choose to use any number of tasks for either
I/O or SMP parallel processing to process the query. SMP parallel
processing can be used only if the DB2(r) Symmetric Multiprocessing
feature is installed. ..."
midrange.com
