Joni Moyer wrote >>I was just wondering how my bufpoolsize> region size? My region size is >>512MB and my bufpoolsize is 270336KB which equals out to 264MB. Is that an >>incorrect statement? I'm still trying to find the command to increase my >>maxquickfree bytes. Does anyone know this command? As you can see, I'm in >>need of increasing it... Thanks!
>>MAX initial storage 536870912 (512.0 MB) >> Freeheld bytes 13592207 (13.0 MB) >> MaxQuickFree bytes 10737418 (10.2 MB) >> 0 Page buffers of 13107 : 84 buffers of 1638. >> 12 Large buffers of 819 : 69 XLarge buffers of 102. >> 2375 buffers free: 71682 hiAlloc buffers: 51214 current buffers. >> 33689 units of 264 bytes hiAlloc: 33685 units of 264 bytes hiCur. Sorry Joni I am used to thinking of buffer pool in 4 kb pages, so I stupidly took your query opt value x 4 By the way according to your opt the value is 134 mb not 268 mb. Anyway having said that your bufferpool size is large compared to your region size. OS390 is arguably not the best place for your size of database, as unless you have a dedicated lpar you are likely to be sharing memory and cpu with competing applications as I have to, so your performance will never match what you can get out of a dedicated unix box. You or your performance person need to look at RMF or similar tool to see how much real memory your TSM address space is using and whether it is having to page frequently. As Bill Kelly said earlier increasing your region size will increase MaxQuickFree bytes. At 768mb as mine is you get 15mb of MaxQuickFree bytes However the undocumented and hemce unsupported show memu command certainly does work under z/OS so it ought to work under os390. If you can't get it to work from the os390 command line, try it from the admin web browser. The command to double your MaxQuickFree bytes is :- show memu set maxquick 21474836 Can't remember whether it is case sensitive or not, so if it doesn't work lower case try upper. cheers, John ********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy Group. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Unless specifically stated otherwise, this email (or any attachments to it) is not an offer capable of acceptance or acceptance of an offer and it does not form part of a binding contractual agreement. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **********************************************************************
