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
 

 

To find the number of records in input from DFSORT sysout

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

New User


Joined: 24 Feb 2008
Posts: 48
Location: Kolkata

PostPosted: Tue Mar 10, 2009 12:10 pm    Post subject: To find the number of records in input from DFSORT sysout
Reply with quote

Hi,

I have a situation like follows -

I am using DFSORT. In SORTIN i have two files. Now I don't have backup of these two files and the job i am looking at is run long back. so i have the SYSOUT of DFSORT to find out how many records were in each file. Is it possible.

Only i could find total number of records SORTED. but the number of records in individual files is the need.

Thanks !!
Abhishek
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Tue Mar 10, 2009 1:48 pm    Post subject:
Reply with quote

Hi,

you will need to read each file individually, you can try this
Code:
//STEP0001 EXEC PGM=ICETOOL                               
//IN1      DD DSN=INPUT1,DISP=SHR                         
//IN2      DD DSN=INPUT2,DISP=SHR                         
//TOOLMSG  DD SYSOUT=*                                   
//DFSMSG   DD SYSOUT=*                                   
//TOOLIN   DD *                                           
  COUNT FROM(IN1)                                         
  COUNT FROM(IN2)                                         
/*                                                       

or you can read 1 file only and then subtract this figure from your combined figure to work out the number of records of the other file.


Gerry
Back to top
View user's profile Send private message
abhishek mitra

New User


Joined: 24 Feb 2008
Posts: 48
Location: Kolkata

PostPosted: Tue Mar 10, 2009 5:21 pm    Post subject:
Reply with quote

gcicchet wrote:
Hi,

you will need to read each file individually, you can try this
or you can read 1 file only and then subtract this figure from your combined figure to work out the number of records of the other file.


Gerry



Hi Gerry,

Thanks for your reply, but the problem still persists as i have lost those files. Thats why i wrote that "I dont have the backup of these files" in my previous post.

Thanks
Abhishek
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Tue Mar 10, 2009 5:45 pm    Post subject:
Reply with quote

Hi,

sorry I missed the
Quote:
I don't have backup of these two files
. icon_redface.gif


You might as well take a stab in the dark as we'll never know the correct answer.


Gerry
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Mar 10, 2009 8:16 pm    Post subject:
Reply with quote

Hello,

There is information in the smf records that might be used to determine the approximate size of the files used in this execution.

Suggest you talk with your storage admins for help finding the i/o counts for these 2 files in that particular job.
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 what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts GDG version number PANDU1 JCL & VSAM 4 Sat Mar 04, 2017 8:28 pm


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