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



I have QPFRADJ set to 3. 3=Automatic adjustment
I know that this can be a bad thing for the Query optimizer because it has
to recalculate when memory sizes change. But let's skip that for now.

Migrated this lpar over the weekend from a P9 to a P10. Traditional ERP
workload. This is Wednesday so it's had a few days of load.

WRKSHRPOOL
Main storage size (M) . : 246496.00
Defined Max Allocated Pool -Paging Option--
Pool Size (M) Active Size (M) ID Defined Current
*MACHINE 18652.54 +++++ 18652.54 1 *FIXED *FIXED
*BASE 68586.54 2235 68586.54 2 *CALC *CALC
*INTERACT 39742.46 5216 39742.46 3 *CALC *CALC
*SPOOL 2464.95 51 2464.95 4 *FIXED *FIXED
*SHRPOOL1 117049.48 558 117049.48 5 *CALC *CALC

DSPSYSSTS
% CPU used . . . . . . . : 6.0 Auxiliary storage:

Elapsed time . . . . . . : 00:18:15 System ASP . . . . . . :
11453 G
Jobs in system . . . . . : 24218 % system ASP used . . :
61.1101
% perm addresses . . . . : .009 Total . . . . . . . . :
11453 G
% temp addresses . . . . : .045 Current temporary used :
118912 M
Peak temporary used . :
174245 M

System Pool Reserved Max -------DB------- -----Non-DB-----
Pool Size (M) Size (M) Active Faults Pages Faults Pages
1 18652.8 9704.7 +++++ .0 .0 .1 .1
2 59159.0 18.4 2235 1.8 26.4 6.3 33.9
3 76551.3 .6 5216 9.2 1056.9 8.6 19.3
4 2464.9 .7 51 .0 .0 .1 .3
5 89667.8 .0 558 51.6 7188.3 8.1 15.9
Active-> Wait-> Active->
Wait Inel Inel
1138.4 .0 .0
35882.4 .0 .0
347.9 .0 .0
159.0 .0 .0
15639.1 .0 .0
Pool
*MACHINE
*BASE
*INTERACT
*SPOOL
*SHRPOOL1
Paging
Option
*FIXED
*CALC
*CALC
*FIXED
*CALC

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.