Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

LRECL and Record count of file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
shankarm

Active User


Joined: 17 May 2010
Posts: 175
Location: India

PostPosted: Wed Oct 09, 2013 3:56 pm    Post subject: LRECL and Record count of file
Reply with quote

Hi,

I am looking for a batch process which will get me the number of records and LRECL of files.

I have 6000 files approximately. The files can be tape or DASD/ VB or FB. My requirement is to find the LRECL and record count. Is it possible in ICETOOL? please advise.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Wed Oct 09, 2013 4:05 pm    Post subject: Reply to: LRECL and Record count of file
Reply with quote

shankarm,

Unless you have changed jobs recently you have SyncSort. SyncTool is probably aliased at your site to ICETOOL. If you get ICE messages rather than SIT messages from an ICETOOL step, let me know and I'll move it back to DFSORT. For now it is taking a hike to JCL...
Back to top
View user's profile Send private message
shankarm

Active User


Joined: 17 May 2010
Posts: 175
Location: India

PostPosted: Wed Oct 09, 2013 4:14 pm    Post subject:
Reply with quote

We do have syncsort. is it possible in syncsort?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Wed Oct 09, 2013 4:29 pm    Post subject: Reply to: LRECL and Record count of file
Reply with quote

You have told us how you have decided to service a requirement, but what is the actual requirement. The LRECL of a VB just tells you how big the largest record can be. No record on the file need be that size.

Just counting records on the files gives you what? What is going to be done with the answers?

ICETOOL/SYNCTOOL has a COUNT operator. Counting records in itself is no problem. There is, however, no magic which counts 6.000 datasets for you. You need JCL and Control Cards for all 6,000.

If you can explain a bit more we can make some suggestions.
Back to top
View user's profile Send private message
shankarm

Active User


Joined: 17 May 2010
Posts: 175
Location: India

PostPosted: Wed Oct 09, 2013 4:37 pm    Post subject:
Reply with quote

We need the number of records in these files for an estimation (Mainframe migration project).

I understand that we have count operator. Do we need seperate JCL's for these? 6000 jcl's?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Oct 09, 2013 4:46 pm    Post subject:
Reply with quote

shankarm wrote:
We need the number of records in these files for an estimation (Mainframe migration project).

I understand that we have count operator. Do we need seperate JCL's for these? 6000 jcl's?

A standard confusion among software engineers.

You'll need 6,000 steps. A job can have up to 255 steps in it (although I wouldn't try to shoehorn the maximum steps into every job). A PS data set or member of a PDS containing JCL can have multiple jobs in it.
Back to top
View user's profile Send private message
shankarm

Active User


Joined: 17 May 2010
Posts: 175
Location: India

PostPosted: Wed Oct 09, 2013 4:54 pm    Post subject:
Reply with quote

got it.. icon_biggrin.gif
I will strt creating JCL's..

Just a thought:

So syncsort does not allow us to use multiple count() in one step?
Example:-
Count(sortin1)
Count(sortin2)
Count(sortin3).. Etc..

Where sortin is the DD name.. Do we have a way? I didnt see it in the syntax though.. Just wanted to cofirm with you guys as i might have missed..
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Oct 09, 2013 4:56 pm    Post subject: Reply to: LRECL and Record count of file
Reply with quote

why not process the dcollect and the listcat data ?

for an estimate the used % should be a fair approximation
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Oct 09, 2013 5:00 pm    Post subject:
Reply with quote

shankarm wrote:
got it.. icon_biggrin.gif
I will strt creating JCL's..

If you have or can easily get a list of data sets, it might be quicker and easier to write a programette -- Rexx, COBOL, or even another Syncsort job -- to generate JCL with those 6,000 Synctool steps.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Wed Oct 09, 2013 5:02 pm    Post subject: Reply to: LRECL and Record count of file
Reply with quote

Yes, it can be done like you outline with SyncTool. SyncSort provide no documentation for SyncTool so you have to show initiative.

I don't know what the maximum number of COUNT operators you can have in a single step is, but if nothing else it is going to be limited by the size of your TIOT. I would imagine you can get 1500 DDs into a single JOB, so you could do it in four shots. Almost.

The thing is, if you cram everything together you're going to have to do something to tie DSN/LRECL and COUNT together.

If you do them individually, 6000 steps, it'll be easier to grasp any one of them - but again you'll have a problem with 6000 seperate JOBs to look at, particularly is someone wants some printed results :-)

If you do 4 * 1500 DSNs, you can look to "automate" the collation of the details by extracting from the spool output and "parsing".
Back to top
View user's profile Send private message
shankarm

Active User


Joined: 17 May 2010
Posts: 175
Location: India

PostPosted: Wed Oct 09, 2013 5:26 pm    Post subject:
Reply with quote

Great. This is what i wanted to hear. I will try the options..
Quote:
Yes, it can be done like you outline with SyncTool.
Back to top
View user's profile Send private message
Pete Wilson

Active User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Thu Oct 10, 2013 2:39 pm    Post subject:
Reply with quote

Are these all DASD based files? If they are, are some migrated (archived)? Are some TAPE based?

This needs some consideration because it could impact DFHSM, or whatever archiving tool you have.

It could also impact your TAPE subsystem.

A job with ~1500 steps, depending on the files sizes and the media they're on, could be VERY long running, and may require a TIME= parameter on the jobcard otherwise it may abend with S322.

It would be worth sorting out the list of datasets by certain criteria and setting up jobs accordingly.

e.g.
- Have one or more jobs specifically for TAPE files.
- Have one or more jobs for MIGRATED (archived) files, which in turn are sorted into date ranges. For example, start with the most recent files so they're processed before they get migrated, and work back to the oldest files. This will help streamline the recalls.
- Possibly split the jobs for DASD based files according to size, with a job for large files and one for smaller files.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us