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
 
Sort to get DSN statistics?

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

New User


Joined: 02 Mar 2009
Posts: 12
Location: India

PostPosted: Wed Nov 04, 2009 1:41 pm    Post subject: Sort to get DSN statistics?
Reply with quote

Hi All,

There are some files transferred from mainframe
A DSN would XXXX.FILES.TRANSFERED will have the DSN’s that are transferred.

XXXXX.TEST.FILE1
XXXXX.TEST.FILE2
XXXXX.TEST.FILE3
XXXXX.TEST.FILE4
XXXXX.TEST.FILE5
XXXXX.TEST.FILE6
XXXXX.TEST.FILE7
XXXXX.TEST.FILE8
XXXXX.TEST.FILE9


Is it possible to write a statistics file using SORT in the format? (get LRECLs of each file?)
Bytes- LRECL* count

FILE NAME XXXXX.TEST.FILE1 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn
FILE NAME XXXXX.TEST.FILE2 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn
FILE NAME XXXXX.TEST.FILE3 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn
FILE NAME XXXXX.TEST.FILE4 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn
FILE NAME XXXXX.TEST.FILE5 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn
FILE NAME XXXXX.TEST.FILE6 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn

Please advice.

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

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Wed Nov 04, 2009 1:58 pm    Post subject:
Reply with quote

Can you explain exactly what it is that you want to know, and the reason why and maybe the forum members can come up with proven methods.
Back to top
View user's profile Send private message
sarat6900

New User


Joined: 02 Mar 2009
Posts: 12
Location: India

PostPosted: Wed Nov 04, 2009 3:25 pm    Post subject:
Reply with quote

Hi,

Is it possible to retrieve the LRECL info of the DSN through sort?

The input file would have the DSN's transferred.

The output file is a sequential report of the transferred files

FILE NAME XXXXX.TEST.FILE1 LRECL nnnn COUNT 00000nnnn BYTES 0000000nnnnn

Please let me know if the requirement is clear.

Thanks,
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Nov 04, 2009 11:06 pm    Post subject:
Reply with quote

Quote:
Is it possible to retrieve the LRECL info of the DSN through sort?


Sort products do NOT have any built-in features for displaying the LRECL.
(The LRECL is displayed in the sort messages, but I don't think that will help for what you're trying to do.)
Back to top
View user's profile Send private message
sarat6900

New User


Joined: 02 Mar 2009
Posts: 12
Location: India

PostPosted: Mon Nov 09, 2009 10:38 am    Post subject:
Reply with quote

Thank You Frank.

Is there another way to implement this.
I understand Rexx solution for this would consume more CPU than Cobol.

Cobol processing would involve a lot of duplicate processing ( same process repeated for all the files transferred).

Is there any alternate solution for this?

Thanks,
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: Mon Nov 09, 2009 8:30 pm    Post subject:
Reply with quote

Hello,

Anything done will need the "same process repeated for all the files transferred". . . If you want info for 1000 files, you need to "look at" 1000 files. . .

This is mostly unneeded info (IMHO as i've been involved with more than 100 different systems that send/receive many files and not one of them needs this).

REXX is probably the worst possible "solution".

I suspect that the transfer provides the info as to record counts and byte counts as well as the dataset name. Why does lrecl even matter?
Back to top
View user's profile Send private message
Ronald Burr

Active User


Joined: 22 Oct 2009
Posts: 293
Location: U.S.A.

PostPosted: Mon Nov 09, 2009 9:15 pm    Post subject:
Reply with quote

If you are looking to validate successful file transfers, you might want to think twice about using a process that counts bytes and checks LRECLS - because, depending on the protocols used the LRECL and number of actual bytes contained in a Sending File and that of the Receiving File may not match.

For example, you can Send a Fixed Length Mainframe File to a (truncated(with trailing spaces stripped), variable length ) PC file with CR/LF codes or send a (variable length, no trailing spaces) CR/LF coded PC file to a Fixed Length Mainframe File (with trailing spaces generated to fill out the fixed length).

As a prior responsant suggested, explain what the objective is, and don't try to limit responses to how to satisfy the requirements of the method you have pre-determined is the only way to achieve the objective. Many here have probably already formulated methods to achieve your objective in a much more robust manner.
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 BUT RETAIN HIGHEST VALUE ON NON-... leondan22 DFSORT/ICETOOL 2 Thu Dec 14, 2017 8:13 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts JOINKEYS Paired and Unpaired Sort on ... MFwhiz DFSORT/ICETOOL 7 Tue Nov 07, 2017 2:46 am
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am

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