RE: Utility to remove and re-add logical file members

Waiting is ok...

Charles

On Tue, Jun 29, 2010 at 11:58 AM, Dennis Lovelady
<iseries@xxxxxxxxxxxx> wrote:

I wrote something like that for copying from one library to another

on a

CommercialWare system.  It stopped and restarted triggering, too.

Unfortunately I cannot access that until this evening (assuming that

I still

have a copy).  Can it wait that long?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"That was Benes' fifth strikeout of the day.  He came in with 94, so

now he

has 104 strikeouts for the year."
       -- sportscaster Ralph Kiner

Before I start rolling my own, is anybody aware of a utility to

remove

all members from dependent logical files (and SQL views/indexes) for

a

given physical that will allow for the members to be automatically
re-added later?

My intent it to purge data from files on our development machine.

remove logical file members
(optionally) stop journalling
delete records from physical
reorg physical
(optionally) restart journalling
re-add logical file members


I'm thinking that at least the logical file member portion may also

be

useful in a bulk data load process..

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