-
Explain the differences between VSAM and Non-VSAM files
(i) The ISPF panel or a standard JCL is used for creation of a NON VSAM dataset. The AMS program is used to create the VSAM files. (ii) The information about the Non-VSAM files is stored as dataset labels in the VTOC, while the information of VSAM files is stored in Catalogs. (iii)The dataset organization's in Non-VSAM files are sequential (physical), Indexed Sequential, Direct and partitioned. The...
-
VSAM KSDS cluster declaration
Write a program the following scenarios, declare vsam ksds cluster by jcl by the following record layout?customer info(7) comp3,customer no x(6),customer name x(20),customer address x(35),customer mail-id x(25),and load the above layout thru jcl?
-
What is the difference between vsam files and non-vsam files?
uma_mca2007
- Jul 1st, 2008
VSAM files are used when we want to store data based on some key fields(Eg: KSDS)access method is indexed.NON VSAM files like PS are used when we want to store data which is not unique and also the access is sequential.
-
For accessing a VSAM cluster sequentially, STARTBR, READNEXT, ENDBR commands are used. Suppose the VSAM cluster is sorted on the basis of a field (lets say age) and using STARTBR pointer is positioned on the record with name 'brijesh'. By using READNEXT that record is read. Now if i again use READNEXT, next record will be read(which could be the record with name other than 'brijesh'). If I want to read the next record with the same name (i.e. brijesh), whether RESETBR will be correct option for me. By using RESETBR here, whether the pointer will be placed at the next record with same name(brijesh) or the first record with the name 'brijesh'. Please explain the same.
sai mainframes
- Jun 20th, 2008
Hi Brijesh,I guess your question is purely dependent on the situation(i.e data present in the dataser which you are accessing)when ever you sorted the data with age, it will sort like depend on age on...
-
How to find corrupted record in lengthy vsam file
kckinney
- May 25th, 2007
Corruption can happen in many ways. The dataset itself may be dirty, which can cause S0C7 abends in poorly written programs.CA/CI's can be corrupted, which may lead to S0C4 or Sx13 abends.Can you be more specific? The remedy is very different depending on what is corrupted.RTM,kk
-
-
What is the disadvantages of VSAM file?
thesmarttechie
- Nov 29th, 2007
The primary disadvantage of VSAM is that it cannot be stored on TAPE Volume. In case you are handling huge amount of data, many cyclinders will have to be allocated which is not cost-effective compare...
-
Explain the VSAM error code 118
Sreyoshi
- Feb 12th, 2008
The data set name is ineligible for RACF definition. User does not have authority (reason code0) or RACF inactive (reason code 12).
-
Access the Last Record
How we can access the last record from KSDS file?
-
VASM Share Options
What are the share options in VSAM, CA, CI? What is the syntax? How does it work?
kuganraja
- Dec 28th, 2009
SHAREOPTIONS(region system) -> deals with the cross region and cross system sharing of the VSAM dataset.For region 1,2,3,4 are the valid optionFor syste 1&2 are reserved 3&4 are valid option
-
VSAM Virtual Memory
What is the Virtual Memory Size for VSAM?
kuganraja
- Dec 28th, 2009
Virtual Memory deals with Operating System and VSAM deals with access method.Virtual memory depends on the addressing mode of the operating system.
-
Define KSDS
How will you define a KSDS of avg length-100 and max length-150 and key length 10
Read Best Answer
Editorial / Best Answer
Yaswanth kodali- Member Since Jul-2010 | Jul 12th, 2010
We can define the KSDS cluster by two ways by using the file-aid or by using the IDCAMS Utlity..
By using the IDCAMS utility we can define the record with average length 100 and maximum length 150 with keylength 10 starting at 0 as follows
//step01 EXEC pgm=IDCAMS
//SYSIN DD *
DEFINE CLUSTER(NAME(userid.name.sample) -
VOLUMES(MVS801) -
RECORDSIZE(100 150) -
TRACKS(10 20)
KEYS(10 0) -
INDEXED ) -
DATA ( NAME(userid.name.sample.data)) -
INDEX( NAME(userid.name.sample.index)) -
/*
//Yaswanth kodali
- Jul 12th, 2010
We can define the KSDS cluster by two ways by using the file-aid or by using the IDCAMS Utlity..By using the IDCAMS utility we can define the record with average length 100 and maximum length 150 with...
-
Reading KSDS File
How do you read a ksds file in reverse order?
hemanth.pesce
- Sep 29th, 2011
- Use STARTBR Command to point it to last record with by moving Keys to HIGH values .
-Then use READPREV to read records ... -
VSAM File with Null Data
how do you create a new VSAM file with null record as header with JCL please provide me with coding
-
What is the procedure for running the batch job in mainframe?
nsk_sasi
- Oct 19th, 2010
Friends, let me explain with an example:--EG:-Adding two numbersStep-1:- We need to compile that program and that compiled program(i.e Error free code) we need to keep in one Load Library (EG:-AB...
sunil
- May 21st, 2006
Prepare a RUNJCL and submit it.
-
What is the record size for alternate index if alternate key is unique
- whether record size is (5+alternate key length+n*pmy key length ) or (5+pmy key length + n*alternate key length) where 'n' is the no. of duplicate alternate keys.
naveen
- Mar 6th, 2017
After creating the AI we need to create path and finally we need to create the Build index. Then only the AI will have the actual data in it.
sagyant
- Oct 3rd, 2010
what i have come across,it is always 5 + alternate key length + n*primary Key lengththe key for alternate index is the alternate key and in the data part we have all the related primary keys populated.But i still do not understand how this data part get populated...:)
-
What is an Alternate Index? How to give the Max Record Length and Avg. Record Length?
lokeshheda
- Jul 9th, 2007
aix is nothing but a file by which we can featch a records by using a key other than primary key.
sureshnachiappan
- Nov 23rd, 2006
In ksds we will defining keys(5 0) this is a primary key. this a numeric but if we want some character as a key we going for alternateindex.using AIX we can retrieve records. recordsize(avg max)
-
-
What is the default size of the record
Read Best Answer
Editorial / Best Answer
nlarsensmith- Member Since May-2009 | Dec 1st, 2010
If the record size parameter is not specified when the cluster is created, then the size is determined by the size of the Control Interval.
kumar
- Jul 3rd, 2014
For non spanned--(4089,4089)
for spanned---(4086,32600)nlarsensmith
- Dec 1st, 2010
If the record size parameter is not specified when the cluster is created, then the size is determined by the size of the Control Interval.
-
Copy records without duplicates
How to copy records from 2 files with duplicates? Without duplicates?
VSAM Interview Questions
Read Best Answer
Ans