Ansicht
Dokumentation
13335 - Antwort: DB/SQL Problem
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL Application Log DocumentationThis documentation is copyright by SAP AG.
Antwort: DB/SQL Problem
dont send mail to me .........i got frustaion with ur mails..........so pleasedont mail me
bye
Volker Gueldenpfennig <volker.gueldenpfennigZe...> wrote:
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]
Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu
---------------------------------
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
"True friendship is like sound health; the value
of it is seldom known until it be lost."
- Charles Caleb Colton.
---------------------------------
Do you consolut?
consolut Search - Find what youre looking for faster.
[Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
CPI1466 during Backup General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 5285 Date: 20240508 Time: 063301 sap01-206 ( 3 ms )