RE: Housekeeping

["Joep Beckeringh" <joep@xxxxxxxxxxxxxxxxxxx>]

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?