Ansicht
Dokumentation

13338 - DB/SQL Problem

13338 - DB/SQL Problem

Addresses (Business Address Services)   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

DB/SQL Problem

Hi Tom,

that sounds really interesting!
This should be not the case in my eyes if the workload over the week
should stay similar - which could be checked in ST03N as well.

I wouldn't argue with the joblogs, because these messages could be
OK and it would be normal, that as older as the SQL-Packs are and
the more tables are in ODPs open, the more of these messages might
occur.

Regards

Volker

--- In DoNotReply@consolut.eu, tom.gainesZu... wrote:
> 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
>
> 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

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 6171 Date: 20240329 Time: 060007     sap01-206 ( 3 ms )