Kontakt

Ansicht
Dokumentation

13306 - Antwort: DB/SQL Problem

13306 - Antwort: DB/SQL Problem

rdisp/max_wprun_time - Maximum work process run time   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Antwort: DB/SQL Problem

Hi Tom,

we had the same problems since this monday.
A guy from IBM told me that this could have something to do with the SAP
database monitor.
So we did three thing:

Switched of the DB - monitor
Installed the lastest IBM DB fixpack SF99502 (12)
Installed the lastest Hiper PTF'S SF99519 (94)

Then IPLed the system.
Now it looks realy good for the moment.
Our kernle is 46D-EXT 1646.


Best regards / Mit freundlichen Grüßen

Thomas



tom.gainesZu...
11.03.2004 23:50
Bitte antworten zu
DoNotReply@consolut.eu


An
DoNotReply@consolut.eu
Kopie

Thema
DB/SQL Problem






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 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

Fill RESBD Structure from EBP Component Structure   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 4170 Date: 20240420 Time: 093023     sap01-206 ( 3 ms )