View previous topic :: View next topic
|
Author |
Message |
n459760
New User
Joined: 13 Oct 2009 Posts: 8 Location: Albany,NY
|
|
|
|
Hi,
We have defined an SMS managed extended format VSAM dataset as follows:
DEFINE CLUSTER -
(NAME (AA.BBBB.CCCCDDDD.EEFFGG) -
VOLUME(* * * * *) -
CYL (3500 990) -
KEYS (20,0) -
MANAGEMENTCLASS(AABIG) DATACLASS(DCEXTEND) -
STORAGECLASS(BBBIG) -
RECORDSIZE (100 100) -
SHAREOPTIONS (1 3) REUSE -
FREESPACE (0,0)) -
DATA (NAME(AA.BBBB.CCCCDDDD.EEFFGG.DATA) -
CONTROLINTERVALSIZE (8192))-
INDEX (NAME(AA.BBBB.CCCCDDDD.EEFFGG.INDEX) -
CONTROLINTERVALSIZE (4096))
While accessing it in batch with SUBSYS=BLSR method we are generating high exception counts. "VSAM Demystified" does say that BLSR might not be perfect for extended format VSAM but rather we should use SMB - system managed buffering. I am reading the VSAM manual but information regarding how to go about it is scattered. I just want to gather from everyone's valuable experience some information/method to use SMB:
a. What changes do I need to do?
b. What are the additional parameters (if any) that I need to define? Are these parameters defined during file definition or in JCL.
Your inputs are appreciated! |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Read VSAM Demystified starting with page 82. It talks about the specific changes required to use SMB.
Is the access sequential, mixed random and sequential, skip sequential, or random? BLSR, like CICS LSR pools, is pretty good at handling random access but performs poorly with sequential or nearly sequential access. |
|
Back to top |
|
|
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008 Posts: 2501 Location: Atlanta, Georgia, USA
|
|
|
|
Are you adding to this file, either in Batch or CICS, because you've not specified any CI/CA Freespace percentage.
Also, based upon the RECORDSIZE and KEYLENGTH, the CISZ for both DATA and INDEX may not be as optimal as you'd think, which could cause high EXCP's, especially when there's a CI split or (worse case) a CA split, due to ZERO Freespace for both.
A review of this definition is in order.
Bill |
|
Back to top |
|
|
n459760
New User
Joined: 13 Oct 2009 Posts: 8 Location: Albany,NY
|
|
|
|
Bill,
Thank you for your reply. The CISZ definitions have been modified but no freespaces was specified because this file is never updated in online or batch. Its a reference file will not undergo CI/CA splits. Its always deleted/defined and reloaded nightly.
After reading through VSAM Demystified, I came up with this definition of the file in JCL so that it can use SMB:
//DDNAMEA DD DSN=AA.BBBB.CCCCDDDD.EEFFGG,DISP=SHR,
// AMP=(‘RMODE31=BUFF’,’ACCBIAS=SYSTEM’)
I am just waiting on system folks to confirm changes to the extended format definition for RECORD_ACCESS_BIAS and STRIPING before I could begin testing. I will update my findings here. |
|
Back to top |
|
|
mftrigger
New User
Joined: 18 Feb 2006 Posts: 23 Location: chennai
|
|
|
|
Halo n459760,
You say there is a very high EXCPs coz of this VSAM.
The basic procedure to be followed for VSAM tuning -
- Get the programs, having high EXCPs for this particular VSAM.
- Analyze how this VSAM and what for this VSAM is accessed in the program. (This includes usage mode - seq,random.. and hw it is opened - i, i-o,output).
- then decide on whether to code buffers or use BLSR, depending on the mode.
- Depending on specific cases, a lot of tuning could be done for VSAMs. |
|
Back to top |
|
|
n459760
New User
Joined: 13 Oct 2009 Posts: 8 Location: Albany,NY
|
|
|
|
Thanks mftrigger for your comments.
BLSR is not recommended for extended format. We are working on tuning.
Thanks! |
|
Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 580 Location: London
|
|
|
|
For a Batch sequential load there is a very useful rule of thumb for buffering. This is 2 times the number of data CI's that fit into a track + 3 for your DATA buffers.
This will serve you quite well in most cases. You can specify the buffering on the JCL as per the following example for your 8192 data CISIZE:
// AMP=('AMORG,BUFND=16,BUFNI=3')
You can also set a BUFFERSPACE value on the define but this means the buffers are permanently allocated while the dataset is open rather than just for the load, and may not be compatible with the CICS LSR buffer arrangement. |
|
Back to top |
|
|
n459760
New User
Joined: 13 Oct 2009 Posts: 8 Location: Albany,NY
|
|
|
|
Here is what we did:
Defined a new STORAGE CLASS with greater STRIPE count and a SDR (sustained data rate) of 21. We modified the JCL for the extended format dataset to be:
AMP=('ACCBIAS=SYSTEM','RMODE31=BUFF')
ACCBIAS = SYSTEM is used so that it used system managed buffering and RMODE31 = BUFF is used so that buffers above 16 MB line is used.
With this the performance has increased significantly.
Pete thank you for your comments. As earlier commented BLSR is not advised for extended formant so we used SMB. |
|
Back to top |
|
|
mftrigger
New User
Joined: 18 Feb 2006 Posts: 23 Location: chennai
|
|
|
|
n459760, Thanks for sharing the methodology you used.
I have a question related to this.
When i see the execution results in the SAR page of certain jobs, which uses VSAMs w/o buffers, I see there are system allocated buffers for these VSAMs.
So my Q is .. Is there any difference between the above mentioned SYSTEM buffers and the buffers i came across.
Note:
My assumption is these system buffering usage depends on the Default configuration setup in the respective mainframes.. Is my assumption rt ? |
|
Back to top |
|
|
n459760
New User
Joined: 13 Oct 2009 Posts: 8 Location: Albany,NY
|
|
|
|
Hi mftrigger,
Your assumption is correct. If you do not specify BUFFERS in the jcl then the system allocates them based on their default definition in the ACS routines set up by system admin. This may vary based on installations and their definition.
Our need was to use an extended format VSAM and while reading through VSAM Demystified we came across and used options defined for extended format VSAM that gave us better results. |
|
Back to top |
|
|
mftrigger
New User
Joined: 18 Feb 2006 Posts: 23 Location: chennai
|
|
|
|
Thanks a lot for the clarification, n459760.
Have a fun-filled day! |
|
Back to top |
|
|
|