TIP # 059
One can speed up applications greatly by using memory to cut I/O when dealing with VSAM
For this VSAM Buffers can be enlarged.
In the DD statement code AMP parameters = BUFNI(index), BUFND(data), BUFSP ( amount of
Increase number of Data buffers (BUFND) for sequential access
Increase number of Index buffers (BUFNI) for random access
TIP # 060
IDCAMS Utility can't be executed without 2 DD Statements.
They are SYSPRINT and SYSIN.
TIP # 061
We know that FREESPACE(100,100) specification causes one record to be written for each
Control interval, and one Control Interval would be written for each control area. But do you
VSAM will always load the first record before taking FREESPACE option into consideration!!!
TIP # 062
DEFINE PATH command creates an alias for the VSAM base cluster
DEFINE ALIAS command creates an alias for non-VSAM datasets
TIP # 063
CICS, DB2, IMS can process records in existing VSAM datasets but can't create the dataset.
Even you can process VSAM data sets in COBOL programs only
after you create them with access method services.
TIP # 064
How can I specify dummy VSAM dataset in a JCL?
Code AMP=’AMORG’ . This parameter tells the OS to treat the file as VSAM file.
//NOVSAMIO DD DUMMY,AMP=’AMORG’
TIP # 065
I want to process a KSDS thru an alternate key. Now what are the 5 IDCAMS commands that must be
executed before the records in a KSDS can be processed thru an alternate key?
1. DEFINE CLUSTER
2. REPRO (the base cluster must be non-empty KSDS)
3. DEFINE ALTERNATEINDEX
4. DEFINE PATH
The first 3 IDCAMS commands should be executed in the above-mentioned order.
The last 2 IDCAMS can be done in any order.
TIP # 066
I want to make my VSAM dataset read-only. How can I do it?
By using INHIBIT along with ALTER command
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
Notice that the ALTER command is used with DATA and INDEX and not with the cluster.
TIP # 067
VSAM equivalent of temp dataset is to create VSAM file with REUSE option. A dataset created with
REUSE can be treated as a new dataset at any subsequent time.
TIP # 068
How should be VSAM file defined in order that it can be accessed both in CICS and in BATCH
Define as SHAREOPTION (2,3)
TIP # 069
While designing VSAM files, what’s the best way to choose Control Interval (CI) size for the data and the
Well, it depends on whether the data will be accessed directly or sequentially.
For Direct access use small CI
For Sequential access use Lager CI