Ansicht
Dokumentation
10473 - BW performance tuning tips
Fill RESBD Structure from EBP Component Structure TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
BW performance tuning tips
--- In DoNotReply@consolut.eu, "ron_silberstein"<ron_silbersteinZy...> wrote:
> --- In DoNotReply@consolut.eu, joel.coxZh... wrote:
> > Hi Joel:
>
> Thanks for you reply.
>
BW Version 3.0B.
> OS version: V5R2
> DB Fix pack: 6
> CUMM level: C3021520
>
> We will put CUMM C3077520 & DB fix pack 8.
>
> Once that is applied we will go ahead per OSS note 501572.
>
> Regards -
>
> Ron (SAP)
> >
> >
> >
> >
> > Ron,
> >
> > What version of BW are you running?
> > OS/400 version?
> > DB Fix pack?
> > CUMM level?
> >
> > Less than a year ago IBM made some changes to the DB2/400 query
> optimizer,
> > specifically for BW (star-schema queries). You need to create a
> special
> > QAQQINI file and set the instance profile parameters
> > dbs/db4/alternate_qaqqinilib & dbs/db4/use_hints. Do you have
this
> setup
> > on your system?
> >
> > These changes had dramatic improvements on our BW performance.
> Queries
> > that ran for 15min are now in the 1min range and queries that ran
> for
> > minutes are in the second range.
> >
> > Joel
> > Manager, Global Infrastructure
> > Hollister Incorporated
> > -----"ron_silberstein" <ron_silbersteinZy...> wrote: -----
> >
> > To: DoNotReply@consolut.eu
> > From: "ron_silberstein" <ron_silbersteinZy...>
> > Date: 06/10/2003 12:36PM
> > Subject: BW performance tuning tips
> >
> > Can anyone offer some BW query performance tuning tips that are
> > specific for BW on iseries? Thanks.
> >
> >
> >
> > Have a look to our homepage at: http://www.consolut.net
> > DoNotReply@consolut.eu
> >
> > Your use of consolut is subject to
> http://www.consolut.net
Durban Tours - Südafrika Safari
PERFORM Short Reference SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 3155 Date: 20240602 Time: 135345 sap01-206 ( 3 ms )