RE: DB2 Symmetric Multiprocessing

["Graap, Ken" <keg@xxxxxxxxxxxxx>]

Doug ... No matter what, you will have to rewrite your batch processes to
multithread before they will use more than one processor. OS/400 will
automatically utilize multiple CPU's for index rebuilds and query processes
(SQL and Query/400) if the query attributes are set correctly (CHGQRYA,
system value QQRYDEGREE, QAQQINI file settings) and this feature is
installed:

5722SS1    26      OS/400 - DB2 Symmetric Multiprocessing

Kenneth
--
********************************
Kenneth  E.  Graap
IBM Certified Specialist
AS/400 Professional
System Administrator
NW Natural - Information Services
System Services
Phone 503 226 4211 X5537
FAX   603 849 0591
keg@nwnatural.com
********************************


-----Original Message-----
From: Doug Hart [mailto:doughart@twcny.rr.com]
Sent: Wednesday, December 04, 2002 9:36 AM
To: midrange-l@midrange.com
Subject: DB2 Symmetric Multiprocessing


I see on my new system (820) running v5r1 that the LPP DB2 Symmetric
Multiprocessing is still available.  I thought that this functionality was
now included in the OS.  I know that SYSVAL's exist to help Query optimize
over multi-processor systems.  But, I was looking to get better batch run
time on a very long running (single threaded) program/job.

Can anyone confirm if multi-processor systems by default share the
processors better than they did a few releases/models ago.  I want to
greatly optimize a 36 hour job buy upgrading from a 1-way 730 to a 2 or
4-way 820.  Will the program use the additional processors without the
additional LPP?

 ---
Douglas Hart - Sr. Consultant
Certified IBM iSeries System Administrator
mailto:dhart2@twcny.rr.com
Web: http://dhart.no-ip.info

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.