Re: CLRPFM and DB2 Tables

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

----- Original Message -----
From: "Weatherly, Howard" <Howard.Weatherly@dlis.dla.mil>
To: <midrange-l@midrange.com>
Sent: Tuesday, July 02, 2002 11:19 AM
Subject: RE: CLRPFM and DB2 Tables


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> 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! :-)


well, the clear should not have anything to do with the performance of the
inserts.

inserts that are that slow would have me looking for additional indexes
somewhere, and/or the structure of the data... like does it have a lot of
conversion to do, dates, timestamps, etc?

but then you said ops.... are the inserts running from ops nav? That's a
dynamic insert, probably with closes and opens. Also, if it was running over
a dial up connection... yeeesh!

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"There is a crack in everything,
  that's how the light gets in.
    - Leonard Cohen