Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

VSAM CI Split

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
kumar_ngl
Warnings : 1

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Wed Dec 28, 2005 10:54 am    Post subject: VSAM CI Split
Reply with quote

Hi friends,

I was asked this question in an interview...plz gimme the ryt answer for this

Ques: VSAM CI Split will happen when

1) record Addition,deletion
2) record addition,deletion,updation
3)record updation

am get confused with the option 1 and 2...help me to know the ryt answer

kumar.p.v
Back to top
View user's profile Send private message

khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Wed Dec 28, 2005 11:13 am    Post subject: VSAM CI
Reply with quote

Hi Kumar,
In Deletion CI split wont occur. so Choice 3 is right.
Back to top
View user's profile Send private message
kumar_ngl
Warnings : 1

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Wed Dec 28, 2005 11:29 am    Post subject: Re: VSAM CI Split
Reply with quote

thanks khamarutheen,

But how abt addition, if the CI is not enough to carry all the records then the split will occurs...so i think the answer is option 1 and i want to clear is it ryt or wrong

kumar.p.v
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Wed Dec 28, 2005 11:32 am    Post subject: CI split
Reply with quote

Hi kumar,
U r right, By Addition also it will get split. ie., in general whenever the table is added with some data either new or existing record get updated with more no. of datas then the CI split will occur. since the Deletion will not split how the choice 1 will b right .. so only i suggest choice 3.
Back to top
View user's profile Send private message
kumar_ngl
Warnings : 1

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Wed Dec 28, 2005 12:28 pm    Post subject: Re: VSAM CI Split
Reply with quote

thanks khamarutheen...

kumar.p.v
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us