Load Client Records in VSAM
Part Three - Challenge #06

Background:

You will learn how to load data into VSAM KSDS data set type

The term Virtual Storage Access Method (VSAM) applies to both a data set type and the access method used to manage various user data types. VSAM is a high performance data set type and popular for storing critical data.

VSAM is used primarily for applications. It is not used for source programs, JCL, or executable modules.

If you claim experience with z/OS, a perspective employee could potentially ask if you are familiar with VSAM during an interview. The challenge is an opportunity to say yes.

The challenge is to define a VSAM KSDS and load client data from a sequential data set.


VSAM Explained

Review of the documentation below is NOT required to complete the challenge.

However, the documenation is excellent for those wanting to understand how VSAM works and the associated high performance characteristics.


VSAM KSDS Explained

KSDS is defined with a unique key for every data record. The key value makes KSDS different from the other VSAM data types.

Review of the documentation below can assist with challenge completion.


Challenge:

Define the VSAM KSDS

The following Record Layout observations are mandatory to complete the challenge:

  • VSAM KSDS KEY is the Unique Account Number
  • End Column is 170 for all records

The challenge is to define and load data into a VSAM KSDS where you need to determine the correct DEFINE parameters for the VSAM type, key, and recordsize

  1. Edit z#####.jcl partitioned data set member defvsam
  2. Replace @TYPE with VSAM DEFINE parameter to define VSAM KSDS type
  3. Replace @LENGTH,@OFFSET to specify VSAM KSDS key
  4. Replace @MIN,@MAX to specify VSAM KSDS minimum and maximum record length
  5. Submit and review output

If the JCL job is successful, then proceed to Actions to take to complete the challenge.
If the JCL job is unsuccessful, identify and correct the problem.


Actions to take to complete the challenge

The SYSTSPRT output should have a REC-TOTAL greater than 0 for the DATA component of the VSAM cluster
and REC-TOTAL of 1 for the INDEX component of the VSAM cluster.

If SYSTSPRT DDNAME has the newly created data set name attributes,
then use XDC to print SYSTSPRT DDNAME content
Write the SYSTSPRT output into Z#####.P3.OUTPUT data set name
as member name #06

Reminder - Replace Z##### with your ID

Feel free to check your P3.OUTPUT(#06) contains attributes of Z#####.CLIENT.CLUSTER, then move on to the next challenge!

Next: Challenge #07