MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

RE: impact of deleted records



fixed

Coy,

That should work. As long as the PF is journaled.
None of our production PFs are normally journaled.

Paul

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

Paul, do you by chance know if this works with the file already being journaled by MIMIX? I have a 300GB+ file that is replicated and the bulk of the file is deleted records. Unfortunately it's always locked and in use for an online banking system and I would love to reorg it without having to take down our online banking. It's also one of those files that cannot be set to reuse deleted records due to the way it's processed.

Coy Krill
Core Processing Administrator/Analyst
Washington Trust Bank


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul
Sent: Monday, June 30, 2014 08:34
To: 'Midrange Systems Technical Discussion'
Subject: RE: impact of deleted records
Importance: Low

You must be careful when changing PF to REUSEDLT(*YES).
We have some 3rd party apps that require REUSEDLT(*NO) for various reasons.
Also, if you can afford several hours of extra down time during IPL, then Chris's idea works.
We cannot be down that extra time so we use RGZPFM while active.
For this to work, PF must be journaled, so the automated process begins journaling, ends when complete.
We run this process monthly, over any file with deleted records, currently runs 1/2 hour to hour.
Years back, this process took 10 to 20 hours, weeks on R&D partition.
There have been significant improvements with RGZPFM with V6R1 and V7R1, not sure about V5R4.

STRJRNPF FILE(&MBLIB/&MBFILE) JRN(QGPL/RGZPFM)

RGZPFM FILE(&MBLIB/&MBFILE) MBR(&MBNAME) +
RBDACCPTH(*NO) ALWCANCEL(*YES) +
LOCK(*SHRUPD) /* rgzpfm while active */

ENDJRNPF FILE(&MBLIB/&MBFILE) JRN(QGPL/RGZPFM)

Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Bipes
Sent: Monday, June 30, 2014 11:08 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: impact of deleted records

The data management can handle files with many more deleted records than live records but it is not the best practice.

For random indexed access, not much of a performance hit, but any sequential processing will be affected. All those deleted records are skipped through. You application does not see them but the DB manager reads through the dead space.

First thing to do is change the file to REUSEDLT(*YES). This will stop the file from growing and it will start filling in the deleted space.

CHGPF FILE(LIB/FILE)
REUSEDLT(*YES)

I like to have a program that runs at startup of the system that performs maintenance. You make sure the program is owned by QSECOFR and runs under *OWNER profile. This program can have both the CHGPF FILE(LIB/FILE) REUSEDLT(*YES) and the RGZPFM FILE(LIB/FILE) RBDACCPTH(*YES)

This will purge the deleted records from the file and help with sequential processing performance. It will also release a lot of storage being used to hold all of the deleted records.

With 74 million active records, this will take a while to run and re-index. Depending on your hardware, it can be a couple of hours, to only a few minutes.

--
Chris Bipes
Director of Information Services
CrossCheck, Inc.

707.665.2100, ext. 1102 - 707.793.5700 FAX chris.bipes@xxxxxxxxxxxxxxx www.cross-check.com

Notice of Confidentiality: This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information.  If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited.  If you have received this e-mail in error, please immediately notify me by e-mail (by replying to this message) or telephone (noted above) and permanently delete the original and any copy of any e-mail and any printout thereof.  Thank you for your cooperation with respect to this matter.


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 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 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 electronic mail message and any attachments may contain confidential or privileged information and is intended for use solely by the above-referenced recipient. Any review, copying, printing, disclosure, distribution, or other use by any other person or entity is strictly prohibited under applicable law. If you are not the named recipient, or believe you have received this message in error, please immediately notify the sender by replying to this message and delete the copy you received. =====================================================================================================

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






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