How to find the number of records in VSAM file Using REXX

arvindkamboj · New User Joined: 09 Jul 2007 Posts: 2 Location: pune

Hi

I need a rexx program to find the nummer of records in a vsam file
i can use QUEUED for flat files
But what to use for KSDS files

Please help me to find out

ofer71 · Posted: Tue Aug 07, 2007 1:45 pm

Invoke LISTCAT internally, then parse the output.

O.

expat · Posted: Tue Aug 07, 2007 2:21 pm

Or attempt to use CSI

However, VSAM records are usually only updated when the cluster is closed, so if you have a cluster which is almost permanently open, to something like a CICS region, the statistics may be inaccurate.

You could try a VERIFY before the LISTCAT, but it may fail because the cluster is open.

TizMe · New User Joined: 05 Jan 2006 Posts: 72

Even if you successfully VERIFY, the output from a LISTCAT cannot be relied upon. If any VSAM updating program abends without closing the file these figures will be incorrect.

This is because the record counts in the catalog are only updated when the file is closed.