RE: CLRPFM and DB2 Tables

[vhamberg@xxxxxxxxx]

REUSEDLT is an attribute of a physical file. You can use
CRTPF or CHGPF to set it (*YES or *NO). CLRPFM removes
deleted records as well as active ones. SQL DELETE does
not.

This is a long shot, however.
> Vern, good question, and an opportunity for me to learn something! Where is
> that setting and what does it control?
>
> -----Original Message-----
> From: vhamberg@attbi.com [mailto:vhamberg@attbi.com]
> Sent: Tuesday, July 02, 2002 11:23 AM
> To: midrange-l@midrange.com
> Subject: RE: CLRPFM and DB2 Tables
>
>
> What is the reuse deleted setting? Could this have a
> bearing?
> > Bruce,
> >
> > I attempted using the DELETE but it just took too long! In the CL I have a
> > RUNSQLSTM that drops the indexes and another to rebuild them at the end. I
> > just can not figure out why the INSERTs went south after the CLRPFM, the
> > program was running fine but it was doing about 1 row every 3 or seconds,
> > ran from the 26th till Monday. What is really surprising is that ops gave
> me
> > a get outa jail free card on that! :-)
> >
>
> -snip-
> _______________________________________________