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
