From a space usage perspective the CI sizes looks fine. The formula for Index size (IIRC) is (5 + Index) / 2 * #of CIs per CA.
(5 + 9) / 2 * 45 =3D 315 2K should guarantee that you are not losing DATA CIs due to insuuficient Index CI size. What is the # of Index levels for this file? If it is 3 or more, you might want to recommend increasing the Index to 4k. That will reduce your # of Index levels, which will eliminate I/O improving your performance. You might want to increase the BUFFERSPACE(55296) to BUFFERSPACE(849920) This will definitely improve sequential preformance as well as loading vitually all of your Index set into memory during direct processing. CICS performance will of course be determined by the FCT values. Back to space concerns, if you or your applications folks know for a fact that the insert pattern is fairly uniform throughout the file then freespace(33,33) makes sense. If the pattern is skewed then you are wasting a lot of space. After your initial load, you have data in only 44% of your file. You might try reducing freespace to 20,33 (check to see that is CA, CI) and see what the effect on CA splits is. Good luck. While freespace parameters are often the result of an apps person copying someone elses definition and can be reduced without harm, I have had a customer hit the 4gb limit after changing freespace to 0,0, so take care. Mainstar's Catalog Recovery Plus has a Map command which will report on space usage within a file. If you are having space usage problems it might be worth looking into. ________________________________ From: Dean Montevago [mailto:[EMAIL PROTECTED] Sent: Fri 8/17/2007 10:22 AM To: [email protected] Subject: Re: SMS Question - Urgent No flames please, is this is archaic. It's been like this for years. DEFINE CLUSTER (NAME(REFPROD.REFMSTR) RECORDSIZE(6000 6000) FREESPACE(33 33) BUFFERSPACE(55296) KEYS(9 0) SHAREOPTIONS(2 3) SPEED VOLUMES(REFP08 REFP06 REFP13)) DATA(NAME(REFPROD.REFMSTR.DATA) CYL(900 300) CONTROLINTERVALSIZE(18432)) INDEX(NAME(REFPROD.REFMSTR.INDEX) CYL(3 2) CONTROLINTERVALSIZE(2048)) ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
