IDCAMS Programs VSAM Training Class 05 IDCAMS commands

IDCAMS Programs VSAM Training Class 05

IDCAMS commands § § § § § DEFINE (cluster, alternate index , GDG , . . ) DEFINE PATH BUILDINDEX ( alternate index) IMPORT /EXPORT (cluster) LISTCAT (catalog entries) PRINT (cluster) VERIFY (cluster) DELETE (cluster) ALTER (entry name)

LISTCAT command § LISTCAT’s basic function is to list information about VSAM and non-VSAM objects that have entries in a VSAM catalog. § With LISTCAT , we can also view dataset attributes, password and security information, usage statistics, space allocations information, creation and expiration dates and much more. § LISTCAT CATLOG(PRGMR) LVL(A 2000) will list all entries in the PRGMR catalog with the high level qualifier A 2000. LISTCAT ENTRIES(A 2000. LIB. KSDS. CLUSTER) CLUSTER ALL will list the cluster attributes, History, cluster protection etc.

IDCAMS LISTCAT Example

OUTPUT In Spool

REPRO command § It performs three basic functions: 1. It loads an empty VSAM cluster with records. The data and index components (for a KSDS) are built automatically. 2. It creates a backup of a VSAM dataset on a physical dataset, and then restorers and rebuilds the VSAM using this dataset as input. 3. It merges the data from two VSAM datasets. REUSE sets the RBA zero whenever the dataset is opened for OUTPUT by an application program REPLACE While merging the REPLACE parameter is used to replace the duplicate primary keys(KSDS) or relative record numbers(RRDS)

IDCAMS REPRO Example

IDCAMS REPRO Example

IDCAMS REPRO Example

The EXPORT/IMPORT COMMNAD Export: § § It is an alternative to REPRO command Its advantages : Catalog information is exported along with the data Import: § § It is used to load in a dataset created by the EXPORT command. The dataset created by EXPORT command is not process able until it has gone through a corresponding IMPORT.

VERIFY command § The use of the VERIFY command is important for preserving data integrity. VERIFY verifies and updates the catalog with information from the physical end of the data in the cluster. § VERIFY can be used from TSO or within JCL. //SYSIN DD * VERIFY DATASET(A 2000. LIB. KSDS. CLUSTER) Using TSO VERIFY A 2000. LIB. KSDS. CLUSTER You can VERIFY a base cluster or an alternate index, But not the data or index components of the base cluster.

IDCAMS VERIFY Example

ALTER command § § Can be used to change certain attributes of a previously defined VSAM object. These objects include a base cluster and its data or index component, an alternative index cluster and its data or index component Some important Alterable attributes : ADDVOLUMES, BUFFERSPACE, OWNER, SHAREOPTIONS, FREESPACE, MASTERPW REMOVEVOLUMES, TO(date) / FOR(days) Unalterable attributes : CISZ, Cluster type, REUSE/NOREUSE, DATACLASS

DELETE command § It can be used to delete both VSAM and non-VSAM objects. Some important options for DELETE command: AIX GDG NVSAM PATH SPACE USERCATALOG ERASE SCRATCH PURGE DELETE (A 2000. LIB. KSDS 1. CLUSTER A 2000. LIB. KSDS 2. CLUSTER) +

IDCAMS DELETE Example

PRINT command § If we want to view our data, we can use the IDCAMS PRINT command to print it in one of several formats. Options available with PRINT command; CHARACTER/DUMP/HEX COUNT FROMADDRESS TOADDRESS FROMKEY TOKEY FROMNUMBER TONUMBER SKIP OUTFILE

IDCAMS PRINT Example

Thank You Polsani Anil Kumar