Ansicht
Dokumentation
13316 - DB/SQL Problem
General Data in Customer Master CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
DB/SQL Problem
Hi Volker,Thanks for the info. I'm checking with our Basis Administrator on the
ST03N statistics but from our OS/400 monitoring there was a definite
gradual increase in CPU utilization with the passing of time after SQL
packages are deleted. For example, if packages were deleted on a weekend,
Monday and Tuesday would show very few SQL 7917 errors and typical CPU
use. By Friday, there would be many errors in our job logs and an
increase of 20 - 30% in CPU utilization.
We have not had an increase in number of users.
Tom
"Volker Gueldenpfennig" <volker.gueldenpfennigZe...>
03/12/2004 12:56 AM
Please respond to SAP on System i
To: DoNotReply@consolut.eu
cc:
Subject: Re: 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]
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
[Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 4996 Date: 20240416 Time: 125030 sap01-206 ( 3 ms )
