-----------------------<snip>-------------------
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))
----------------------<unsnip>-----------------------
Dean, I strongly suggest that you remove the CISIZE specifications
entirely; let the system choose the sizes for optimization.
With that freespace specification, you're leaving every CI and CA 1/3
empty, Do you really have that much insert activity?
SMS ACS routines will only kick in during a DEFINE operation, but if the
activity isn't too high, you might consider COMPACTION to reduce the
space requirements. In my experience on sequential files, COMPACTION
will reduce the size by around 50%.
----------------------------------------------------------------------
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
