Re: How to handle NGS-IQ member full messages?

You could change the default of the CHGPF command to start with a larger number of records. 10000 now a days seems silly. I think we changed ours to 1000000.

Some software packages allow you to specify defaults. When you create a table using LANSA there are overrides to the CHGPF or CREATE TABLE that stay in the repository.

Follow all the recommendations about making a copy of the command, a CL to recreate the CHGCMDDFT after upgrade, etc.

On May 25, 2017, at 8:00 PM, John McKee <jmmckee3@xxxxxxxxx> wrote:

There were some rather large queries over the last 18 years. None got into
a loop. Just query results that were too large for the default file size.
Most did not have the message.

John McKee

On Thu, May 25, 2017 at 6:38 PM, Roger Harman <roger.harman@xxxxxxxxxxx>
wrote:

Do you mean system reply list? Won't it keep replying to add that
increment every time the job throws a message? Dangerous if it starts
looping.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power





From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of John
McKee <jmmckee3@xxxxxxxxx>
Sent: Thursday, May 25, 2017 3:23 PM
To: Midrange Systems Technical Discussion
Subject: Re: How to handle NGS-IQ member full messages?

I used the reply list in a CL to add a fixed increment on the file in
QTEMP. I did NOT use NOMAX. Pick a number too small, and the message gets
thrown many times. Too big, and DASD may get eaten. But, since the
message is handled by reply list, it isn't that big of an issue.

John McKee

On Thu, May 25, 2017 at 5:13 PM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

Same as any file. CHGPF..


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
John
Yeung
Sent: Thursday, May 25, 2017 5:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: How to handle NGS-IQ member full messages?

On Thu, May 25, 2017 at 5:49 PM, Jim Oberholtzer
<midrangel@xxxxxxxxxxxxxxxxx> wrote:

And set the size of the file to a reasonable point. If it's a runaway
query and the file is nomax then it could cause problems. Reply list
entry would be the same as nomax, so some care is needed there.

How do I set the size of a file that is generated on the fly in QTEMP?

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l

.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD