-
What is the maximum record length for the VSAM dataset?
dhs01
- Apr 15th, 2009
What do you mean by record size? Are you asking about physical terms or logical? I can't say about current vsam but at one time the records were 512,1024,2048, and 4096. CIs which are the logical ...
Ravi
- Aug 4th, 2007
The maximum record length has been told during the discussion However would like to just emphasize correctly.Tape :-28627 Disk :32767 The maximum can be one cylinder=1 CI
-
What is the difference between CI( CONTROL INTERVAL)and CA(CONTROL AREA). I refereed SAB A ZAMIR JCL book in that he said collection of CI is called CA but in next page (286) he explained this with showing one CI as a CA. Can you please let me know the difference?
rb333
- Apr 15th, 2009
Both the statements are true. Collection of CI's is called CA means one or more than one CI together forms a CA. In case, a CA comprises of only one CI it means CI=CA in that case. Hope i answer your question.
venkat.palla
- Aug 7th, 2007
CI and CA in VSAM are the acronyms for Control Interval and Control Area respectively. Basically CI is the area within which group of records are stored. Collection of CIs are stored in CA. CIs will t...
-
-
While designing vsam files,what's the best way to choose control interval size for the data and the index?
nlarsensmith
- Dec 1st, 2010
Best way is to choose small CI size for random access and large CI size for direct access. Without specifying CISZ the defaults will be 4096 for data and 1024 for index. Remember these sizes are obtai...
dhs01
- Apr 15th, 2009
1024 and 4096 are powers of 2. You could specify 1000 and 4000 but VSAM would actually use 1024 and 4096 although I'm not sure if the full 1024 would actually be available to you. Short answer is that since that is the number VSAM will use, 1000 or 4000 will not save you anything.
-
Explain the concept behind spanned records & SHAREOPTS ?
nlarsensmith
- Dec 1st, 2010
These options are not corrolated!Spanned record : If a CI has not enough freespace to fit in a new record, then the record is spanned to the next CI. If the next CI does not have enought freespa...
ambadiramesh
- Feb 16th, 2010
It seems fine regarding CI split. CA split also occurs in the same as CI split. But remember these two concepts comes into the picture in case of KSDS only.Please let me know if you have any doubts.Regards,Ramesh.Ambadi.
-
-
What is the maximum no. of records that can be allowed in VSAM?
dhs01
- Apr 15th, 2009
At one time, can't say if this restriction still exists but it had to do with the ability to address the records. Because VSAM only allowed for even numbers, the addressing allowed for 4G of data, so the number of records was limited to what could be fit into that size space.
-
How do you compile a program in Endevor?
kousikgeek
- Oct 25th, 2008
I think the question is how to compile an existing program in unit test or SIT or any region by Endeavor. If the question is just to complie the existing program but not to add the changes to Endeavor...
Srinivas
- Oct 31st, 2007
Guys,Every application needs to setup in Endevor as System & Subsystem names.Then each type like cobol, jcl, etc should need to be defined under that application in Endevor. Then the actual core work ...
-
Can we use AIX in ESDS? If yes,explain?
stuartslom
- Feb 18th, 2009
YES!AIX for ESDS RECSZ = 5 + AIXKL + (n x 4) Where: AIXKL is the alternate-key length n = 1 when UNIQUEKEY is specified n = the number of data records in the base cluster that contain the same alternate-key value, when NONUNIQUEKEY is specified.
Anilsodadasi
- Mar 27th, 2007
ESDS is a NonIndexed file. How can we create Alternative index file?. It's not posible to use AIX for ESDS.
-
How we can access the last record from KSDS file ?
Nandhakumar
- Nov 19th, 2018
Start is used to read a file dynamically (Some where in between the file), so its not needed for sequential read from end of the file. Moving High-values to Key field would absolutely work.
Premasai
- Jun 12th, 2010
I dont think moving HIGH-VALUES will take you to the last record , as you need to access the record for which the key value is <= HIGH VALUES. And START KEY syntax does not allow you to search a ke...
-
What is the difference between vsam & data base tables?what is flat file ? difference between flat files,vsam,ps files?what is the difference between esds,ksds?what is rrds in vasm ? difference between rrds & ksds?application areas of rrds files in mainframe area?
Rishu
- Aug 2nd, 2014
VSAM is a Non-Relational database system while DB2 is a relational Database System(RDBS).
nlarsensmith
- Dec 1st, 2010
Ans1) DB tables are preferred when we want to maintain relationship amoung data. If no relationship is required then we can choose any. Remeber DB2 tables are always stored in VSAM files.Ans2)Flat fil...
-
-
How do you convert flat files to VSAM files?
kousikgeek
- Oct 25th, 2008
Following steps will convert a sequential file to VSAM file.1. Sort the sequential fille, with SORT FIELD=NONE, to remove the duplicate key records.2. Define a VSAM file3. Use REPRO to copy the sequential file to VSAM file.
Etnad
- Nov 18th, 2007
You can convert flat files to VSAM:1. Identify what will be your primary key. If you don't want to, the whole record can be?your primary key.2. Sort the file by primary key or the whole record (if no...
-
How vsam datasets are cataloged?
Jaypreeth
- May 1st, 2011
All VSAM datasets are SMS managed. SMS managed datasets are cataloged. So while creating a vsam dataset using the IDCAMS utility the dataset is cataloged.
Jaypreeth
- May 1st, 2011
All VSAM datasets are SMS managed. So by the IDCAMS utility VSAM dataset is created which is cataloged..
-
VSAM Data Sets
How will you access the VSAM data sets?
rpg0247
- Jul 13th, 2011
After getting list of files just type below code before the vsam file
print ch ids(/) -
How do you split a file data into multiple files?
Explain with example?
Read Best Answer
Editorial / Best Answer
jjtharappel- Member Since Nov-2011 | Nov 24th, 2011
Run a JCL with the below sort step
Code- //STEP1 EXEC PGM=SORT
- //SORTIN DD DSN=input-file-name,DISP=SHR
- //SORTOF01 DD DSN=output-file-name-1,
- // DISP=(NEW,CATLG,DELETE),
- // SPACE=...
- // LRECL=...,RECFM=FB
- //SORTOF02 DD DSN=output-file-name-2,
- // DISP=(NEW,CATLG,DELETE),
- // SPACE=...
- // LRECL=...,RECFM=FB
- //SORTOF03 DD DSN=output-file-name-3,
- // DISP=(NEW,CATLG,DELETE),
- // SPACE=...
- // LRECL=...,RECFM=FB
- //SYSOUT DD SYSOUT=*
- //SYSIN DD *
- SORT FIELDS=COPY
- OUTFIL FNAMES=SORTOF01,
- INCLUDE=(cond for file 1)
- OUTFIL FNAMES=SORTOF02,
- INCLUDE=(cond for file 2)
- OUTFIL FNAMES=SORTOF03,
- INCLUDE=(cond for file 3)
- /*
- //*
Haribabu
- Oct 15th, 2019
SORT FIELDS=COPY
OUTFIL FILES=OUT1,ENDREC=10000
OUTFIL FILES=02,STARTREC=10001,ENDREC=20000 OUTFIL FILES=03,STARTREC=20001,ENDREC=30000
also possible for OUTFIL FNAMES=(OUT1,OUT2,OUT3),SPLIT=10000Rishu
- Jul 31st, 2014
In addition to the above solution, we can use SPLIT BY in SORT. But it will depend on condition of split.
-
How can we check the amount of free space available for a VSAM dataset?
sai mainframes
- Jun 20th, 2008
For any information related to VSAM dataset, we can code LC(LISTCAT) before the name of dataset. then it will display the entire information about that particular VSAM dataset.for space used....it wil...
kkreddy98
- Aug 25th, 2007
Using LISTCAT command we can get all the information regarding the VSAM filethanks,kotireddy k.
-
How to retrieve record from a flat file?
nlarsensmith
- Dec 1st, 2010
We can directly read a record from a flat file using Cobol READ command!If you want to load the flat file into a PS file use REPRO command in IDCAMS Util.If you want to load a flat file which was obta...
Shashank Gite
- Jan 3rd, 2009
To retrieve record from flat file you can use IDCAMS utility with REPRO command and can copy the data into either a VSAM data set or another flat file
-
In vsam why we use export-import utility?
Shashank Gite
- Jan 3rd, 2009
EXPORT-IMPORT UTILITY is used to take a back along with the attributes of the VSAM file and restore the back with the same attributes respectively.We can use REPRO to take back up it will not cop...
Basu
- Jul 12th, 2006
Export utility is used to take a backup of VSAM dataset in tape and then import utility is used to restore that dataset again from tape
-
Why VSAM concept came into existence ?
dhs01
- Apr 15th, 2009
VSAM was written as a replacement for ISAM. The main problem with ISAM was that if there were many insertions and deletions the way he chained the entries was horribly inefficient. VSAM through the use of splitting CIs was a hugh improvement.
KF
- Nov 16th, 2006
Why did VSAM come into existance? Think DOS VS! Using VSAM was much, much easier than coding masses of inflexible DLBL and EXTENT cards for running jobs in DOS VS.
VSAM Interview Questions
Read Best Answer
Ans