|
View previous topic :: View next topic
|
| Author |
Message |
vijikesavan
Active User
Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA
|
|
|
|
Hi,
We have a huge IAM file and are looking for any tuning options. We ran IAMINFO to get details about the file. We got the report but not sure how to read and intrepret it.
Though the report said "SPECIFYING A BUFNO VALUE GREATER THAN 32 MAY IMPROVE PERFORMANCE" I am not sure how to set the BUFNO value. In the JCL we have (BUFNI=20, BUFND=50). Also not sure as what parameter to look for tuning?
The IAMINFO report:
| Code: |
IAM400 INNOVATION IAM INFORMATION PRINT ROUTINE -- IAMNINFO VER 8.0/34P -- INNOVATION DATA PROCESSING DATE-2007.164
IAM360 STEP - STEP05R DDNAME - VAHST DATA SET MONITORED - PRTEDMD.VSAM.DPR4AHST.AHSTMSTR
IAM361 INFO REQUESTED BY PROGRAM IBA690A FOR INPUT PROCESSING OPENED-2007.163.23:51:47 CLOSED-2007.164.00:38:52
IAM362 IAM DATA CHARACTERISTICS - OVERRIDES IN EFFECT:
? IAM FILE FORMAT-----------= ENHANCED - IAM FILE STATUS-----------= LOADED
? LOGICAL RECORD LENGTH-----= 5000 - CI SIZE-------------------= 8192
? KEY SIZE------------------= 32 - KEY OFFSET----------------= 0
? TOTAL RECORDS-------------= 20755300 - TOTAL RECORDS DELETED-----= 0
TOTAL RECORDS UPDATED-----= 1 - TOTAL RECORDS INSERTED----= 0
IAM363 IAM FILE CHARACTERISTICS -
? BLOCKING FACTOR-----------= 2 - BLOCK SIZE----------------= 27998
? TRACKS IN USE-------------= 59570 - VARIABLE LENGTH OVERFLOW--= YES
? NUMBER OF EXTENTS---------= 8 - NUMBER OF VOLUMES---------= 2
? DATASET TYPE--------------= KSDS - SHARE OPTIONS-------------= 2
? NUMBER OF IAM DATA BLOCKS-= 118954 - HIGH ALLOCATED RBN--------= 0
? INTEGRATED OVERFLOW (CI%)-= 0 - DASD RESERVE (CA%)--------= 5
? FILE DEFINED DATE---------= 2007.163 - FILE DEFINED TIME---------= 23:29:14
? FILE LOADED DATE----------= 2007.163 - FILE LOADED TIME----------= 23:34:54
FILE UPDATE DATE----------= 2007.163 - FILE UPDATE TIME----------= 23:50:56
IAM372 IAM EXTENDED AREA CHARACTERISTICS -
? EXT. OVERFLOW RECORDS-----= 0 - EXT. OVERFLOW BLOCKS------= 0
? EXTENDED BLOCKS ALLOCATED-= 0 - EXTENDED PE BLOCKS--------= 0
EXTENDED BLOCKS USED -----= 0 - EXTENDED BLOCKS AVAILABLE-= 0
IAM365 IAM EXECUTION STATISTICS -
? TOTAL STORAGE REQUIRED----= 2412544 - PRIME INDEX(COMPRESSED)---= 1329752
? STORAGE ABOVE THE LINE----= 2408448 - COMPRESSED DATA STRUCTURE-= YES
? INDEX SPACE USED (K)------= 0 - TOTAL JOB INDEX SPACE USED= 0
? REQUESTS PROCESSED--------= 13560332 - REQUESTS FAILED-----------= 839215
? DISK BLOCKS READ----------= 50965 - DISK BLOCKS WRITTEN-------= 0
? DYNAMIC BUFFER RETRIEVALS-= 2017082 - MAXIMUM BUFFERS USED------= 32
? MINIMUM BUFFERS USED------= 1 - MAXIMUM BUFFERS AVAILABLE-= 32
DYNAMIC TABLE RETRIEVALS--= 0 - DYNAMIC TABLE RECORDS-----= 0
IAM368 SPECIFYING A BUFNO VALUE GREATER THAN 32 MAY IMPROVE PERFORMANCE
?IAM366 IAM COMMAND EXECUTION SUMMARY -
?
? GET RANDOM----------------= 0 - PUT UPDATE----------------= 0
? GET SEQUENTIAL------------= 9691376 - PUT ADD-------------------= 0
? GET PREVIOUS--------------= 0 - POINT (START BROWSE)------= 1740316
? GET KGE/GENERIC-----------= 0 - POINT KGE/GENERIC---------= 2128636
? GET (SKIP SEQUENTIAL)-----= 0 - ERASE---------------------= 0
? ENDREQ--------------------= 0 - WRTBFR--------------------= 0
? IAM STATISTICS------------= 0 - IAM FLUSH BUFFER----------= 0
? CLOSE---------------------= 1 - OPEN----------------------= 3
? CLOSE TYPE=T--------------= 0 - VERIFY--------------------= 0
? INVALID REQUESTS----------= 0 - RECORD LENGTH CHANGES-----= 0
SEQ CHAINED BLOCKS READ---= 5122 - SEQ CHAINED BLOCKS WRITTEN= 0 |
Any kind of pointers will be of more help.
Thanks,
Viji |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
BUFNO is the buffer parameter for NON VSAM datasets.
IAM is a completely stand alone access method developed and marketed by Innovation Data Processing, so my first suggestion would be to look through the relevant documentation for the IAM product.
If in doubt - contact your support people at IDP - they are usually pretty helpful. |
|
| Back to top |
|
|
|
|
