Re: very (I repeat) slow DBWR: SOLVED

Thanks to Walter, for pointing out something one would have expected IBM and Oracle support to know.

The effect is amazing, an import which took a week was now finished in 6 hours.
--
Kind Regards,

Gerard

Walter Orb <orb_at_us.ibm.com> wrote in article <7h7a10$ska$1_at_rtpnews.raleigh.ibm.com>...
> Check your system for APAR IX67978. This fixes a known problem with slow
> writes on JFS in AIX 4.2.1.
>
>
> --
> Walter Orb <orb_at_ibm.net>
>
>
> Gerard H. Pille <ghp_at_skynet.be> wrote in message
> news:01be96cf$41038920$390120c0_at_GHP.creyfs.be...
> > Hai Folks,
> >
> > I have a huge performance problem with the DBWR-proces(ses) on an AIX
> > 4.2.1. While the redo-logs (4x50Mb) get filled in a couple of minutes
> > (during which there is high IO on the disk containing them), the
> > checkpointing (which starts when a redo-log is half-full) takes more
> than
> > an hour, resulting, of course, in locking up when all of the redo-logs
> are
> > full.
> >
> > The data-files of the tablespace being loaded via import, are on one
> > SSA-disk. This disk also contains the log of the Journaled File
> System.
>
>
>
>
Received on Mon May 17 1999 - 02:08:16 CDT