Ansicht
Dokumentation
13334 - Antwort: DB/SQL Problem
General Material Data CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
Antwort: DB/SQL Problem
Hi Tom,I think nearly everybody on iSeries is used to nightly IPLs from the
old days of the CISC boxes. But, R/3 is a bit different. You really
should have a look to switch to an online backup and let R3 up
during night and so do not IPL as well - max ones a week or even
only for PTFs or whatever is necessary.
You should keep in mind, that the buffers have to be filled and the
ODPs have to be opened first after restart - this creates slow
responsetimes at the users. So, you should at least give it a try ...
Regards
Volker
--- In DoNotReply@consolut.eu, tom.gainesZu... wrote:
> Richard,
>
> I'm in favor of frequent IPL's - probably too frequent. We IPL
every
> night following our backup but it still hasn't cleaned up the SQL
errors.
>
> Thanks for letting me know about the redbook.
>
> Tom
>
> ____________________________________________________
>
> Tom Gaines
> Data Center Supervisor
> Upsher-Smith Laboratories, Inc.
> 6701 Evenstad Drive
> Maple Grove, MN 55369-6026
> 763-315-2022 (direct)
> 763-315-2262 (fax)
> 612-527-4018 (pager)
> tom.gainesZu...
> ____________________________________________________
>
>
>
>
>
> Richard Menesclou <rmenesclouZf...>
> 03/12/2004 06:21 AM
> Please respond to SAP on System i
>
>
> To: DoNotReply@consolut.eu
> cc:
> Subject: Re: Antwort: DB/SQL Problem
>
>
>
>
>
>
>
> Hello,
>
> I am completly agree with Thomas and I guess that an IPL is more
than
> usefull as the IPL would clear the plan cache.
>
> see in the red book SG24-6598-00 ,
> Preparing for and Tuning the V5R2 SQL Query Engine
> on DB2 Universal Database for iSeries
>
> PS : I dont said that we must do an ipl but it's usefull in case
of
> trouble,
>
>
> have a nice day,
> kind regards,
>
> Richard Menesclou,
>
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
> consolut Sponsor
>
>
>
>
>
> consolut Links
> To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
> To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to the consolut Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
General Material Data Vendor Master (General Section)
This documentation is copyright by SAP AG.
Length: 3854 Date: 20240424 Time: 070703 sap01-206 ( 2 ms )
