Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
To Find Number of Records of Vsam File

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
suresh_u

New User


Joined: 31 Jan 2004
Posts: 8

PostPosted: Sat Jan 31, 2004 4:45 pm    Post subject: To Find Number of Records of Vsam File
Reply with quote

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. icon_rolleyes.gif
Back to top
View user's profile Send private message

sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Sun Feb 01, 2004 1:36 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Tue Feb 03, 2004 12:28 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 151
Location: Tokyo, Japan

PostPosted: Tue Feb 03, 2004 12:47 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Tue Feb 03, 2004 12:58 pm    Post subject:
Reply with quote

Oh! my mistake,

I did not read the post completely.

Regards

Mayuresh Tendulkar
Back to top
View user's profile Send private message
suresh_u

New User


Joined: 31 Jan 2004
Posts: 8

PostPosted: Tue Feb 03, 2004 2:19 pm    Post subject:
Reply with quote

Hi Friends,
Thanks for your suggestions.

Regards,
Suresh. icon_biggrin.gif
Back to top
View user's profile Send private message
ajayvamsi
Currently Banned

New User


Joined: 21 Jul 2005
Posts: 56
Location: Hyderabad

PostPosted: Mon Sep 11, 2006 3:22 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
jagankallis
Warnings : 1

New User


Joined: 28 Jun 2006
Posts: 29
Location: DUISBURG

PostPosted: Thu Sep 14, 2006 12:39 am    Post subject: Re: To Find Number of Records of Vsam File
Reply with quote

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.
Back to top
View user's profile Send private message
mfibm

New User


Joined: 12 Sep 2006
Posts: 13

PostPosted: Thu Sep 14, 2006 10:18 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us