MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

RE: impact of deleted records



fixed

Peter,

Once, I had RGZPFM while active cause a production job to fail, Feb 2012.

PENCOR05 CPF5084 I/O error was detected in CCERCPL0 (C G S D F).

We were on P5 9406-550 V6R1, monthly reorg job took 11 to 15 hours back then.
A timing issue occurred that the a production process was on the file with high IO at the same time the RGZPFM while active job hit that file.
We have since omitted that one file from the process, as a precaustion.

Now, on P7 8205 with SSD drives, same monthly reorg process is only 30 to 40 minutes.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Connell
Sent: Monday, June 30, 2014 4:13 PM
To: Midrange Systems Technical Discussion
Subject: RE: impact of deleted records

Thanks to all who have contributed.

I'm well aware of the REUSEDLT keyword. In fact this huge file does appear to have REUSEDLT(*YES).
Populating it has not been well thought out since the process appears to end up deleting far more records than it adds, and it's journalled for mirroring to boot.
Reorganizing it is now obviously an issue. I believe it is accessed primarily via embedded SQL with the appropriate access paths so I expect that data management can provide efficient access.
But I was wondering if maintenance during business as usual can suffer because of the need to find deleted records for reuse.

Peter


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Tuesday, 1 July 2014 2:33 a.m.
To: Midrange Systems Technical Discussion
Subject: Re: impact of deleted records

Simple answer - yes. But why would you force it to?


On 2014-06-29, at 5:34 PM, Peter Connell <Peter.Connell@xxxxxxxxxx> wrote:

Huge file of 74 million rcds has 301 million deleted records and several logical files.
Can data management really handle this with little performance impact if there are regular additions/deletions?


######################################################################
###############

This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual
sender, except where the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :- Australia
customerassistance@xxxxxxxxxxx or New Zealand +64 9 367 6200
--
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.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com




--
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.

#####################################################################################

This correspondence is for the named person's use only. It may contain confidential
or legally privileged information, or both. No confidentiality or privilege is waived
or lost by any mistransmission. If you receive this correspondence in error, please
immediately delete it from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual sender, except where
the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :-
Australia customerassistance@xxxxxxxxxxx or New Zealand +64 9 367 6200





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact