Re: Housekeeping

[Suresh K <vijisur@xxxxxxxxxxxxxxx>]

Hi,

Thanx for the help.

The application is a web based intranet application. System is active
(i.e.available to users) 24hrs a day. Even a small delay in response is
noticeable and not acceptable.

There are 15 logical files. If the logical files are set to MAINT(*REBUILD)
then there would be a time delay.

Viji Suresh.

Joep Beckeringh wrote:

> Suresh,
>
> Are there more logicals on this file? If so, it helps to 'put them on
> hold', so to speak, by changing them from MAINT(*IMMED) to
> MAINT(*REBUILD) (or something like that; quoting from memory), during
> the process.
>
> Joep Beckeringh
>
> > -----Oorspronkelijk bericht-----
> > Van: rpg400-l-admin@midrange.com
> > [mailto:rpg400-l-admin@midrange.com] Namens Suresh K
> > Verzonden: dinsdag 17 september 2002 8:33
> > Aan: rpg400-l@midrange.com
> > Onderwerp: Housekeeping
> >
> >
> > All files in the system are journalled. There are about 12 transaction
> > files. Main transaction file has 7-8 million records per month. The
> > requirement is to move the monthly transaction data to the
> > archives and
> > delete from the transaction files.
> >
> > The data movement and deletion are done through RPG program under
> > commitment control. Initially there was no logical file based on date.
> > When the program ran it took 7hrs to move&delete 5 million records.
> > Tried the same by SQLRPG also. With commit it takes the same time.
> >
> > Now following changes are done to improve performance.(Time taken
> > reduced by about 50%)
> >
> >     1. Logical file based on date.
> >
> >     2. Instead of committing after each pair of insert and delete, a
> > block of 1000 changes are committed.
> >
> > What more can be done to optimize? RPG or SQLRPG is better for this?
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.