To Find Number of Records of Vsam File

suresh_u · New User Joined: 31 Jan 2004 Posts: 8

Hi Friends All,

I want to know how to find out total number of records present in the vsam file(KSDS).We don't have file aid utility.
Is it possible by some other means to find it out?

Thanks

Suresh,
Pune.

sandip_datta · Posted: Sun Feb 01, 2004 1:36 pm

Hi Suresh,

If you copy that VSAM file to a temp file using REPRO command then at the SYSOUT you will get the number of records copied. There are lot other ways to find it out. Other's comments are welcome.

Regards,
Sandip.

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

Hello suresh_u,

If you have file-aid in your shop..

go to File-Aid
Option 3.5

And type in your vsam file name and press enter

It will give you the details of your dataset including NUMBER OF PRIME RECORDS.

Hope this helps

Regards

Mayuresh Tendulkar

sandip_datta · Posted: Tue Feb 03, 2004 12:47 pm

Dear Mayuresh/Suresh ,

Suresh don't have file-aid at his shop according to his first post. But LISTCAT will also give the number of records in the VSAM.

Regards,
Sandip.

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

Oh! my mistake,

I did not read the post completely.

Regards

Mayuresh Tendulkar

suresh_u · New User Joined: 31 Jan 2004 Posts: 8

Hi Friends,
Thanks for your suggestions.

Regards,
Suresh.

ajayvamsi · New User Joined: 21 Jul 2005 Posts: 56 Location: Hyderabad

Hi,
U can use file-aid option 8 just specify ur dataset name and type TALLY u will be able to get the number of records once this is done type END to come out of that screen.

jagankallis · New User Joined: 28 Jun 2006 Posts: 29 Location: DUISBURG

Hi Friends,

Can we submit a jcl and find the % of space utilization in VSAM file similar to the FILEAID 3.5 option? Please let me your valuable suggestions.
If this is possible we can find the IMS and DB2 tablespace % of space free. Hence we can know in advance the space needs to be increase or not.

mfibm · New User Joined: 12 Sep 2006 Posts: 13

hi all........

after entering into screen you can see all the vsam files and other etc......
in front of vsam file type.......print char ids(/)........
the nxt screen will show you the count and all.........

may work..........try and let me know.........

LIkki