Hello everyone,
I believe I simply cannot do this using DFSORT, but I wanted to confirm with
the wider/wiser team.
I have create a little DFSORT Utility to clone JCL/PROCs/Control Statement
etc... by copying selected members from a Library to another Library with
little Market changes
Use REXX REVERSE function.
Then parse out the first value.
Reverse it again.
On Sat, May 23, 2020 at 5:57 AM Billy Ashton wrote:
> Hi folks! This should be easy, but it escapes me...
>
> I have an 80-byte LRECL list of filenames (starting in col 1, varying
> lengths), and I need to capture just
REV = REVERSE(PRODUCTION.CONTROL.VSAM.DATABASE.INDEX)
PARSE VALUE REV WITH LASTNODE '. ' .
LASTNODE = REVERSE(LASTNODE)
On Sat, May 23, 2020 at 7:16 AM Wayne Bickerdike wrote:
> Use REXX REVERSE function.
> Then parse out the first value.
> Reverse it again.
>
>
> On Sat, May 23, 2020 at
Billy,
Use the following DFSORT JCL which will give you the desired results
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
A.B.C.D.E
A.B.C.D.EF
A.B.C.D.EFG
A.B.C.D.EFGH
A.B.C.D.EFGHI
A.B.C.D.EFGHIJ
A.B.C.D.EFGHIJK
A.B.C.D.EFGHIJKL
JOSEPH.CONTROL.SAMPLIB.JCL
S5.NPLEX1.PARMLIB PARMLIB
SYS4.UBS.EXEC EXEC
SYS3.UBS.A.B.C.D D
SYS3.UBS.ABC.C.DE DE
SYS3.UBS.AB.BC.DE DE
SYS3.UBS.AB.BC.XAB XAB
On Sat, May 23, 2020 at 7:42 AM Sri h Kolusu wrote:
> Billy,
>
> Use the following DFSORT JCL which will give you the desired results
>
> //STEP0100 EXEC PGM=
J EFGHIJ
> A.B.C.D.EFGHIJK EFGHIJK
> A.B.C.D.EFGHIJKL EFGHIJKL
> JOSEPH.CONTROL.SAMPLIB.JCL JCL
> PRODUCTION.CONTROL.VSAM.DATABASE.INDEX INDEX
> SYS1.PARMLIB PARMLIB
> SYS5.NPLEX1.PARMLIB PARMLIB
> SYS4.UBS.EXEC EXEC
> SYS3.UBS.A.B.C.D D
> SYS3.UBS.ABC.C.DE DE
> SYS3.UBS.
,51:47,7)),
IFTHEN=(WHEN=(45,1,CH,EQ,C'.'),BUILD=(01,44,51:46,8)),
IFTHEN=(WHEN=NONE,BUILD=(01,44,51:45,9,JFY=(SHIFT=LEFT)))
/*
Thanks,
Kolusu
DFSORT Development
IBM Corporation
--
For IBM-MAIN subscribe / signoff / a
Q,C'.'),BUILD=(01,44,51:47,7)),
> IFTHEN=(WHEN=(45,1,CH,EQ,C'.'),BUILD=(01,44,51:46,8)),
> IFTHEN=(WHEN=NONE,BUILD=(01,44,51:45,9,JFY=(SHIFT=LEFT)))
> /*
>
> Thanks,
> Kolusu
> DFSORT Development
> IBM Corporation
>
>
> ---
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: How to get last node in DFSORT
Hi folks! This should be easy, but it escapes me...
I have an 80-byte LRECL list of filenames (starting in col 1, varying
lengths), and I need to capture just the last node of the file, and
store it as a separate word on the
nt: 5/22/2020 8:44:32 PM
Subject: Re: How to get last node in DFSORT
Col 51...
For some reason the original question did not arrive in my inbox, but the
subsequent emails came in. So I did not see the actual requirement. So
adjusted the control cards to put the last node at position 51 now
On Sun, 24 May 2020 05:02:24 +, Seymour J Metz wrote:
>That sounds like a great use case for regexen.
>
Ob"When your favorite tool is a hammer ..."
>
>From: Billy Ashto
>Sent: Friday, May 22, 2020 3:57 PM
>
>I have an 80-byte LRECL list of filenames (st
du/~smetz3
From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of
Paul Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu]
Sent: Tuesday, May 26, 2020 2:51 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: How to get last node in DFSORT
On Sun, 24 May 2020 05:0
_
> From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of
> Paul Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu]
> Sent: Tuesday, May 26, 2020 2:51 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: How to get last node in DFSORT
>
> On Sun, 24 May 20
On Tue, 26 May 2020 19:42:31 +, Seymour J Metz wrote:
>Well, in this case the hammer is the reverse function;
>/\.([#$@[:upper:][:digit:]]{1,8})\n/, despite the awkward syntax, is still
>cleaner.
>
I was more thinking of the OP's requirement for DFSORT as the hammer.
A
ISTSERV.UA.EDU] on behalf of
Paul Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu]
Sent: Tuesday, May 26, 2020 6:02 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: How to get last node in DFSORT
On Tue, 26 May 2020 19:42:31 +, Seymour J Metz wrote:
>Well, in this case the
Discussion List On Behalf Of
Seymour J Metz
Sent: Tuesday, May 26, 2020 6:50 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: How to get last node in DFSORT
> And Sri's example contained a node longer than 8 bytes.
Well, if it were up to me z/OS would support cataloged data sets with longe
On Tue, 26 May 2020 22:50:10 +, Seymour J Metz wrote:
>
>Well, if it were up to me z/OS would support cataloged data sets with longer
>index levels, but circumstances being what they are I'd rather not parse them.
>Besides, they're only valid inside of apostrophes.
>
DISABLE(DSNCHECK) superse
> Empirically, I found I couldn't create a DSN starting with a period even
> within apostrophes. I don't know where this is documented.
Gil,
This works fine for me
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
dummyrecord
//SORTOUT DD PATH='/tmp/.create.dsn.with.period',
//
: Re: How to get last node in DFSORT
> Empirically, I found I couldn't create a DSN starting with a period even
> within apostrophes. I don't know where this is documented.
Gil,
This works fine for me
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
dummyrecord
//
___
> From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
> of Sri h Kolusu [skol...@us.ibm.com]
> Sent: Tuesday, May 26, 2020 9:49 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: How to get last node in DFSORT
>
> > Empirical
*Yakity Yak - The Coasters April 1958. *
I'm more of a Jeff Beck man. You're everywhere and nowhere baby.(Hi Ho
Silver Lining).
Or the inimitable Mrs Doubtfire (oooh, all over the place!).
--
For IBM-MAIN subscribe / signoff
On 2020-05-27 11:20 PM, Paul Gilmartin wrote:
From: Sri h Kolusu
Sent: Tuesday, May 26, 2020 9:49 PM
...
Empirically, I found I couldn't create a DSN starting with a period even
within apostrophes. I don't know where this is documented.
This works fine for me
...
//SORTOUT DD PATH='/tmp/.crea
On Wed, 27 May 2020 23:29:23 +0800, David Crayford wrote:
>>> //...
>> This moved me to look up DSN syntax in the JCL Ref.
>> It's chaos; I detect no plan in the design; it was put
>> together One Piece At A Time:
>> https://www.youtube.com/watch?v=060A15ELz00
>Agreed! I had to write a pro
I hate JCL!
On 2020-05-28 12:11 AM, Paul Gilmartin wrote:
On Wed, 27 May 2020 23:29:23 +0800, David Crayford wrote:
//...
This moved me to look up DSN syntax in the JCL Ref.
It's chaos; I detect no plan in the design; it was put
together One Piece At A Time:
https://www.youtube.com/w
2020 8:20 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DSN SYNTAX (was: ... last node in DFSORT)
On Wed, 27 May 2020 03:13:08 +, Seymour J Metz wrote:
>PATH ¬= DSN
>
But he did include the substring ".dsn" in the pathname.
>
>From: Sri
9:11 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: DSN SYNTAX (was: ... last node in DFSORT)
On Wed, 27 May 2020 23:29:23 +0800, David Crayford wrote:
>>> //...
>> This moved me to look up DSN syntax in the JCL Ref.
>> It's chaos; I detect no plan in the design; it was
t: Re: DSN SYNTAX (was: ... last node in DFSORT)
Well, it was designed one piece at a time. First came DSN's and VTOC's; then
came catalogs; then came UNIX filenames.
Charles
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of
: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: DSN SYNTAX (was: ... last node in DFSORT)
Not an excuse but I bet they mean they don't validate the length of the node
names. DSN='MYLONGNODE.WHATEVER' is valid.
Charles
-Original Message-
From: IBM Mainframe Discussion List [
Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu]
Sent: Wednesday, May 27, 2020 11:20 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DSN SYNTAX (was: ... last node in DFSORT)
On Wed, 27 May 2020 03:13:08 +, Seymour J Metz wrote:
>PATH ¬= DSN
>
But he did include the substring ".
metz3
From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of
Paul Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu]
Sent: Wednesday, May 27, 2020 12:11 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: DSN SYNTAX (was: ... last node in DFSORT)
On Wed, 27 May 2020 23:29:23
On Wed, 27 May 2020 19:04:09 +, Seymour J Metz wrote:
>No, it is not correct; it does not check the lengths of quoted components, but
>it does check the total length.
>
IBM agrees, promptly:
IBM>Hello.
IBM>I am the writer for the z/OS JCL Reference documentation and have received
your comm
Hi folks!
Today's SORT challenge:
I am reading a temporary file for input, created in an earlier jobstep.
I am using
OPTION COPY
INCLUDE COND=.
INREC IFTHEN=
OUTREC ...,
IFTHEN=...
This keeps only the records I want to reformat, and creates a nice
output file of commands. However, in
Hi.
We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is
at position 65 of length 10 bytes . We need to pull those item nbrs
which has same UPC,Vendor nbr ,State Code but there is price difference. Could
anyone let me know how this to be done using dfsort.
Input file
ksbF6Q8SQ4oOvA
From: Tim Hare
To: IBM-MAIN@LISTSERV.UA.EDU
Date: 16/01/2018 16:09
Subject:DFSORT for HTTP logs - RECFM and BLKSiZE?
Sent by:IBM Mainframe Discussion List
I want to do some simple reporting on my HTTP logs (httpd-log.MMMdd).
I'm coding PARSE= to
Tim,
You follow the same rules for JCL. Something like this
//SORTIN DD PATH='your http log file',
// RECFM=??,LRECL=290,BLKSIZE=?,
//FILEDATA=TEXT,PATHOPTS=ORDONLY
Thanks,
Kolusu
DFSORT Development
IBM Corporation
From: Tim Hare
To:
it appears to be 'V' but I don't see where I could get BLKSIZE from
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Tim,
If the RECFM is V then you can LRECL+4 as the blocksize , or you can even
code BLKSIZE=27998
Thanks,
Kolusu
DFSORT Development
IBM Corporation
From: Tim Hare
To: IBM-MAIN@LISTSERV.UA.EDU
Date: 01/16/2018 10:09 AM
Subject:Re: DFSORT for HTTP logs - RECFM and BLKSiZE
IX files, code any RECFM, LRECL, and BLKSIZE acceptable to DFSORT.
The access method will reformat to match those attributes (adding RDWs or
padding with blanks), reporting an I/O error if any line exceeds LRECL.
(If the data lack newline characters (unlikely for a UNIX log file), you may
need t
On Tue, 16 Jan 2018 10:26:50 -0700, Sri h Kolusu wrote:
>
>If the RECFM is V then you can LRECL+4 as the blocksize , or you can even
>code BLKSIZE=27998
>
Likewise, you can use longest line + 4 (for RDW) as LRECL. But be generous:
tomorrow's log may contain a longer line.
Is there any reason no
I tried this, and ended with S001-1 abend
//SORTEXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTWK01 DD UNIT=DASD,SPACE=(CYL,(500,500))
//SORTIN DD PATHOPTS=ORDONLY,
Maybe I had LRECL too small? LRECL=512,BLKSIZE=32760 worked
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Gil,
OP mentioned his LRECL is 290, so with SDB the optimal blocksize is 27998
for an lrecl of 290
Thanks,
Kolusu
From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu>
To: IBM-MAIN@LISTSERV.UA.EDU
Date: 01/16/2018 11:30 AM
Subject: Re: DFSORT for HTT
None of these should need JCL specification to read an existing dataset.
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Sri h Kolusu
> Sent: Tuesday, January 16, 2018 8:36 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> S
>>>None of these should need JCL specification to read an existing
dataset.
Probably OP's input file is NOT created on z/OS. So he needs to supply the
DCB parameters to read the dataset.
Thanks,
Kolusu
DFSORT Development
IBM Corporation
From: "Gibney, Dave
On Tue, 16 Jan 2018 14:18:06 -0700, Sri h Kolusu wrote:
None of these should need JCL specification to read an existing
>dataset.
>
>Probably OP's input file is NOT created on z/OS. So he needs to supply the
>DCB parameters to read the dataset.
>
Likewise if the data set is a UNIX file crea
.UA.EDU
Date: 01/16/2018 02:29 PM
Subject: Re: DFSORT for HTTP logs - RECFM and BLKSiZE?
Sent by:IBM Mainframe Discussion List
On Tue, 16 Jan 2018 14:18:06 -0700, Sri h Kolusu wrote:
>>>>None of these should need JCL specification to read an existing
>dataset.
>
It may not be the case that it just works, but it should.
No matter where the dataset was created, it must exist in a way that is
accessible on z/OS, or they wouldn't be trying to process it via DFSORT.
And, by existing, all required attributes to successfully process it should be
derivab
On Tue, 16 Jan 2018 21:48:14 +, Gibney, Dave wrote:
>It may not be the case that it just works, but it should.
>
>No matter where the dataset was created, it must exist in a way that is
>accessible on z/OS, or they wouldn't be trying to process it via DFSORT.
>
&g
I do believe that I should be able to point DFSORT at any file (Unix or not)
where performing the functions of DFSORT make sense, and not be required to
specify in JCL the physical attributes of LRECL, RECFM and most especially
BLKSIZE. These should all be derivable from the physical dataset
These are on z/OS in Unix Systems Services, the logs for the IMWHTTPD web
server. I tried without DCB but I believe some DCB must be supplied , as
someone said the access method will deal with the Unix-to-record stuff. I
thought my LRECL was 290, but things did not work until I increased it.
On Tue, 16 Jan 2018 23:45:34 +, Gibney, Dave wrote:
>I do believe that I should be able to point DFSORT at any file (Unix or not)
>where performing the functions of DFSORT make sense, and not be required to
>specify in JCL the physical attributes of LRECL, RECFM and most e
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Paul Gilmartin
> Sent: Tuesday, January 16, 2018 4:21 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: DFSORT for HTTP logs - RECFM and BLKSiZE?
>
> On T
> On Jan 16, 2018, at 3:48 PM, Gibney, Dave wrote:
>
> It may not be the case that it just works, but it should.
>
> No matter where the dataset was created, it must exist in a way that is
> accessible on z/OS, or they wouldn't be trying to process it via DFSORT.
>
>I do believe that I should be able to point DFSORT at any file (Unix or not)
>where performing the functions of DFSORT make sense, and not be required to
>specify in JCL the physical attributes of LRECL, RECFM and most especially
>BLKSIZE. These should all be derivable from
Dirceu Bimonti Ivo,
DFSORT can convert the SMF date and time formats and even perform time
arithmetic. Is IMSLOG data similar to SMF data? Can you send me a sample
input data may be 10 records (to my personal email id) which would save
the recreation of input data. Also show a sample of
Dirceu Bimonti Ivo,
I sent you the JCL which meets your requirements along with time
arithmetic and handle dates to subtract a day if the time - offset results
in a negative number.
Please let me know if you have any more questions.
Thanks,
Kolusu
DFSORT Development
IBM Corporation
IBM
[Default] On 25 Sep 2020 09:54:45 -0700, in bit.listserv.ibm-main
ron5...@gmail.com (Ron Thomas) wrote:
>Hello
>
>We are using DFSORT utility to extract the latest record for a store/item/po
>and below is the sample file
>
>item_nbr| Store_nbr|Po_nbr|item_date|mode|
>
> Here we need to pull the 2'nd record to the Output as this is the
> latest date .
Ron,
Use the following DFSORT/ICETOOL JCL which will give you the desired
results
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
+1+
not have the
function, I would say to find one that does.
Hope that helps
Lizette
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of Ron
Thomas
Sent: Friday, September 25, 2020 9:55 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DFSort to pull the latest record date
Hello
> Given the obscurity of the control statements (quick tell me what
> field is 1,4,CH) why not write the thing in a language
Clark,
I have to respectfully disagree with you. The control statements for DFSORT
are not obscure and they are on the same level as following the
coding/syntax rul
>>If you can load to EXCEL - use its functions
Not all functions on the mainframe can do everything. You should look at
what makes sense. And if the tool you are comfortable in using, does not
have the function, I would say to find one that does.
Lizette,
EXCEL is limited to 1 million records.
Thanks a lot Kolusu for the help.. it worked like a charm!!
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: DFSort to pull the latest record date
>>If you can load to EXCEL - use its functions
Not all functions on the mainframe can do everything. You should look at
what makes sense. And if the tool you are comfortable in using, does not
have the function, I
Excel is awful to use. I would recommend doing as much as possible
elsewhere before loading into Excel. (Including what some of my code does:
Creating the CSV files in DFSORT.)
Cheers, Martin
Martin Packer
Systems Investigator & Performance Troubleshooter, IBM
+44-7802-245-584
e
On Fri, 25 Sep 2020 14:08:30 -0300, Clark Morris wrote:
>
>Given the obscurity of the control statements (quick tell me what
>field is 1,4,CH) why not write the thing in a language that has access
>to the descriptions of the fields being used? We are not in the era
>of 22K DOS360 partitions, 100K
On Fri, 25 Sep 2020 10:25:13 -0700, Sri h Kolusu wrote:
>
>... The control statements for DFSORT
>are not obscure and they are on the same level as following the
>coding/syntax rules for a programming language. For example COBOL, you
>would follow all the rules governing it. So
Sent: Friday, September 25, 2020 1:16 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] DFSort to pull the latest record date
[External Email: Use caution with links and attachments]
Why not load the data into a DB and use SQL or similar language?
If you have SAS - Max Min - functions
If
We are happy to announce DFSORT exploitation of Integrated Accelerator for
Z Sort is now available. The z15 provides a hardware accelerated approach
to sorting using a new CPU coprocessor that can be exploited by software
using the new SORTL instruction. By providing one sort accelerator per
core
y disagree with you. The control statements for DFSORT
>are not obscure and they are on the same level as following the
>coding/syntax rules for a programming language. For example COBOL, you
>would follow all the rules governing it. So why not do the same for DFSORT?
What field is 1,
f file you are reading via DFSORT.
As for offsets, COBOL calculates the offsets by copybook/mapping of the
file. Similarly you can use DFSORT symbols to specify the layout of the
file and you can refer the fields directly in the control cards. DFSORT
even provides a smart trick to convert you
On Tue, 13 Oct 2020 16:19:39 -0300, Clark Morris wrote:
>...
>What field is 1,4,CH? Why should an applications programmer have to
>know in 2020 that offset 5 in the COBOL data division map means 6 if
>it is a fixed block file and 10 if it is a variable block file?
>
PL1 and COBOL both
prm01
Thanks,
Kolusu
DFSORT Development
IBM Corporation
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
W dniu 27.10.2020 o 18:16, Gibney, Dave pisze:
A fairly quick question. Are there sample ICEPRMxx members provided by IBM
for tailoring DFSORT? I don't find any in SICESAMP.
Yesterday, in my sandbox, I IPL'd with SICELPA, SORTLPA, SICELINK, SORTLIB
ahead of the SYNCSORT librari
have less than one year before we stop z/OS and DFSORT is included in our MFaaS
contract.
> -Original Message-
> From: IBM Mainframe Discussion List On
> Behalf Of R.S.
> Sent: Tuesday, October 27, 2020 10:26 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Syncsort
> I can evaluate and transfer our long time SYNCSORT options. And the
manual does offer advice in this area.
Dave,
I sent you an email offline about DFSORT equivalent installation options
for syncsort. As always please feel free to send me any kind of questions
related to migration.
Tha
TD2
SMF=SHORT
TD3
SMF=SHORT
TD4
SMF=SHORT
From: IBM Mainframe Discussion List on behalf of
R.S.
Sent: Tuesday, October 27, 2020 11:26 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Syncsort to DFSORT - my time has come.
W dniu 27.10.2020 o 18:16, Gibney
EQUALS=NO
ERET=ABEND
SORTLIB=SYSTEM
Y2PAST=0
> -Original Message-
> From: IBM Mainframe Discussion List On
> Behalf Of R.S.
> Sent: Tuesday, October 27, 2020 10:26 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Syncsort to DFSORT - my time has
t; To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Syncsort to DFSORT - my time has come.
>
> After review of our SYNCSORT settings, I have:
> * JCL (ICEAM1)
> JCL
> DYNALOC=(3390,10)
> DYNAUTO=IGNWKDD
> EQUALS=NO
> ERET=ABEND
> SORTLIB=SYSTEM
> Y2PAST=0
> *
> * INV (ICEAM2)
&
EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//OUT DD SYSOUT=*
//TOOLIN DD *
DEFAULTS LIST(OUT)
/*
Thanks,
Kolusu
DFSORT Development
IBM Corporation
--
For IBM-MAIN subscribe / signoff / archi
TSOINV
> SMF=SHORT
> TD1
> SMF=SHORT
> TD2
> SMF=SHORT
> TD3
> SMF=SHORT
> TD4
> SMF=SHORT
>
>
> From: IBM Mainframe Discussion List on behalf
of R.S.
> Sent: Tuesday, October 27, 2020 11:26 AM
> To: IBM-MAI
Not my dog... I'm just a developer.
From: IBM Mainframe Discussion List on behalf of
Martin Packer
Sent: Wednesday, October 28, 2020 2:32 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Syncsort to DFSORT - my time has come.
FWIW I would go with SMF
> Behalf Of Martin Packer
> Sent: Wednesday, October 28, 2020 1:32 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Syncsort to DFSORT - my time has come.
>
>
> FWIW I would go with SMF=FULL - unless you have an exceptionally large
> number of sorts - or tight SMF space rest
SAS and MXG have PC versions.
So, I lose MXG and reasonable ability to process SMF anyway.
-Original Message-
From: Gibney, Dave
To: IBM-MAIN@LISTSERV.UA.EDU
Sent: Wed, Oct 28, 2020 11:47 am
Subject: Re: Syncsort to DFSORT - my time has come.
If we had longer to exist, I might. But
tdown within the year. For me, the path
to ASCII is not likely.
> -Original Message-
> From: IBM Mainframe Discussion List On
> Behalf Of Edward Finnell
> Sent: Wednesday, October 28, 2020 12:40 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Syncsort to DFSORT - my time
: Syncsort to DFSORT - my time has come.
[CAUTION: This Email is from outside the Organization. Unless you trust the
sender, Don’t click links or open attachments as it may be a Phishing email,
which can steal your Information and compromise your Computer.]
Barry pointed this out to me. And I did
I'),TYPE=V
$
ICE007A 1 SYNTAX ERROR
ICE751I 0 C5-I58435 C6-BASE C7-I58435 C8-I58435 E7-I58377
ICE052I 3 END OF DFSORT
> -Original Message-
> From: IBM Mainframe Discuss
Dave,
DFSORT Joinkeys does not require the FORMAT of the key field as a binary
match is done implicitly.
So change your control cards to the following(Just removed the CH on the
Fields statement)
JOINKEYS FILE=F1,FIELDS=(1,9,A),TYPE=F
JOINKEYS FILE=F2,FIELDS=(6,9,A),
INCLUDE=(6,9,CH,EQ
Thank you. Mos of our "fancy" sort stuff is mine, so I can make these changes.
But, and this is just asking, not really expecting. For compatibility and
migration purposes, is there a way for DFSORT to accept this specification?
I have 4 LPARs. This job runs in 3 of them. 2 still ru
>>For compatibility and migration purposes, is there a way for DFSORT to
accept this specification?
Unfortunately NO. The other product had to introduce the formats for
compensating the rich functionality of JNF1CNTL and JNF2CNTL in DFSORT.
DFSORT gives you the entire INREC formatting wit
rsday, October 29, 2020 8:58 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Syncsort to DFSORT - my time has come.
>
> >>For compatibility and migration purposes, is there a way for DFSORT to
> accept this specification?
>
> Unfortunately NO. The other product had to
;
Bad experience, probably arising from bad inexperience.
>As part of the development of the API I have been doing some performance
>testing. These are CPU times to read/report about 8GB of SMF data:
>
>DFSORT:
>CP time 0.78 s
>
>Assembler, reading every record but no repo
Sorry about the tags. I thought I had that right
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Off the top of my head, it would seem that MAINT.TEMP.LIST is not freed (so
that it can be cataloged).
Try adding a free da('maint.temp.list') to the ikjeft01 step.
Another possibility is to pre-allocate maint.temp.list in the ikjeft01 step.
Also, id maint.temp.temp pre-allocated or created by s
Vince,
Your JCL error has got nothing to do with DFSORT or DFHSM.
You are creating the OUTDATASET in your SYSIN control cards and the JCL
interpreter does not read/know that and it flags the dataset referred in
the SORTIN DD as NOT found and hence the JCL error. So you should have
the
On Thu, Feb 11, 2016 at 9:06 AM, Vince Getgood wrote:
> Hi all,
> I've discovered some very odd behaviour when running a DFHSM command in
> the same batch job as a DFSORT step, and I'm completely baffled by what's
> happening.
>
> We're running z/OS 2.2, al
I think what is happening is that the HSEND command is done
asynchronously and therefor the dataset has not been created when the
dfsort step runs.
You might code wait and that should help.
Ed
On Feb 11, 2016, at 9:06 AM, Vince Getgood wrote:
Hi all,
I've discovered some ver
He did code WAIT.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Ed Gould
Sent: Friday, 12 February 2016 3:03 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Odd behaviour with DFHSM & DFSORT in batch.
I think what is happening is
On Feb 11, 2016, at 11:33 PM, Anthony Thompson wrote:
He did code WAIT.
I stand corrected (I usually put wait at the end). My premise is
still there but not sure how to get the program to wait until DFHSM
has created it then?
Ed
--
Thanks all for your responses.
Allan,
I DELETED ‘MAINT.TEMP.LIST’ before running the second job – can’t get more
freed than that…
I tried pre-allocating it – Still get the ARC0141I message.
Kolusu,
I’m sorry, you are wrong. OUTDATASET is created by DFHSM at the time of
issuing the LIST comman
Hi,
what I do to avoid this is creating 2 JCLs . First JCL create the HSM list,
and the second JCL make whatever you need to do with the list.
Regards
*Gonzalo Cengotita*
2016-02-12 7:19 GMT+01:00 Peter Hunkeler :
>
>
> > My suggested solution is to change the SORTIT step to use IDCAMS,
> some
1001 - 1100 of 1476 matches
Mail list logo
