Re: File w/Large Number of Members

[Alan Shore <AlanShore@xxxxxxxx>]

I don't know if this makes any sense or not, but here goes -----
I had the same problem, many years ago, though NOT to the extent that you
have.
I finally came upon the following procedure that SEEMED to go through
quicker than a straight delete
First remove all of the members to the file

RMVM FILE(FILENAME) MBR(*ALL)

then do the delete.

I did NOT do any scientific comparisons except with the old clock on the
wall, so if anyone refutes this, believe me I'm not going to argue.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill


midrange-l-bounces@xxxxxxxxxxxx wrote on 02/21/2008 01:44:22 PM:

> Hello list,
>
> I'm working with an application that has a work file that builds up a
> large number of members while the application is running.  It takes
> several hours to complete.  I even bumped into IBM's restriction of no
> more than 32,767 members in a physical file with this one.
>
> I'm have a minor issue with deleting the work file when I'm all done.
> When the file has 30,000+ members in it, it can take more than an hour
> for a DLTF to run.  Has anyone ever run across this before?  Are there
> any tricks out there to speed up the file deletion process?
>
> Rich Loeber
> Kisco Information Systems
> http://www.kisco.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.