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 interview questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
rambabu
Currently Banned

New User


Joined: 18 Apr 2005
Posts: 67

PostPosted: Sat Jun 25, 2005 12:11 pm    Post subject: vsam interview questions
Reply with quote

helllo ,
can any body pls answer this questiions?
!

1) Difference between delete , purge erase force?

2)How do u check how many records are there in vsam cluster and the fspc availabillity for future insertion?

3)
If the key is from 10th byte to 13th byte, how will u code key parameter?
4)

How dou rename set of files in one shot?
5)
what is vsam re organization and how frequently we need do that?

6) after the vsam is created , first operation we should do is , initializing it with dummy record.(TRUE/FALSE).if if iam not initializing , what operation would give me problem?
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon Jun 27, 2005 6:45 am    Post subject: Re: vsam interview questions
Reply with quote

rambabu wrote:

6) after the vsam is created , first operation we should do is , initializing it with dummy record.(TRUE/FALSE).if if iam not initializing , what operation would give me problem?

True.
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Mon Jun 27, 2005 3:16 pm    Post subject:
Reply with quote

Quote:
1) Difference between delete , purge erase force?
Delete is a primary command and purge/erase/force are subcommands.

Quote:
2)How do u check how many records are there in vsam cluster and the fspc availabillity for future insertion?


2.1 Number of record: use LISTCA in ISPF near the vsam or use LISTCAT with IDCAMS in batch process and see the field REC-TOTAL
2.2 Freespace availability: use the same of 2.1 but look for FREESPC

Quote:
3) If the key is from 10th byte to 13th byte, how will u code key parameter?

Key (3 09)

Quote:
4) How dou rename set of files in one shot?
With IEBCOPY utility can do this but also IEHPROG.

Quote:
5) what is vsam reorganization and how frequently we need do that?

what do you mean with reorganization?
are you talking about the verify command?
Back to top
View user's profile Send private message
siva79

New User


Joined: 11 Jun 2005
Posts: 3

PostPosted: Mon Jun 27, 2005 6:15 pm    Post subject: Re: vsam interview questions
Reply with quote

Hi,

5) what is vsam re organization and how frequently we need do that?

a: whenever there is too many splits(CA & CI) happens, the CI & CA becomes complicated and also with the Index and sequence sets. So the performance may decrease in due course. So to avoid this, we go for re-organization of VSAM datasets. This is mainly for KSDS(as ESDS has nothing to do with insertions). Back up of the current dataset is taken and then define the new KSDS file and load the backup data to it back. This forms the VSAM dataset organized. Hope this will clear your doubt.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 5 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am


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