Michael Poil wrote:
RS,
Can you provide the LISTCAT output please.
Michael, please find output below.
I played with Index CISZ 1.5 - 18kB. I always get 3 CA splits.
I also played with CA freespace: 0-15 % gives 3 CA splits, 30-50% - 4 CA
splits, 60% - 5 CA splits.
DEF CL (NAME(HLQ1.VSAM.KSDS1) -
SHR(2 3) -
SPEED -
INDEXED) -
DATA (CYL(2 1) -
FSPC(15 15) -
KEYS(8 92) -
CISZ(4096) -
RECSZ(100 100) -
)
REPRO IDS(HLQ1.VSAM.P1000) ODS(HLQ1.VSAM.KSDS1)
0IDC0005I NUMBER OF RECORDS PROCESSED WAS 20000
0IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0
LISTCAT ENT(HLQ1.VSAM.KSDS1) ALL
0CLUSTER ------- HLQ1.VSAM.KSDS1
IN-CAT --- CAT.XXX.XXX
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2007.337
1IDCAMS SYSTEM SERVICES TIME:
11:56:45 12/03/07 PAGE 2
0 RELEASE----------------2 EXPIRATION------0000.000
SMSDATA
STORAGECLASS ---STANDARD MANAGEMENTCLASS---MCUSYS
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
BWO STATUS------00000000 BWO TIMESTAMP---00000 00:00:00.0
BWO---------------(NULL)
RLSDATA
LOG ----------------(NULL) RECOVERY REQUIRED --(NO) FRLOG
------------(NULL)
VSAM QUIESCED -------(NO) RLS IN USE ---------(NO)
0 LOGSTREAMID-----------------------------(NULL)
RECOVERY TIMESTAMP LOCAL-----X'0000000000000000'
RECOVERY TIMESTAMP GMT-------X'0000000000000000'
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
DATA-----HLQ1.VSAM.KSDS1.DATA
INDEX----HLQ1.VSAM.KSDS1.INDEX
0 DATA ------- HLQ1.VSAM.KSDS1.DATA
IN-CAT --- CAT.XXX.XXX
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2007.337
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--HLQ1.VSAM.KSDS1
ATTRIBUTES
KEYLEN-----------------8 AVGLRECL-------------100
BUFSPACE------------9728 CISIZE--------------4096
RKP-------------------92 MAXLRECL-------------100
EXCPEXIT----------(NULL) CI/CA----------------180
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED
NOWRITECHK NOIMBED NOREPLICAT
UNORDERED NOREUSE NONSPANNED
STATISTICS
REC-TOTAL----------20000 SPLITS-CI--------------0
EXCPS-----------------14
REC-DELETED------------0 SPLITS-CA--------------0
EXTENTS----------------3
REC-INSERTED-----------0 FREESPACE-%CI---------15
SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA---------15
X'C196FEBB879C390C'
REC-RETRIEVED----------0 FREESPC-----------536576
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA---------2949120
SPACE-PRI--------------2 HI-U-RBA---------2949120
SPACE-SEC--------------1
VOLUME
VOLSER------------XXXXXX PHYREC-SIZE---------4096
HI-A-RBA---------2949120 EXTENT-NUMBER----------3
DEVTYPE------X'3010200F' PHYRECS/TRK-----------12
HI-U-RBA---------2949120 EXTENT-TYPE--------X'00'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'005C0000' LOW-RBA----------------0
TRACKS----------------30
HIGH-CCHH----X'005D000E' HIGH-RBA---------1474559
LOW-CCHH-----X'005E0000' LOW-RBA----------1474560
TRACKS----------------15
HIGH-CCHH----X'005E000E' HIGH-RBA---------2211839
1IDCAMS SYSTEM SERVICES TIME:
11:56:45 12/03/07 PAGE 3
0 LOW-CCHH-----X'005F0000' LOW-RBA----------2211840
TRACKS----------------15
HIGH-CCHH----X'005F000E' HIGH-RBA---------2949119
0 INDEX ------ HLQ1.VSAM.KSDS1.INDEX
IN-CAT --- CAT.XXX.XXX
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2007.337
RELEASE----------------2 EXPIRATION------0000.000
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--HLQ1.VSAM.KSDS1
ATTRIBUTES
KEYLEN-----------------8 AVGLRECL---------------0
BUFSPACE---------------0 CISIZE--------------1536
RKP-------------------92 MAXLRECL------------1529
EXCPEXIT----------(NULL) CI/CA-----------------26
SHROPTNS(2,3) RECOVERY UNIQUE NOERASE NOWRITECHK
NOIMBED NOREPLICAT UNORDERED
NOREUSE
STATISTICS
REC-TOTAL--------------5 SPLITS-CI--------------0
EXCPS-----------------20 INDEX:
REC-DELETED------------0 SPLITS-CA--------------0
EXTENTS----------------1 LEVELS-----------------2
REC-INSERTED-----------0 FREESPACE-%CI----------0
SYSTEM-TIMESTAMP: ENTRIES/SECT----------13
REC-UPDATED------------0 FREESPACE-%CA----------0
X'C196FEBB879C390C' SEQ-SET-RBA------------0
REC-RETRIEVED----------0 FREESPC------------32256
HI-LEVEL-RBA--------3072
ALLOCATION
SPACE-TYPE---------TRACK HI-A-RBA-----------39936
SPACE-PRI--------------1 HI-U-RBA------------7680
SPACE-SEC--------------1
VOLUME
VOLSER------------XXXXXX PHYREC-SIZE---------1536
HI-A-RBA-----------39936 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK-----------26
HI-U-RBA------------7680 EXTENT-TYPE--------X'00'
VOLFLAG------------PRIME TRACKS/CA--------------1
EXTENTS:
LOW-CCHH-----X'0015000B' LOW-RBA----------------0
TRACKS-----------------1
HIGH-CCHH----X'0015000B' HIGH-RBA-----------39935
1IDCAMS SYSTEM SERVICES TIME:
11:56:45 12/03/07 PAGE 4
REPRO IDS(HLQ1.VSAM.P1010) ODS(HLQ1.VSAM.KSDS1)
0IDC0005I NUMBER OF RECORDS PROCESSED WAS 500
0IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0
LISTCAT ENT(HLQ1.VSAM.KSDS1) ALL
0CLUSTER ------- HLQ1.VSAM.KSDS1
IN-CAT --- CAT.XXX.XXX
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2007.337
RELEASE----------------2 EXPIRATION------0000.000
SMSDATA
STORAGECLASS ---STANDARD MANAGEMENTCLASS---MCUSYS
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
BWO STATUS------00000000 BWO TIMESTAMP---00000 00:00:00.0
BWO---------------(NULL)
RLSDATA
LOG ----------------(NULL) RECOVERY REQUIRED --(NO) FRLOG
------------(NULL)
VSAM QUIESCED -------(NO) RLS IN USE ---------(NO)
0 LOGSTREAMID-----------------------------(NULL)
RECOVERY TIMESTAMP LOCAL-----X'0000000000000000'
RECOVERY TIMESTAMP GMT-------X'0000000000000000'
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
DATA-----HLQ1.VSAM.KSDS1.DATA
INDEX----HLQ1.VSAM.KSDS1.INDEX
1IDCAMS SYSTEM SERVICES TIME:
11:56:45 12/03/07 PAGE 5
0 DATA ------- HLQ1.VSAM.KSDS1.DATA
IN-CAT --- CAT.XXX.XXX
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2007.337
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--HLQ1.VSAM.KSDS1
ATTRIBUTES
KEYLEN-----------------8 AVGLRECL-------------100
BUFSPACE------------9728 CISIZE--------------4096
RKP-------------------92 MAXLRECL-------------100
EXCPEXIT----------(NULL) CI/CA----------------180
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED
NOWRITECHK NOIMBED NOREPLICAT
UNORDERED NOREUSE NONSPANNED
STATISTICS
REC-TOTAL----------20500 SPLITS-CI--------------0
EXCPS----------------248
REC-DELETED------------0 SPLITS-CA--------------3
EXTENTS----------------6
REC-INSERTED---------500 FREESPACE-%CI---------15
SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA---------15
X'C196FEBF0063A30B'
REC-RETRIEVED----------0 FREESPC----------2629632
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA---------5160960
SPACE-PRI--------------2 HI-U-RBA---------5160960
SPACE-SEC--------------1
VOLUME
VOLSER------------XXXXXX PHYREC-SIZE---------4096
HI-A-RBA---------5160960 EXTENT-NUMBER----------6
DEVTYPE------X'3010200F' PHYRECS/TRK-----------12
HI-U-RBA---------5160960 EXTENT-TYPE--------X'00'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'005C0000' LOW-RBA----------------0
TRACKS----------------30
HIGH-CCHH----X'005D000E' HIGH-RBA---------1474559
LOW-CCHH-----X'005E0000' LOW-RBA----------1474560
TRACKS----------------15
HIGH-CCHH----X'005E000E' HIGH-RBA---------2211839
LOW-CCHH-----X'005F0000' LOW-RBA----------2211840
TRACKS----------------15
HIGH-CCHH----X'005F000E' HIGH-RBA---------2949119
LOW-CCHH-----X'00C50000' LOW-RBA----------2949120
TRACKS----------------15
HIGH-CCHH----X'00C5000E' HIGH-RBA---------3686399
LOW-CCHH-----X'00C60000' LOW-RBA----------3686400
TRACKS----------------15
HIGH-CCHH----X'00C6000E' HIGH-RBA---------4423679
LOW-CCHH-----X'00C70000' LOW-RBA----------4423680
TRACKS----------------15
HIGH-CCHH----X'00C7000E' HIGH-RBA---------5160959
0 INDEX ------ HLQ1.VSAM.KSDS1.INDEX
IN-CAT --- CAT.XXX.XXX
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2007.337
RELEASE----------------2 EXPIRATION------0000.000
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--HLQ1.VSAM.KSDS1
ATTRIBUTES
1IDCAMS SYSTEM SERVICES TIME:
11:56:45 12/03/07 PAGE 6
0 KEYLEN-----------------8 AVGLRECL---------------0
BUFSPACE---------------0 CISIZE--------------1536
RKP-------------------92 MAXLRECL------------1529
EXCPEXIT----------(NULL) CI/CA-----------------26
SHROPTNS(2,3) RECOVERY UNIQUE NOERASE NOWRITECHK
NOIMBED NOREPLICAT UNORDERED
NOREUSE
STATISTICS
REC-TOTAL--------------8 SPLITS-CI--------------3
EXCPS---------------1069 INDEX:
REC-DELETED------------0 SPLITS-CA--------------0
EXTENTS----------------1 LEVELS-----------------2
REC-INSERTED-----------0 FREESPACE-%CI----------0
SYSTEM-TIMESTAMP: ENTRIES/SECT----------13
REC-UPDATED-----------35 FREESPACE-%CA----------0
X'C196FEBF0063A30B' SEQ-SET-RBA------------0
REC-RETRIEVED----------0 FREESPC------------27648
HI-LEVEL-RBA--------3072
ALLOCATION
SPACE-TYPE---------TRACK HI-A-RBA-----------39936
SPACE-PRI--------------1 HI-U-RBA-----------12288
SPACE-SEC--------------1
VOLUME
VOLSER------------XXXXXX PHYREC-SIZE---------1536
HI-A-RBA-----------39936 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK-----------26
HI-U-RBA-----------12288 EXTENT-TYPE--------X'00'
VOLFLAG------------PRIME TRACKS/CA--------------1
EXTENTS:
LOW-CCHH-----X'0015000B' LOW-RBA----------------0
TRACKS-----------------1
HIGH-CCHH----X'0015000B' HIGH-RBA-----------39935
--
Radoslaw Skorupka
Lodz, Poland
--
BRE Bank SA
ul. Senatorska 18
00-950 Warszawa
www.brebank.pl
Sąd Rejonowy dla m. st. Warszawy
XII Wydział Gospodarczy Krajowego Rejestru Sądowego,
nr rejestru przedsiębiorców KRS 0000025237
NIP: 526-021-50-88
Według stanu na dzień 01.01.2007 r. kapitał zakładowy BRE Banku SA (w całości
opłacony) wynosi 118.064.140 zł. W związku z realizacją warunkowego
podwyższenia kapitału zakładowego, na podstawie uchwał XVI WZ z dnia 21.05.2003
r., kapitał zakładowy BRE Banku SA może ulec podwyższeniu do kwoty 118.760.528
zł. Akcje w podwyższonym kapitale zakładowym będą w całości opłacone.
----------------------------------------------------------------------
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
