Re: Kill Rollback

Yes, ODBC job doing a bunch (10M) of updates actually...a home grown
data replication process that normally moves data between the iSeries
and an Oracle DB.

It's not a normal occurrence. As I mentioned this is a non-production
environment. We refreshed the i from production data, but since the
production backups aren't sync'd what we do is clear and rebuild the
non-Production oracle environment from the iSeries data. There's an
existing process on the iSeries to rebuild(flag) the data to be sent
to Oracle. Though I actually rewrote it a few months back because the
performance sucked. Really the whole thing should be rewrote, but...

The problem is that our non-Production iSeries box is a LPAR with very
little CPW and only 1GB of memory. Thus the reason the update and
rollbacks were taking so long.

I think I'll see if I can turn off CC (and maybe journaling) during the rebuild.

Charles

On Fri, Oct 8, 2010 at 2:06 PM, Jack Kingsley <iseriesflorida@xxxxxxxxx> wrote:

Charles, in your initial thread you mentioned the job name that was doing
this, was this an ODBC job with a bunch of deletes or inserts or  ??

On Fri, Oct 8, 2010 at 1:28 PM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

Ah, security by ignorance.  Keep the users stupid and all is safe.

Doesn't sound like IBM's normal MO.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"A billion here, a billion there -- pretty soon it adds up to real money."
       -- Everett Dirksen (in U.S. Senate)

The help is based on whether you have *ALLOBJ as well. If you don't
have
*ALLOBJ, you won't see the option listed. Is that a good thing? Not so
sure...:)

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