Hi,
at first you should find out which process takes the cpu time. Is it the database
kernel process ("kernel.exe")? If yes, maybe you run into an endless loop inside the
kernel. As far as I can remember we had have an endless loop in some situation using
long columns. A kernel update would help in this situation. Or, if you use dbprocs you
might have a self-programmed endless loop inside your dbproc?
Possible traces to track down the reason are:
- jdbc trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) to find out what your
application is doing
- vtrace (http://sapdb.2scale.net/moin.cgi/vtrace) to find out what the database
kernel is doing
- there is also a tool x_cons for analyzing the kernel and for tracking down
performance problems, but it's difficult to undertand. Maybe you give it a try.
before starting your application:
x_cons <dbname> reset all //resets internal counter
x_cons <dbname> time enable //activate time measurement
if you run into the performace problem:
x_cons <dbname> show all //you should pipe the output into a file
HTH,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: Gonzalo Casas [mailto:[EMAIL PROTECTED]
> Sent: Donnerstag, 26. Juni 2003 00:21
> To: [EMAIL PROTECTED]
> Subject: SAPdb deadlock?
>
>
>
> Hi,
> Im running sap 7.4.3.17 on a W2k server, the only access
> to the database is through a JSP webapp with sap jdbc driver
> (7.4.3.17) .... there's very few users connected.... because
> the webapp is on beta...today, there was only ONE user
> connected, and the SAPdb service became soo unstable, and
> resource-consuming that the server was almost unmanageable...
> i mean, i opened a DOS window, and the chars appared on the
> screen with delay!!! i had to stop and restart and it all
> came back to normal... but, what can i do to trace to cause
> of the problem? any logfile/trace/any ideas on how to know
> what happened today?
>
> thanks,
> gonzalo
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
