Ansicht
Dokumentation
13305 - DB/SQL Problem
BAL Application Log Documentation SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
DB/SQL Problem
Hi Tom,I forgot to ask:
Did your responsetime change in ST03N ?
Are you having more users on it ?
Do you think, that the performance degrades after several days or
weeks and gets recovered with deleting the SQL-Packs ? (because this
shouldn't be the case)
Regards
Volker
e-mail: volker.gueldenpfennig "at" easymarketplace.de
web: www.easymarketplace.de
--- In DoNotReply@consolut.eu, tom.gainesZu... wrote:
> Hi all,
>
> From an appreciative long-time viewer, here's my first posting -
>
> For about the last 2 months we have been getting SQL 7917 "Access
Plan Not
> Updated" errors on our production system (4.6c). CPU utilization
has
> increased but not enough to hurt us much, although there have been
> complaints of slow response time on certain jobs. We are running
an 830
> with 3 processors and 10gb memory allocated to PRD. We have
deleted the
> SQL packages several times which temporarily cleans up the problem
but the
> frequency and impact of the error then builds up again until we
delete the
> packages again.
>
> We opened a PMR with IBM and applied the PTF's they created for
us. We
> applied the latest cum at their request. We are also current on
the fixes
> recommended on the SAP infoapar. We now have a new error MCH 6802
> "Literal Values Cannot be Changed" and the SQL 7917 error has
resurfaced
> again. We also had a MCH 3601 error "Pointer Not Set for Location
> Referenced" which caused one of our SAP WP's to overload, requiring
an IPL
> to recover. I don't know if the pointer error is related to the
others or
> not.
>
> IBM is doing what they can to get to provide fixes but it takes
time. My
> question to the group is has anyone experienced these errors, how
much
> should I worry about them, and what did you do to remedy them.
Our
> kernel level is old (1313) because we are in a FDA regulated
environment
> and updates require a special process. Is the old kernel a factor
and if
> so, why? Until now, we have not had performance issues.
>
> Thanks much for any feedback.
>
> ____________________________________________________
>
> Tom Gaines
> Data Center Supervisor
> Upsher-Smith Laboratories, Inc.
>
> [Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
Addresses (Business Address Services) BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 3051 Date: 20240419 Time: 191246 sap01-206 ( 4 ms )
