Tags

, , , , , , , , , , , , ,

——————————————————————————————————————–
TIP # VSAM

Performance Tuning
One can speed up applications greatly by using memory to cut I/O when dealing with VSAM
datasets.
For this VSAM Buffers can be enlarged.
In the DD statement code AMP parameters = BUFNI(index), BUFND(data), BUFSP ( amount of
virtual storage)
Increase number of Data buffers (BUFND) for sequential access
Increase number of Index buffers (BUFNI) for random access

——————————————————————————————————————–
TIP # VSAM

IDCAMS Utility can’t be executed without 2 DD Statements.
They are SYSPRINT and SYSIN.

——————————————————————————————————————–
TIP # VSAM

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
know why?
VSAM will always load the first record before taking FREESPACE option into consideration!!!

——————————————————————————————————————–
TIP # VSAM

DEFINE PATH command creates an alias for the VSAM base cluster
DEFINE ALIAS command creates an alias for non-VSAM datasets

——————————————————————————————————————–
TIP # VSAM

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 # VSAM

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 # VSAM

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
5. BLDINDEX
The first 3 IDCAMS commands should be executed in the above-mentioned order.
The last 2 IDCAMS can be done in any order.

——————————————————————————————————————–
TIP # VSAM

I want to make my VSAM dataset read-only. How can I do it?
By using INHIBIT along with ALTER command
e.g.,
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
ALTER –
SECRET.KSDS.DATA –
INHIBIT
ALTER –
SECRET.KSDS.INDEX –
INHIBIT
/*
//
Notice that the ALTER command is used with DATA and INDEX and not with the cluster.

——————————————————————————————————————–
TIP # VSAM

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 # VSAM

How should be VSAM file defined in order that it can be accessed both in CICS and in BATCH
environment?
Define as SHAREOPTION (2,3)

——————————————————————————————————————–
TIP # VSAM

While designing VSAM files, what’s the best way to choose Control Interval (CI) size for the data and the
index?
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

——————————————————————————————————————–

Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
SAS – SAMPLE PROGRAM
CA DISPATCH – Useful Commands
Locate the INVALID data in a field using FILE AID
File-Aid Relational Operators, Data Types
Xpediter – Batch Setup
FILE AID – VIEW TIP
FILEAID TIPS
EDIT PDS USING FILE-AID – FAST MODE
VSAM – KEYS
Comparison of ESDS, KSDS, RRDS, VRRDS, and linear data sets
VSAM OPEN CLOSE I/O RETURN CODES
VSAM INTERVIEW QUESTIONS
VSAM TIPS
Advertisements