View previous topic :: View next topic
|
Author |
Message |
abhishek mitra
New User
Joined: 24 Feb 2008 Posts: 48 Location: Kolkata
|
|
|
|
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 |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
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 |
|
|
abhishek mitra
New User
Joined: 24 Feb 2008 Posts: 48 Location: Kolkata
|
|
|
|
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 |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
sorry I missed the
Quote: |
I don't have backup of these two files |
.
You might as well take a stab in the dark as we'll never know the correct answer.
Gerry |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|