IBMMAINFRAMES.com - IBM Mainframe Support Forums

DB2 :: RE: DB2 Package Bind : Failing with SQLCODE -551

Santoshkumar Sala — Thu, 17 May 2012 19:15:00 GMT

Author: Santoshkumar Sala
Posted: Fri May 18, 2012 12:45 am (GMT 5.5)

Hi Rajesh,
Thanks for the info.
_________________
Thanks and Regards,
Santoshkumar.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Robert Sample — Thu, 17 May 2012 19:02:52 GMT

Author: Robert Sample
Posted: Fri May 18, 2012 12:32 am (GMT 5.5)

The web site is RIBBS - USPS National Customer Support Center and if you need a lot of information, download the DMM (Domestic Mail Manual) which runs close to 20 MB of information about IMB (and all other things postal).

Currently, the USPS supports PostNet and IMB bar codes. They have proposed eliminating PostNet by January 2013, leaving IMB as their only supported bar code system. This decision, however, has been delayed several times already since mailers have a big amount commited to PostNet.

I'm not sure how much you can find about comparison of IMB / PostNet to other bar codes, since if you are mailing in the U.S. and wanting to use bar codes you have to use PostNet or IMB, period.
_________________
TANSTAAFL

The first rule of code reuse is that the code needs to be worth re-using.

"We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil." -- Donald Knuth

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Akatsukami — Thu, 17 May 2012 18:28:05 GMT

Author: Akatsukami
Posted: Thu May 17, 2012 11:58 pm (GMT 5.5)

DB2 Guy wrote:

I'll get little greedy and will ask, which one is preferred by USPS (US Postal Services)?

SFAIK, IMB is the only one that will get the USPS to offer an automation discount. I know of no plans to upgrade to 2D (which doesn't mean that there aren't any, just that I don't know of any).
_________________
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" --Me to a junior software engineer.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

DB2 Guy — Thu, 17 May 2012 18:07:42 GMT

Author: DB2 Guy
Posted: Thu May 17, 2012 11:37 pm (GMT 5.5)

Thank you, Robert. Does that mean, they have their own plus & minus points, but what?

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

DB2 Guy — Thu, 17 May 2012 18:05:12 GMT

Author: DB2 Guy
Posted: Thu May 17, 2012 11:35 pm (GMT 5.5)

Thanks John.

I'll get little greedy and will ask, which one is preferred by USPS (US Postal Services)?

Per me, the preferred way is IMB, no? Any justification, if one questions - Why?

I've already sent a note to USPS, however, I'm not hopeful.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Robert Sample — Thu, 17 May 2012 18:03:35 GMT

Author: Robert Sample
Posted: Thu May 17, 2012 11:33 pm (GMT 5.5)

The US Post Office IMB is a linear height-modulated bar code, so it is only one-dimensional. 2D bar codes, by defintion, are two dimensional.
_________________
TANSTAAFL

The first rule of code reuse is that the code needs to be worth re-using.

"We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil." -- Donald Knuth

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Akatsukami — Thu, 17 May 2012 18:00:16 GMT

Author: Akatsukami
Posted: Thu May 17, 2012 11:30 pm (GMT 5.5)

No relation, so far as I know.
_________________
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" --Me to a junior software engineer.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

Frank Yaeger — Thu, 17 May 2012 17:51:31 GMT

Author: Frank Yaeger
Posted: Thu May 17, 2012 11:21 pm (GMT 5.5)

Quote:

Do we need to manually allocate Sort work files for this sort which involves comparison of such huge data ? Or SORT utility dynamically allocates all the space needed by this compare?

If you don't specify SORTWKdd DD statements, DFSORT will dynamically allocate the work space according to your site's installation defaults. We do recommend the use of dynamic allocation. If your site's default is not sufficient for your JOINKEYS job, you can override it using:

Code:

//JNF1CNTL DD *
OPTION DYNALLOC=(,n)
//JNF2CNTL DD *
OPTION DYNALLOC=(,n)

where n can be up to 255 work data sets. If you're worried that your installation default is not enough, you could start with

Code:

OPTION DYNALLOC=(,16)

as a starting point.
_________________
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

DFSORT/ICETOOL :: RE: Need Sort Card - Build Using DFSORT \JCL

Frank Yaeger — Thu, 17 May 2012 17:41:56 GMT

Author: Frank Yaeger
Posted: Thu May 17, 2012 11:11 pm (GMT 5.5)

It WAS probably SPLICE that put him over the edge.
_________________
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

DFSORT/ICETOOL :: RE: Count and sum in single step

sqlcode1 — Thu, 17 May 2012 17:41:37 GMT

Author: sqlcode1
Posted: Thu May 17, 2012 11:11 pm (GMT 5.5)

Skolusu,
I was just trying to explain OP (using the same card that he had originally provided) that he could use OUTFIL SECTIONS to produce the count without having to increase length by overlaying 0s and 1s.

Just another approach, nothing else.

Thanks,

DFSORT/ICETOOL :: RE: Count and sum in single step

Skolusu — Thu, 17 May 2012 17:07:40 GMT

Author: Skolusu
Posted: Thu May 17, 2012 10:37 pm (GMT 5.5)

umanaga wrote:

exactly..i tried changing the OUTREC to INREC after reading complete thread as suggested by you guys.

Thanks.

Umanaga,

Take a look at the flowchart given here and you will understand how DFSORT process the statements

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA30/1.5.4?

You are better off reformatting the record after you are done with the sorting and summing. By increasing the length of the record before sorting , you are increasing the number of bytes to be sorted. You really don't need to do as you are only padding with spaces.

Your REFORMAT record is creating a 51 byte record and you are expanding it to 493 bytes. So add the counter at byte 52 and perform the SUM. Once you are done with SUMMING you can use OUTREC to expand the record. When you use Positions to BUILD you don't have to specify the (13x,11x,13x...) as by default they will be padded with spaces.

Here are the updated control cards for your job.

Code:

//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(12,12,A)
JOINKEYS FILE=F2,FIELDS=(12,12,A)
REFORMAT FIELDS=(F1:4,8,3,1,12,2,F2:44,2,56,4,F1:211,2,40,16,56,16)

INREC OVERLAY=(52:C'000000001')
SORT FIELDS=(10,10,CH,A)
SUM FIELDS=(20,16,ZD,36,16,ZD,52,9,ZD)

OUTREC BUILD=(001,09,
010:C'XXXXXXXXXX',
020:10,02,
035:12,02,
050:14,04,
065:18,02,
245:52,09,
254:20,16,
270:36,16,
493:X)
//*

Sqlcode1,

Did you Forget to remove the SUM FIELDS statement in your job? You would get an error as you are using OUTREC instead of INREC.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

dbzTHEdinosauer — Thu, 17 May 2012 16:32:41 GMT

Author: dbzTHEdinosauer
Posted: Thu May 17, 2012 10:02 pm (GMT 5.5)

i think what annoyed me most was that the TS obviously has
not bothered to even look at 10.2 Design Your Applications to Maximize Performance
and has instead decided to rely
on internet input concerning an implementation.

hey, tell your boss that I said it was ok to run in production just as you have been running in test.
_________________
Dick Brenholtz

The only thing worse than waking up late,
is waking up the day before you wished it was.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

sqlcode1 — Thu, 17 May 2012 16:07:55 GMT

Author: sqlcode1
Subject: Re: Query regarding usage of Sort work files in comparision.
Posted: Thu May 17, 2012 9:37 pm (GMT 5.5)

Hima1985 wrote:

Do we need to manually allocate Sort work files for this sort which involves comparison of such huge data ? Or SORT utility dynamically allocates all the space needed by this compare?

If we need to manually allocate Sort work files, what would be the approximate space allocation needed for each work dataset? Please suggest.

We are using Z/OS DFSORT V1R12.
...
...
Please let me know if you need more information. Thanks.

You would have to tell DFSort about what you want to do (Dynamic Allocation or hardcoding SORTWK). It wouldn't do anything on its own. For dynamic allocation you need to define dynamic allocation.

Of course, if you manually specify SORTWK, you need to define enough SORTWK for your current (and future?) requirement.

Its really hard to give you accurate answers without you testings because some of the space requirement for sort varies from time to time even at the same shop based on space availability.

Thanks,

DFSORT/ICETOOL :: RE: Count and sum in single step

sqlcode1 — Thu, 17 May 2012 15:58:30 GMT

Author: sqlcode1
Posted: Thu May 17, 2012 9:28 pm (GMT 5.5)

umanaga,
Not sure what you are trying to do here if this is your sort card as of now and IF it produced sample input as you have shown, using OUTFIL SECTIONS,NODETAIL, with COUNT, will get desired results....

Read about SECTIONS here OR provide sample input records.

something like below,..obviously untested.... Check OUTFIL closely...

Code:

JOINKEYS FILE=F1,FIELDS=(12,12,A)
JOINKEYS FILE=F2,FIELDS=(12,12,A)
REFORMAT FIELDS=(F1:4,8,3,1,12,2,F2:44,2,56,4,F1:211,2,40,16,56,16)
OUTREC FIELDS=(01:1,9,
10:C'xxxxxxxxxx',
20:10,2,13X,
35:12,2,13X,
50:14,4,11X,
65:18,2,13X,
80:165X,
245:C'000000001',
254:20,16,
270:36,16,
286:208X)

SORT FIELDS=(20,60,CH,A)

SUM FIELDS=(245,09,ZD,254,16,ZD,270,16,ZD)
OUTFIL REMOVECC,NODETAIL,SECTIONS=(CONTROL-BREAK FIELD,
TRAILER3=(FIELDS THAT YOU WANT,COUNT=(EDIT=(ITTTTTTT))))

Thanks,

DFSORT/ICETOOL :: RE: Count and sum in single step

umanaga — Thu, 17 May 2012 15:49:57 GMT

Author: umanaga
Posted: Thu May 17, 2012 9:19 pm (GMT 5.5)

exactly..i tried changing the OUTREC to INREC after reading complete thread as suggested by you guys.

Thanks.

DFSORT/ICETOOL :: RE: Retiring after 43+ years with IBM

Div Grad — Thu, 17 May 2012 14:47:28 GMT

Author: Div Grad
Posted: Thu May 17, 2012 8:17 pm (GMT 5.5)

Add me to the list of people who are sorry to see you go, grateful for all your near instantaneous replies, and who wish you a happy retirement.

DFSORT/ICETOOL :: RE: Need Sort Card - Build Using DFSORT \JCL

Ed Goodman — Thu, 17 May 2012 14:15:11 GMT

Author: Ed Goodman
Posted: Thu May 17, 2012 7:45 pm (GMT 5.5)

Very off topic, but last night I was telling my daughter the story of the man who introduced me to the advanced functions of DFSORT.

You ask, "Why would a 17-year-old girl be interested in that kind of thing?" Funny story. We were talking about people going insane or "losing it" at work.

This guy had gone to the main floor of our office building to get some caffeine, not sure if coffee or cola. While waiting for the VERY old elevator, a lady came up and pushed the UP button again. (These were so old they didn't light up when pressed)

My poor co-worker started berating the woman for pressing the button again and making it so the old system reset the wait time on the car and now it would be even LONGER to get a car and now he was going to be late........

Then, after the woman kind of tried to play it off, he poured his drink over her head. Right there in the lobby. Then he took off running up the stairs. However, this was no shrinking violet of a lady and she went after him. She finally found him on the sixth floor and first building security, then the police, had to come and end the situation.

So...any time I'm going through the DFSORT manual, or trying to get a tricky process to work, I think of that guy, and wonder if THIS was the thing he was trying to do when he finally cracked.
_________________
M V S Help Refugee

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

dick scherrer — Thu, 17 May 2012 14:12:39 GMT

Author: dick scherrer
Posted: Thu May 17, 2012 7:42 pm (GMT 5.5)

Hello,

You might not have expected such a response, but keep in mind that the "experts" here are as different as teachers in school - we all have different ways to make a point or get someone's attention. Rather than being offended, suggest you look at the intent of the poster. What you took exception to really does point to signifcantly serious problems in that organization.

The only reason most of us are here is to provide some assistance and help people learn. Both technical stuff and business practices.

So far, i see no waste of time. . .
_________________
Hope this helps,

d.sch.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

Hima1985 — Thu, 17 May 2012 14:03:23 GMT

Author: Hima1985
Posted: Thu May 17, 2012 7:33 pm (GMT 5.5)

Thanks for your suggestions. Ill try that.

Quote:

i am not sure what your site lacks most: competence or character.

I never expected such response from experts for which you may just ignore the post without providing any suggestions. Very sorry for wasting your valuable time.

DFSORT/ICETOOL :: RE: Count and sum in single step

Bill Woodger — Thu, 17 May 2012 13:48:14 GMT

Author: Bill Woodger
Subject: Reply to: Count and sum in single step
Posted: Thu May 17, 2012 7:18 pm (GMT 5.5)

Well done with the Codeing then.

You've had an hour. Have you changed the OUTREC, which operates AFTER SORT/SUM, to INREC?

DFSORT/ICETOOL :: RE: Count and sum in single step

dick scherrer — Thu, 17 May 2012 13:33:22 GMT

Author: dick scherrer
Posted: Thu May 17, 2012 7:03 pm (GMT 5.5)

Hello,

You need to post the complete sysout including the message ids.

Do not post what you believe we might find useful - post all of the messages from the step. Providing the info a bit at a time only wastes everyone's time - your and ours.
_________________
Hope this helps,

d.sch.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

Bill Woodger — Thu, 17 May 2012 13:30:52 GMT

Author: Bill Woodger
Subject: Reply to: Query regarding usage of Sort work files in compar
Posted: Thu May 17, 2012 7:00 pm (GMT 5.5)

What is your problem with generating the volume data? DFSORT can do that for you as well.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

dick scherrer — Thu, 17 May 2012 13:26:24 GMT

Author: dick scherrer
Posted: Thu May 17, 2012 6:56 pm (GMT 5.5)

Hello,

Suggest you make sure the files are in sequence Before you compare them. Then, no sortwork will be needed for the compare process.

How can anyone justify turning this in to Production when full-volume testing has not been done?

Utter nonsense
_________________
Hope this helps,

d.sch.

DFSORT/ICETOOL :: RE: Retiring after 43+ years with IBM

superk — Thu, 17 May 2012 12:55:46 GMT

Author: superk
Subject: Reply to: Retiring after 43+ years with IBM
Posted: Thu May 17, 2012 6:25 pm (GMT 5.5)

Frank, it's been a real pleasure working with you on all of these forums for all these years. Best wishes for your retirement, I hope it's enjoyable and filled with pleasure for many years to come.
_________________
Kevin

DFSORT/ICETOOL :: RE: Count and sum in single step

umanaga — Thu, 17 May 2012 12:40:55 GMT

Author: umanaga
Posted: Thu May 17, 2012 6:10 pm (GMT 5.5)

prodiving sample input file is difficult due to file length..that is why i have given requirement and data samples my own

Abend faced when above card run is U0027

Myself kept the coding tags, after realizing its not good when viewed the post again.

DFSORT/ICETOOL :: RE: Count and sum in single step

Bill Woodger — Thu, 17 May 2012 12:40:44 GMT

Author: Bill Woodger
Subject: Reply to: Count and sum in single step
Posted: Thu May 17, 2012 6:10 pm (GMT 5.5)

Find the FIgure in the DFSORT manual which tells you the order in which things are processed. Compare closely to what you have coded.

Read through what has already been said.

Fix. Try again. Let us know. If it fails, post the sysout as well.

Plus, someone Coded your post for you. Don't let that happen again, but put it in the Code tags yourself. Click on the Quote button, search the forum, look up to the FAQ towards the top of each screen, etc.

DFSORT/ICETOOL :: RE: Count and sum in single step

daveporcelan — Thu, 17 May 2012 12:35:51 GMT

Author: daveporcelan
Posted: Thu May 17, 2012 6:05 pm (GMT 5.5)

What about an input data sample and the ABEND you say you are receiving?

A better english description of the requirement would be nice as well.

DFSORT/ICETOOL :: RE: Count and sum in single step

umanaga — Thu, 17 May 2012 12:32:50 GMT

Author: umanaga
Posted: Thu May 17, 2012 6:02 pm (GMT 5.5)

Here it is

Code:

CICS :: RE: CICS ASRA Abend (Protection Exception) Help

Bill Woodger — Thu, 17 May 2012 12:32:38 GMT

Author: Bill Woodger
Subject: Re: Reply to: CICS ASRA Abend (Protection Exception) Help
Posted: Thu May 17, 2012 6:02 pm (GMT 5.5)

Quote:

I don't have any experience on debugging this kind of PROTECTION EXCEPTION RELATED ABEND.

I think I will look at the parent module of this so that I can check the passing of data. However, I am not confident if I am able to know that the data passed is correct. Moreover, I will definitely try what you have suggested.

I will update this post if I accidentally find the solution.

Don't get hung-up on the particular type of abend. If your pointer were a COMP-3 and you were using it in a calculation and it had a sufficiently invalid value, you'd get a DATA EXCEPTION. You'd have to look for the cause in exactly the same way.

Definitely, if it has come from another module, you must look there. If it goes to other modules before yours, check there.

Somewhere originally it has been given a value which is an address to a piece of storage for you to use. Either it has done that incorrectly, or after that something has clobbered it, or your linkage doesn't match up so it looks "clobbered" when you try to use it.

What you have to do is: find where it first gets a value; check that the value is correct; if yes, check it where it goes off to anywhere else first; check it as it arrives in your module.

Once you have some idea of where it happened, then you can start to narrow it down.

Have a little more confidence. The only way you find it "by accident" is if you start changing code, running, changing again, etc, and stumble on a "fix", without knowing why, how or anything (and it is probably not the full story).

If you go looking for the problem, and you know enough to identify it when you see it, there is no accident involved.

DFSORT/ICETOOL :: RE: Count and sum in single step

daveporcelan — Thu, 17 May 2012 12:32:01 GMT

Author: daveporcelan
Posted: Thu May 17, 2012 6:02 pm (GMT 5.5)

Is this some sort of puzzler?

The only skill you list in your profile is 'discussion', yet you fail to provide any useful information.

Why don't you show what you have done so far?

The JCL AND the abend.

This would make it much easier to help you.

DFSORT/ICETOOL :: RE: Count and sum in single step

dbzTHEdinosauer — Thu, 17 May 2012 12:30:57 GMT

Author: dbzTHEdinosauer
Subject: Re: Reply to: Count and sum in single step
Posted: Thu May 17, 2012 6:00 pm (GMT 5.5)

Bill Woodger wrote:

Deja vu

i, personnally, thought: FM, not again.

umanaga,

since DFSORT forum is a 'do it for you' forum and not a 'here is a hint' forum,
suggest you provide us with all of your control cards,
so that someone can repair them for you.
_________________
Dick Brenholtz

The only thing worse than waking up late,
is waking up the day before you wished it was.

DFSORT/ICETOOL :: RE: Count and sum in single step

umanaga — Thu, 17 May 2012 12:27:17 GMT

Author: umanaga
Posted: Thu May 17, 2012 5:57 pm (GMT 5.5)

Sorry if i have missed to mention,

Code:

A 12{
B 13{
A 01{

data is fetched from two files using JOIN, REFORMAT, OUTFIL BUILD

After OUTFIL when using SUM fields facing abend.

DFSORT/ICETOOL :: RE: Count and sum in single step

dbzTHEdinosauer — Thu, 17 May 2012 12:26:06 GMT

Author: dbzTHEdinosauer
Posted: Thu May 17, 2012 5:56 pm (GMT 5.5)

why not append the 01 (are you sure you can only have 99 dups?)
during INREC?

you essentially hae 3 stages to sort (please, kolusu and Frank, don't beat on me for this)

INREC/INFILE where you can do all kinds of things to records

the "sort" part where the output of INREC/INFILE is 'sorted,summed, etc'

the OUTREC/OUTFILE part where the output of the 'sort' part is available for manipulation prior to being written to the output dataset(s).
_________________
Dick Brenholtz

The only thing worse than waking up late,
is waking up the day before you wished it was.

DFSORT/ICETOOL :: RE: Count and sum in single step

Bill Woodger — Thu, 17 May 2012 12:23:14 GMT

Author: Bill Woodger
Subject: Reply to: Count and sum in single step
Posted: Thu May 17, 2012 5:53 pm (GMT 5.5)

Deja vu

With INREC, extend your record to include a value of 1 of the length you need.

Include the new field in the SUM statement.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

dbzTHEdinosauer — Thu, 17 May 2012 12:16:21 GMT

Author: dbzTHEdinosauer
Posted: Thu May 17, 2012 5:46 pm (GMT 5.5)

Ahhh! Now I understand.

you want someone that has NO
understanding of your site,
idea of what kind of equipment,
idea of production schedule,

to say "yes this will work".

if this job is a critical business step,
then you need to test based on a production load.

anything less would not be a responsible implementation.

i am not sure what your site lacks most: competence or character.
_________________
Dick Brenholtz

The only thing worse than waking up late,
is waking up the day before you wished it was.

DFSORT/ICETOOL :: Count and sum in single step

umanaga — Thu, 17 May 2012 12:09:03 GMT

Author: umanaga
Subject: Count and sum in single step
Posted: Thu May 17, 2012 5:39 pm (GMT 5.5)

i have a requirement as below

Code:

A 12{
B 13{
A 01{

after sort

Code:

A 13{ 02
B 13{ 01

02- no of A recs, 01-no of B recs

Currently doing this in 2 steps, once to modify every rec by putting 01 and in second step use sum fields on them. Is it possible to do it in a single step.

CICS :: RE: CICS ASRA Abend (Protection Exception) Help

Robert Sample — Thu, 17 May 2012 11:34:20 GMT

Author: Robert Sample
Posted: Thu May 17, 2012 5:04 pm (GMT 5.5)

If you have debugging tools installed at your site, such as Xpediter, use them. Otherwise, if the transaction is started at a terminal, try using CEDF to look at the data being passed from calling program to subprogram.
_________________
TANSTAAFL

The first rule of code reuse is that the code needs to be worth re-using.

"We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil." -- Donald Knuth

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

Hima1985 — Thu, 17 May 2012 11:30:56 GMT

Author: Hima1985
Posted: Thu May 17, 2012 5:00 pm (GMT 5.5)

I have not tested it yet as we cannot perform volume testing here in test environment and this job is not yet implemented in production.

CICS :: RE: CICS ASRA Abend (Protection Exception) Help

cyrus.e.cabrera — Thu, 17 May 2012 11:17:17 GMT

Author: cyrus.e.cabrera
Subject: Re: Reply to: CICS ASRA Abend (Protection Exception) Help
Posted: Thu May 17, 2012 4:47 pm (GMT 5.5)

Bill Woodger wrote:

You definitely need to concentrate on ADDR-EXCHANGE-CONTEXT. It contains an invalid address (pointing to storage to which you don't have access).

You need to find where it is given any values. Where is it defined? If in some other module, you have to check whether it is getting passed correctly to your module.

You have to locate everywhere where it gets set. If it starts off with correct values, you have to "watch" it through to the point where it becomes incorrect.

It might be something "simple" like a bunch of pointers in a copybook and not using the same copybook in different modules.

Thank you for the advice Bill. As of now, I am having a hardtime pin-pointing the location of the first pass for this variable. I don't have any experience on debugging this kind of PROTECTION EXCEPTION RELATED ABEND.

I think I will look at the parent module of this so that I can check the passing of data. However, I am not confident if I am able to know that the data passed is correct. Moreover, I will definitely try what you have suggested.

I will update this post if I accidentally find the solution.

Godspeed.
_________________
"There is nothing either good or bad. Thinking makes it so."

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

dbzTHEdinosauer — Thu, 17 May 2012 11:02:12 GMT

Author: dbzTHEdinosauer
Subject: Re: Reply to: Query regarding usage of Sort work files in co
Posted: Thu May 17, 2012 4:32 pm (GMT 5.5)

Hima1985 wrote:

We need promote this job to Production environment where actual data exists. So want to ensure it gets executed to avoid any space abends..

answer my question: Have you tested? what were the results?
_________________
Dick Brenholtz

The only thing worse than waking up late,
is waking up the day before you wished it was.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

Hima1985 — Thu, 17 May 2012 10:42:22 GMT

Author: Hima1985
Subject: Reply to: Query regarding usage of Sort work files in compar
Posted: Thu May 17, 2012 4:12 pm (GMT 5.5)

We need promote this job to Production environment where actual data exists. So want to ensure it gets executed to avoid any space abends..

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

dbzTHEdinosauer — Thu, 17 May 2012 10:35:10 GMT

Author: dbzTHEdinosauer
Posted: Thu May 17, 2012 4:05 pm (GMT 5.5)

have you bothered to even test?

normally, sortwork should be left alone and allow sort to allocate as is needed.
_________________
Dick Brenholtz

The only thing worse than waking up late,
is waking up the day before you wished it was.

DFSORT/ICETOOL :: Query regarding usage of Sort work files in comparision.

Hima1985 — Thu, 17 May 2012 09:57:40 GMT

Author: Hima1985
Subject: Query regarding usage of Sort work files in comparision.
Posted: Thu May 17, 2012 3:27 pm (GMT 5.5)

Hi,

Could you please suggest for below:

We are comparing two sequential files using SORT utility and need to write the matching records in one file and non matching records in another file.
Both files are LRECL of 116 / FB and the key field is from position 1 to 106.

First file contains 20 million records(no duplicates) and second file contains 35 million records(may contain duplicates).

Do we need to manually allocate Sort work files for this sort which involves comparison of such huge data ? Or SORT utility dynamically allocates all the space needed by this compare?

If we need to manually allocate Sort work files, what would be the approximate space allocation needed for each work dataset? Please suggest.

We are using Z/OS DFSORT V1R12.

Code:

//SYSIN DD *
JOINKEYS F1=IN1,FIELDS=(1,106,D)
JOINKEYS F2=IN2,FIELDS=(1,106,D)

JOIN UNPAIRED,F1

REFORMAT FIELDS=(F1:1,116,?)
OPTION COPY

OUTFIL FNAMES=OUT1,INCLUDE=(117,1,CH,EQ,C'B'),
BUILD=(1,116)

OUTFIL FNAMES=OUT2,INCLUDE=(117,1,CH,EQ,C'1'),
BUILD=(1,116)
/*

Please let me know if you need more information. Thanks.

DFSORT/ICETOOL :: RE: Retiring after 43+ years with IBM

expat — Thu, 17 May 2012 09:02:10 GMT

Author: expat
Posted: Thu May 17, 2012 2:32 pm (GMT 5.5)

Frank, enjoy your retirement and the pleasures it brings

Pop by from time to time
_________________
Some people are like Slinkies. They have no real value,
but it sure is fun to see them pushed down the stairs.

IBMMAINFRAMES.com - IBM Mainframe Support Forums

DB2 :: RE: DB2 Package Bind : Failing with SQLCODE -551

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Other Mainframe Topics :: RE: IMB bar Codes and 2D Bar codes.

Other Mainframe Topics :: IMB bar Codes and 2D Bar codes.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Need Sort Card - Build Using DFSORT \JCL

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Retiring after 43+ years with IBM

DFSORT/ICETOOL :: RE: Need Sort Card - Build Using DFSORT \JCL

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Retiring after 43+ years with IBM

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

CICS :: RE: CICS ASRA Abend (Protection Exception) Help

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Count and sum in single step

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: Count and sum in single step

CICS :: RE: CICS ASRA Abend (Protection Exception) Help

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

CICS :: RE: CICS ASRA Abend (Protection Exception) Help

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: Query regarding usage of Sort work files in comparision.

DFSORT/ICETOOL :: RE: Retiring after 43+ years with IBM