Sort to get DSN statistics?

sarat6900 · New User Joined: 02 Mar 2009 Posts: 12 Location: India

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,

expat · Posted: Wed Nov 04, 2009 1:58 pm

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.

sarat6900 · New User Joined: 02 Mar 2009 Posts: 12 Location: India

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,

Frank Yaeger · Posted: Wed Nov 04, 2009 11:06 pm

sarat6900 · New User Joined: 02 Mar 2009 Posts: 12 Location: India

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,

dick scherrer · Posted: Mon Nov 09, 2009 8:30 pm

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?

Ronald Burr · Posted: Mon Nov 09, 2009 9:15 pm

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.