RE: Problem with sessions from a SAP System

Hello Albert,

any work process (disp+work) holds a permanent connection to the database while
it runs, it only disconnects when it stops. These sessions are what your see in 
your list. So it seems your R/3 is up and running :-)

Regards
Alexander Schröder
MaxDB & liveCache

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt.
Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.   
-----Original Message-----
From: Beermann, Albert [mailto:[email protected]] 
Sent: Mittwoch, 21. März 2007 10:06
To: [email protected]
Subject: Problem with sessions from a SAP System

Hello Everybody

 

I have a maxdb with dateformat eur, sessiontimeout 7200 on a suse linuxs
server.

My application communicates with the database via odbc.

Everything OK!

 

During the night we start a syncronisation programm on our SAP System
(R3 4.6c with Maxdb on hpux) 

that collects some data from R3 and does some inserts or updates 

into my maxdb database via native sql. (connect, sqlcmd, disconnect)

Everything OK but:

I my database i have a lot of sessions that seem to hang.

Select * from sysinfo.sessions shows all these sessions with

startdate = 1 to n days ago

node = ipadress from sapserver

applicationtype = CPC  (my application sessions have ODB)

timeout = 0  (my application sessions have 7200)

sqlmode = oracle  (my application sessions have internal)

isolationlevel = 0  (my application sessions have 1) 

dateformat = dd-mon-yy  (my application sessions have ISO)

 

It looks like the disconnect from SAP does not work correctly or we miss
something else !?????

 

Any help welcomed

Best regards

Albert


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]