To compile a program through Endeavor. We need tp prepare aan ADDSCL to compile a program through Endeavor.The following points to be noted while preparing ADDSCL. 1.In which environment are we going to add a program.?As you all know there are... Read More

No. Because you cannot insert records in an ESDS, also when you rewrite a record, it must be of the same length. Thus putting any value forfreespace does not make any sense. Read More

Can write a dummy program that just opens the file for output & then closes it. Read More

Max size of a record in VSAM is cylinder = 2880 bytes approx. Read More

CONTROL INTERVAL :- It is same as Blocks are in JCL. It is the storage unit. Control Area : - It is collection of CI. Combination of ci is known as ca. one or more no of ci will be in a ca. Read More

Let’s be a little more precise.We will take the tack that you will be creating a KSDS file.First, you need to know which field/s you will be using as the primary key and if you need, alternate keys. Sort the records by that field/s.Use IDCAMS... Read More

The "dirty read" technique can be used to provide a high degree of concurrent access to VSAM files while avoiding the complications associated with CI and CA splits. The dirty read protocol can be summarized as follows: The VSAM file must be... Read More

When you allocate the vsam cluster at that time you have the option to catlog the dataset using the idcam utility. Apart from this tools like file aid also gives you an option to catalog a vsam dataset. Read More

IDCAMS is the Access Method Services program. You run the IDCAMS program and supply AMS commands thru SYSIN. (examples of AMS commands are DELETE, DEFINE, REPRO etc..). Read More

It is used for the back-up purpose.Whenever there is a loss of data by accidental then we can restore it from the Exported/Imported data. Read More

YES Read More

Relative generation numbers are updated only at the end of the job, not at the end of a step. To allocate a new generation, we would be using (+1) with a DISP of (NEW,CATLG,DELETE). To refer to this in a subsequent step in the same job, we would... Read More

Prepare a RUNJCL and submit it. Read More

Its depand upon the CA. Every vsam file allocate record differently. so, its tuff to tell the answer. Read More

VSAM Stands for Virtual Storage Acess Method...An Acess method is the component of operating system....it is the interface between Application Program and the physical opertaion of storage device.What is a VSAM? VSAM Stands for Virtual Storage Acess... Read More

The maximum condition code generated is returned as the condition code of the IDCAMS step. Read More

CI size should be based on record length, type of processing. Usually CI is 4K. If record length is larger(>1K), chose 6K or 8K. FREESPACE should be large if more number of insertions are envisaged. Usual values are (20 20) when heavy updates... Read More

SHAREOPTS is a parameter in the DEFINE and specifies how an object can be shared among users. It is coded as SHAREOPTS(a b), where a is the cross region share option ie how two or more jobs on a single system can share the file, while b is the cross... Read More

Value of 2 for cross region means that the file can be processed simultaneously by multiple users provided only one of them is an updater. Value of 3 for cross system means that any number of jobs can process the file for input or output (VSAM does... Read More

DEFINE ALTERNATEINDEX. Important paramters are RELATE where you specify the base cluster name, KEYS, RECORDSIZE,SHAREOPTIONS,UNIQUEKEY(or NONUNIQUEKEY), DATA(ds name for the data component), INDEX(ds name for the index component). Then DEFINE PATH... Read More

A VSAM file that has never contained a record is treated as unavailable. Attempting to open for input will fail. An empty file can be opened for output only. When you open for output, COBOL will write a dummy record to the file & then delete it... Read More

Unique Case: 5 + ( alt-key-length + primary-key ) Nonunique Case: 5 + ( alt-key-length + n * primary-key ) where n = # of duplicate records for the alternate key ????Any one who knows - can you explain ? Read More

Sequential(QSAM) files can be created on tape while ESDS files cannot. Also, you can have ALTINDEX for an ESDS while no such facility exists for QSAM files. Read More

No, the DCB of the model dataset can be overridden when you allocate new versions. Read More

base-file-name.GnnnnnV00 where nnnn= generation number (upto 255). nnnn will be 0000 for the 1st generation. Read More

Give (+1) as the generation number, give (new,catlg) for disp, give space parameter, can give the dcb parameter if you want to override the dcb of the model dataset. Read More

The average record length must be less than or equal to the maximum record length. The Maximum Record Length is 2046. Read More

ESDS: Entry Sequence Data Set KSDS: Key Sequence Data Set RRDS: Relative Data Set Read More

Well, it depends on whether the data will be accessed directly or sequentially. for direct access use small ci for sequential access use larger ci. Read More

Control Interval is analogous to a physical block for QSAM files. It is the unit of i/o. Must be between 512 bytes to 32 k. Usually either 2K or 4K. A larger control interval increases performance for sequential processing while the reverse is true... Read More

Using the REPRO command. Read More

Use the DEFINE GENERATIONDATAGROUP command. In the same IDCAMS step, another dataset must be defined whose DCB parameters are used when new generations of the GDG are created. This dataset is known as the model dataset. The ds name of this model... Read More

Use the LISTCAT command. Read More

Run VERIFY. Read More

Coded in the DEFINE as FREESPACE(ci ca) where ci is the percentage of each control interval to be left free for insertions, ca is the percentage of control intervals in each control area to be left empty. Read More

DEFINE CLUSTER(cluster name) with the INDEXED parameter. Also specify the ds name for the DATA component & the ds INDEX component. Other important parms are RECORDSIZE, KEYS, SHAREOPTIONS. Read More

Duplicate alternate key . Happens on both input and output operation Read More

Use GDG name(-2). Read More