Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Managing VSAM Data Definitions : Data Set Requirements

Data Set Requirements
KSDS Requirements
Note the following when defining fields for the KSDS data set:
To access a VSAM file by an alternate index, define the alternate index as the primary key in the TIBCO Object Service Broker table and specify the alternate index path as the data set name.
Updates to rows with duplicate secondary indexes must be done using a definition that has the primary key set to the VSAM primary key.
The architecture of KSDS type files specifies that the initial record can only be added by a sequential write operation. There are two ways to handle the initialization of a VSAM KSDS file:
The IDCAMS utility can populate the data set using the REPRO statement. This can be done in the same job that initializes the VSAM KSDS data set.
At least one record must then be inserted into the table. When a record is inserted, the Load option can be set to N, if desired.
ESDS Requirements
Note the following when defining fields for the ESDS data set:
The primary key field must be a 4-byte binary. This field represents a relative byte address (RBA). It specifies the relative offset in the data set of the record being accessed. The first record has an RBA of 0.
Access by alternate index can be accomplished by defining the secondary index as the primary key in TIBCO Object Service Broker and using the secondary index path as the data set name.
RRDS Requirements
Note the following when defining fields for the RRDS data set:
The primary key field must be a 4-byte binary. This field represents a record number that identifies each record in the data set. The first record has a record number of at least 1.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved