MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

FSPC(0 0) for a VSAM KSDS

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
Cogito-Ergo-Sum
Advanced


Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA

PostPosted: Thu Nov 09, 2006 7:48 am    Post subject: FSPC(0 0) for a VSAM KSDS Reply with quote

Hi,
I am aware of the meaning of FREESPACE(0 0). I am also clear about a CI/CA splits. But, I am not sure, I fully understand by the meaning of 0% for the CI and CA. With the CI% set to 0, it means, that the whole of CISZ is meant to be used by records. That means, the probability of a CI split is higher here. If FSPC was coded as non-zero, then the next available CI would be used.

Can someone please explain why would anyone choose FSPC(0 0) for a VSAM KSDS ?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Back to top
View user's profile Send private message
warp5
Intermediate


Joined: 02 Dec 2002
Posts: 429
Topics: 18
Location: Germany

PostPosted: Fri Nov 10, 2006 2:42 am    Post subject: Reply with quote

Probably just for documentation purpose, this is the default anyway. Maybe there was a value in there before and now 0 is used. Maybe updates are not being done anymore - just a read dataset. In any case, it is often better to have a 0 FSPC for CI and use a FSPC for the CA instead.
Back to top
View user's profile Send private message Visit poster's website
Cogito-Ergo-Sum
Advanced


Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA

PostPosted: Fri Nov 10, 2006 4:41 am    Post subject: Reply with quote

Quote:
Maybe updates are not being done anymore - just a read dataset.

Unfortunately, that is not the case. It is being heavily updated.

Quote:
In any case, it is often better to have a 0 FSPC for CI and use a FSPC for the CA instead.
To save space, perhaps ?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Back to top
View user's profile Send private message
warp5
Intermediate


Joined: 02 Dec 2002
Posts: 429
Topics: 18
Location: Germany

PostPosted: Mon Nov 13, 2006 2:36 am    Post subject: Reply with quote

Why don't you post the definitions and information so we can give an opinion on them.
Back to top
View user's profile Send private message Visit poster's website
Bill Dennis
Advanced


Joined: 03 Dec 2002
Posts: 579
Topics: 1
Location: Iowa, USA

PostPosted: Mon Nov 13, 2006 9:18 am    Post subject: Reply with quote

Or perhaps the updates are mostly additions to the end of the keyrange?
_________________
Regards,
Bill Dennis

Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity.
Back to top
View user's profile Send private message
warp5
Intermediate


Joined: 02 Dec 2002
Posts: 429
Topics: 18
Location: Germany

PostPosted: Tue Nov 14, 2006 2:16 am    Post subject: Reply with quote

Or the updates maybe so scattered that freespace does not really help, or maybe they should be mass inserted, or .......
More information and details are needed.
Back to top
View user's profile Send private message Visit poster's website
Cogito-Ergo-Sum
Advanced


Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA

PostPosted: Wed Nov 15, 2006 8:50 pm    Post subject: Reply with quote

warp5,
The inserts are generally towards the end of keyrange; as mentioned by Bill D. It is rarely scatterred out.

After spending some more time on the program, I have a feeling that, the program can be replaced with a delete/define/load steps in the job.

I know, I am providing scanty information; but, that is more because I am not really sure what information is sought after. Given that, the file is used in batch only (and, used by CICS when batch is down) and is heavily updated towards the end of keyranges, what is the next step in deciding FSPC values for CA ?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Back to top
View user's profile Send private message
warp5
Intermediate


Joined: 02 Dec 2002
Posts: 429
Topics: 18
Location: Germany

PostPosted: Thu Nov 16, 2006 2:23 am    Post subject: Reply with quote

It sounds to me as if you would be better off not to have any FSPC at all, as the cluster is now defined. Using freespace would just waste space because the inserts would only affect the last few CAs of the cluster (inserts are at the end of the keyrange). Mass insert might be usefull if it is possible.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group