Hello,
we have slow performance, when reading many records from a sapdb 7.3.0.24
under linux (instance type BW)
with visual basic 6 via odbc. The tables are linked in an access 2000
database.
The sql-trace says, that after some processed records, the odbc driver
disconnects and reconnects.
Sometimes the reconnect fails, and the logon windows appears again.
In the trace I see several session (S2,S5,S6), and every session
disconnects and reconnects after some seconds:
S2:SELECT COUNT(* ) FROM "DWH_ADMIN"."AUFENTHALT" WHERE ((("AUFN_ART" IN
('S' ,...
...
S2:SELECT COUNT(* ) FROM "DWH_ADMIN"."AUFENTHALT" WHERE ((("AUFN_ART" IN
('S' ,...
...
S2:MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
PARSE : CMD :
WARNING: W--3------------
...
S2:MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
EXECUTE: CMD :
PARSEID: INPUT : 00015D45 00000401 2A002B00 01000000
PARAMETER DESCRIPTION: 0X08BCE338
Application Kernel
...
S2:CLOSE "SQL_CURSOR_0001"
...
S2:CLOSE "SQL_CURSOR_0001"
....
S2: DISCONNECT
DATASOURCE: leipool
SESSION : 2;
SQLMODE : INTERN
SERVERDB : LEIPOOL
SERVERNODE: leipool
CONNECT "LAMMINGERPROD " IDENTIFIED BY :A ISOLATION LEVEL 1
START : DATE : 2003-07-02 TIME : 0016:48:20
END : DATE : 2003-07-02 TIME : 0016:48:20
.....
S2:SELECT "BHF_NR" ,"AUFN_ZPKT" ,"DIA_KATALOG" ,"DIA_ART" ,"DIA_GEWICHTUNG"
,
....
S2:SELECT "BHF_NR" ,"AUFN_ZPKT" ,"DIA_KATALOG" ,"DIA_ART" ,"DIA_GEWICHTUNG"
,
......
and so on
The same program with Adabas D worked fine.
Does someone has any idea how to improve this?
Greetings
Uli
____________________________________________________
Ulrich Lickert, Universitaetsklinikum Freiburg
Klinikrechenzentrum, Agnesenstr. 6-8, D-79106 Freiburg
Tel +49-761-270-2265 Fax +49-761-270-2066
Email [EMAIL PROTECTED]
WWW: http://www.uniklinik-freiburg.de/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
