As opposed to going through the hassels of PTR records and dns, try adding the ips and hostnames of the client machines to the /etc/hosts on the linux box. That should resolve your connect time issues.
Sean ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 4:28 AM Subject: sapdb.general digest, Vol 1 #495 - 12 msgs > Send sapdb.general mailing list submissions to > [EMAIL PROTECTED] > > To subscribe or unsubscribe via the World Wide Web, visit > http://listserv.sap.com/mailman/listinfo/sapdb.general > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of sapdb.general digest..." > > > Today's Topics: > > 1. RE:function and procedure (Anhaus, Thomas) > 2. Re: newbie question: Installing sapdb on linux (Stephan Stapel) > 3. performance and index; stored procedures (=?iso-8859-1?Q?Florian_K=E4rner?=) > 4. RE: Newbie question: creating a user (Zabach, Elke) > 5. very slow performance to SAP DB (Andreas Ernst) > 6. RE: problem on create view (Zabach, Elke) > 7. RE: performance and index; stored procedures (Zabach, Elke) > 8. Re: very slow performance to SAP DB (Simon Matter) > 9. RE: SELECT ORDERED (Zabach, Elke) > 10. RE:performance and index; stored procedures (Anhaus, Thomas) > 11. Re: very slow performance to SAP DB (Andreas Ernst) > 12. Re: very slow performance to SAP DB (Simon Matter) > > --__--__-- > > Message: 1 > From: "Anhaus, Thomas" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE:function and procedure > Date: Wed, 2 Oct 2002 07:50:38 +0200 > > Samuel wrote : > > >Did SAPDB support function / procedure / package as oracle do ? if > >yes, is there any utilitity or straight forware method to transfer the > >function / procedure/ package from oracle database to SAPDB. > > for the present SAPDB supports db-procedures, but no db-functions or packages. > There is no tool or straight forward method to migrate from the oracle language > (PL-SQL) to the SAPDB language. > > Thomas > > -- > Thomas Anhaus > SAP DB, SAP Labs Berlin > [EMAIL PROTECTED] > http://www.sapdb.org/ > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > --__--__-- > > Message: 2 > From: "Stephan Stapel" <[EMAIL PROTECTED]> > To: "Richard Hyatt" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Subject: Re: newbie question: Installing sapdb on linux > Date: Wed, 2 Oct 2002 09:21:54 +0200 > > Hi! > > > Are you sure that the data and log files are large enough - I had a > > similar problem under Windows. Make the size at least 25MB for each - > > seemed to work for me. > > Thanks for that comment. However, it didn't succeed. I increased the space > by using the dbmcli param_adddevspace command but with no success. When > starting the database (as stated in the test db script) by using > "dbmcli -d DATABASENAME -u dbm,dbm db_start" > > I get the error > > "-24994,ERR_RTE: runtime environment error > 1,Kernel died before reaching COLD state" > > Is there a place to look for what exactly happened? And if so, what shall I > look for? > > Thanks for your comments in advance! > > Stephan > > > --__--__-- > > Message: 3 > From: =?iso-8859-1?Q?Florian_K=E4rner?= <[EMAIL PROTECTED]> > To: "SAPDB Mailing List" <[EMAIL PROTECTED]> > Subject: performance and index; stored procedures > Date: Wed, 2 Oct 2002 09:38:56 +0200 > > Hi, > I have two questions concerning "weird" effects I encountered while working > with a SAPDB: > > 1. I access a database in a c++-program via ODBC. The program performs an > action that uses many SELECTs that return many rows. The action takes about > 28 secs. Then I add an index to the database that contains a foreign key > that is used in a join in the SELECTs, and the same action takes only about > 1.5 secs. Then I disable that index, and the same action takes about 3 secs. > How can that be? I repeated this, to be sure it isn't an effect of the > cache?? > > 2. I use a stored procedure that is called by the program. It works fine. > Then I add a new column to a table that isn't even used in the stored > procedure. Now every call of the stored procedure causes the database to go > offline. Logfile dbm.prt says "command param_abortsession". Then I delete > and recreate the stored procedure and everything is fine again. Why? > > Thanks in advance, > > Florian K�rner > > > --__--__-- > > Message: 4 > From: "Zabach, Elke" <[EMAIL PROTECTED]> > To: "'Zsolt Almasi'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: Newbie question: creating a user > Date: Wed, 2 Oct 2002 09:38:30 +0200 > > Zsolt Almasi wrote: > > > Can you tell me , how can I create a Standard user ? I will > > apreciate if you > > can show me some examples ! > > the reference-manual is too complicate to understand this? > (see chapter Authorization --> create user ) > http://www.sapdb.org/htmhelp/48/f0daa5225811d3a97d00a0c9449261/frameset.htm > > example > create user xyz password abc > > Elke > SAP Labs Berlin > > --__--__-- > > Message: 5 > Date: Wed, 02 Oct 2002 09:39:40 +0200 > From: Andreas Ernst <[EMAIL PROTECTED]> > Organization: Andreas Ernst Publishing & Software > To: SAPDB <[EMAIL PROTECTED]> > Subject: very slow performance to SAP DB > > Hi to all, > > i have a strange problem.... > > I have on SuSE Linux 8.0 installed SAP DB 7.3.0 Build 024-000-085-555 > and MySQL ( one of the latest). > > In my network i have two computers (W2K, Win98 SE) with them the > connection to SAP DB takes a long time. > > From the W2K i tried to connect via JDBC-Explorer (JBuilder 4) to the > SAP DB and for testing to the MySQL, with MySQL the connection time is > normal, with SAP DB it takes a long time. > > Here is a piece of my log4j-File, how it is on the W2K computer and how > it is normal: > > normal: > 09:28:26 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > bearbeiten > 09:28:28 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > > very slow: > 09:26:20 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > bearbeiten > 09:28:56 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > > The performance is normally __TWO__SECONDS__ and not __TWO__MINUTES__ > In this time while this computer is connected to SAP DB all connection > are very slow..... > > Connecting from the W2K machine to SAP DB 7.3.0. (Build 025) on a W2K > machine, the speed is normal... > > I have really no idea, how to solve this strange behavior. > > If anybody has ideas, please let me know. > > regards > Andreas > > > > --__--__-- > > Message: 6 > From: "Zabach, Elke" <[EMAIL PROTECTED]> > To: "'Marty Chiu'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: problem on create view > Date: Wed, 2 Oct 2002 09:47:36 +0200 > > Marty Chiu wrote: > > please help > > I would like to create a view with joining 3 table > > together, but don't know the syntax > > > > tables: > > department: id(pk),fdept > > equipment: id(pk),model > > equipment_detail: > > id(pk),dept_id(fk),equip_id(fk),serial_no > > > > relationship: > > department(1)--(m)equipment_detail(m)--(1)equipment > > > > field to be displayed: department.fdept, > > equipment.model, equipment_detail.serial_no > > > > where condition: > > department.id=equipment_detail.dept_id, > > equipment.id=equipment_detail.equip_id > > You know how to select with a normal select-statement like > > select mycol, secondcol > from tab1, tab2 > where tab1.col10 = tab2.col7 > > and just put a > create view <viewname> as > in front of this > > see reference manual --> data definition --> create view > > http://www.sapdb.org/htmhelp/6d/117c44d14811d2a97400a0c9449261/frameset.htm > > Elke > SAP Labs Berlin > > --__--__-- > > Message: 7 > From: "Zabach, Elke" <[EMAIL PROTECTED]> > To: =?iso-8859-1?Q?=27Florian_K=E4rner=27?= <[EMAIL PROTECTED]>, > SAPDB Mailing List <[EMAIL PROTECTED]> > Subject: RE: performance and index; stored procedures > Date: Wed, 2 Oct 2002 09:59:17 +0200 > > Florian K�rner wrote : > > > 1. I access a database in a c++-program via ODBC. The program > > performs an > > action that uses many SELECTs that return many rows. The > > action takes about > > 28 secs. Then I add an index to the database that contains a > > foreign key > > that is used in a join in the SELECTs, and the same action > > takes only about > > 1.5 secs. Then I disable that index, and the same action > > takes about 3 secs. > > How can that be? I repeated this, to be sure it isn't an effect of the > > cache?? > > The SAP DB optimizer uses some statistic-info about the size of the tables. > Depending on this known size (may differ from the current size if > update statistics was not done for a long time or many inserts/deletes were > done on at least one of those tables) the optimizer decides for a strategy > and the sequence in which those tables are handled. > If an index is created, one has to hurry through the whole primary data of > the corresponding table. And the statistic info is then stored in memory > and can be used for the optimizer. Even after dropping the index, this > info remains as it remains after update statistics. > And other statistic info may result in other strategy and sequence of tables handled. > And then the time for selecting may differ. > The difference between 1,5 and 3 seconds is because of the missing index, > the difference between 3 and 28 because of old/wrong statistic info. > > See output of explain for all of your selects and you will the differences for the > used strategy. > > And do some update statisttics from time to time. > http://www.sapdb.org/htmhelp/3b/86f067458411d3a98200a0c9449261/frameset.htm > > Elke > SAP Labs Berlin > > --__--__-- > > Message: 8 > Date: Wed, 02 Oct 2002 10:01:04 +0200 > From: Simon Matter <[EMAIL PROTECTED]> > Organization: Sauter AG, Basel > To: Andreas Ernst <[EMAIL PROTECTED]> > Cc: SAPDB <[EMAIL PROTECTED]> > Subject: Re: very slow performance to SAP DB > > Andreas Ernst schrieb: > > > > Hi to all, > > > > i have a strange problem.... > > > > I have on SuSE Linux 8.0 installed SAP DB 7.3.0 Build 024-000-085-555 > > and MySQL ( one of the latest). > > > > In my network i have two computers (W2K, Win98 SE) with them the > > connection to SAP DB takes a long time. > > > > From the W2K i tried to connect via JDBC-Explorer (JBuilder 4) to the > > SAP DB and for testing to the MySQL, with MySQL the connection time is > > normal, with SAP DB it takes a long time. > > > > Here is a piece of my log4j-File, how it is on the W2K computer and how > > it is normal: > > > > normal: > > 09:28:26 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > > bearbeiten > > 09:28:28 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > > > > very slow: > > 09:26:20 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > > bearbeiten > > 09:28:56 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > > > > The performance is normally __TWO__SECONDS__ and not __TWO__MINUTES__ > > In this time while this computer is connected to SAP DB all connection > > are very slow..... > > Check your DNS configuration! > > Simon > > > > > Connecting from the W2K machine to SAP DB 7.3.0. (Build 025) on a W2K > > machine, the speed is normal... > > > > I have really no idea, how to solve this strange behavior. > > > > If anybody has ideas, please let me know. > > > > regards > > Andreas > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > --__--__-- > > Message: 9 > From: "Zabach, Elke" <[EMAIL PROTECTED]> > To: "'Richard Hyatt'" <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Subject: RE: SELECT ORDERED > Date: Wed, 2 Oct 2002 10:11:01 +0200 > > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01C269EB.3F122520 > Content-Type: text/plain; > charset="iso-8859-1" > > Richard Hyatt wrote: > > > I'm still quite new to SAPDB and was wondering if anyone had a simple example of the SELECT ORDERED statement. I'm trying to > > implement functionality similar to mySQL/PHP's LIMIT function. I found several references to ROWNO, but that will only work in one > > direction. I need to be able to move 1 page back (eg. 50 rows) from a current location. I know that it is possible to use cursors, but I thought > > that SELECT ORDERED may be an alternative. > > select ordered will just return one row. You will have to specify 50 select ordered-statements to > return those 50 rows (communication-time !!!) and you will have to assure that your > table-keys are specified correctly each time. > > And select ordered will not be available with the next MAJOR release (7.4) > > --> it is an idea, but it is not the best one. > > I think, using ROWNO will be a better solution. > But please pay attention to the fact, that using ROWNO together with a join > will not minimize the work load to produce intermediate results (they will have > the same size with and without ROWNO), but only the final result will stop > after finding ROWNO results. > We had a customer using ROWNO with join, selecting 100 results, then > changing the where-clause a little bit to assure to receive the results 101-200, > then 201-300. And that is a very bad way for the kernel. > Instead of this, one should check if the full join (without ROWNO) should be prepared > and then a select * from <join-resultset> where ... can be used. > > Elke > SAP Labs Berlin > > ------_=_NextPart_001_01C269EB.3F122520 > Content-Type: text/html; > charset="iso-8859-1" > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > <TITLE>Message</TITLE> > > <META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD> > <BODY> > <DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002><FONT face=Tahoma color=#000000>Richard Hyatt<FONT > face=Arial color=#0000ff> > wrote:</FONT></FONT></SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002></SPAN></FONT></FONT></SPAN> </DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>> </SPAN></FONT></FONT></SPAN><SPAN > class=175275115-01102002><FONT color=#0000ff size=2>I'm still quite new to SAPDB > and was wondering if anyone had a simple example of the SELECT ORDERED > statement. I'm trying to </FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>> </SPAN>implement functionality similar to > mySQL/PHP's LIMIT function. I found several references to ROWNO, but that will > only work in one </FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>> </SPAN>direction. I need to be able to move 1 page > back (eg. 50 rows) from a current location. I know that it is possible to use > cursors, but I thought </FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>> </SPAN>that SELECT ORDERED may be an > alternative.<SPAN > class=809370008-02102002> </SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002></SPAN></FONT></FONT></SPAN> </DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>select ordered will just return one row. You will have > to specify 50 select ordered-statements to</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>return those 50 rows (communication-time !!!) and you > will have to assure that your</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>table-keys are specified correctly each > time.</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002></SPAN></FONT></FONT></SPAN> </DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>And select ordered will not be available with the next > MAJOR release (7.4)</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002></SPAN></FONT></FONT></SPAN> </DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>--> it is an idea, but it is not the best > one.</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002></SPAN></FONT></FONT></SPAN> </DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>I think, using ROWNO will be a better > solution.</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>But please pay attention to the fact, that using ROWNO > together with a join</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>will not minimize the work load to produce intermediate > results (they will have</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>the same size with and without ROWNO), but only the > final result will stop</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>after finding ROWNO > results.</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>We had a customer using ROWNO with join, selecting 100 > results, then</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>changing the where-clause a little bit to assure to > receive the results 101-200,</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>then 201-300. And that is a very bad way for the > kernel.</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>Instead of this, </SPAN></FONT></FONT></SPAN><SPAN > class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>one should check if the full join (without ROWNO) > should be prepared</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>and then a select * from <join-resultset> where > ... can be used.</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002></SPAN></FONT></FONT></SPAN> </DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>Elke</SPAN></FONT></FONT></SPAN></DIV> > <DIV><SPAN class=175275115-01102002><FONT color=#0000ff><FONT size=2><SPAN > class=809370008-02102002>SAP Labs > Berlin </SPAN></FONT></FONT></SPAN></DIV></DIV></BODY></HTML> > > ------_=_NextPart_001_01C269EB.3F122520-- > > --__--__-- > > Message: 10 > From: "Anhaus, Thomas" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE:performance and index; stored procedures > Date: Wed, 2 Oct 2002 10:28:46 +0200 > > Florian K�rner wrote : > > >2. I use a stored procedure that is called by the program. It works fine. > >Then I add a new column to a table that isn't even used in the stored > >procedure. Now every call of the stored procedure causes the database to go > >offline. Logfile dbm.prt says "command param_abortsession". Then I delete > >and recreate the stored procedure and everything is fine again. Why? > > This is a known problem. The stored procedure is compiled when the > create dbproc statement is executed. > If a table used in the stored procedure is altered afterwards, > the stored procedure has to recompiled. > Up to now this is not done automatically, but it's on our TODO list. > > Thomas > > -- > Thomas Anhaus > SAP DB, SAP Labs Berlin > [EMAIL PROTECTED] > http://www.sapdb.org/ > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > --__--__-- > > Message: 11 > Date: Wed, 02 Oct 2002 10:30:41 +0200 > From: Andreas Ernst <[EMAIL PROTECTED]> > Organization: Andreas Ernst Publishing & Software > To: Simon Matter <[EMAIL PROTECTED]>, > SAPDB <[EMAIL PROTECTED]> > Subject: Re: very slow performance to SAP DB > > Simon Matter schrieb: > > >Andreas Ernst schrieb: > > > > > >>Hi to all, > >> > >>i have a strange problem.... > >> > >>I have on SuSE Linux 8.0 installed SAP DB 7.3.0 Build 024-000-085-555 > >>and MySQL ( one of the latest). > >> > >>In my network i have two computers (W2K, Win98 SE) with them the > >>connection to SAP DB takes a long time. > >> > >> From the W2K i tried to connect via JDBC-Explorer (JBuilder 4) to the > >>SAP DB and for testing to the MySQL, with MySQL the connection time is > >>normal, with SAP DB it takes a long time. > >> > >>Here is a piece of my log4j-File, how it is on the W2K computer and how > >>it is normal: > >> > >>normal: > >>09:28:26 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > >>bearbeiten > >>09:28:28 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > >> > >>very slow: > >>09:26:20 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > >>bearbeiten > >>09:28:56 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > >> > >>The performance is normally __TWO__SECONDS__ and not __TWO__MINUTES__ > >>In this time while this computer is connected to SAP DB all connection > >>are very slow..... > >> > >> > > > >Check your DNS configuration! > > > >Simon > > > > > > > >>Connecting from the W2K machine to SAP DB 7.3.0. (Build 025) on a W2K > >>machine, the speed is normal... > >> > >>I have really no idea, how to solve this strange behavior. > >> > >>If anybody has ideas, please let me know. > >> > >>regards > >>Andreas > >> > >>_______________________________________________ > >>sapdb.general mailing list > >>[EMAIL PROTECTED] > >>http://listserv.sap.com/mailman/listinfo/sapdb.general > >> > >> > >_______________________________________________ > >sapdb.general mailing list > >[EMAIL PROTECTED] > >http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > > > > > I did, i found no problems, i connect via a TCP/IP-adress. > I have a second W2K computer, the DNS configs on this computers are the > same, with the other computer, i have _no_ connection problems. > > regards > Andreas > > > > > --__--__-- > > Message: 12 > Date: Wed, 02 Oct 2002 10:37:08 +0200 > From: Simon Matter <[EMAIL PROTECTED]> > Organization: Sauter AG, Basel > To: Andreas Ernst <[EMAIL PROTECTED]> > Cc: SAPDB <[EMAIL PROTECTED]> > Subject: Re: very slow performance to SAP DB > > Andreas Ernst schrieb: > > > > Simon Matter schrieb: > > > > >Andreas Ernst schrieb: > > > > > > > > >>Hi to all, > > >> > > >>i have a strange problem.... > > >> > > >>I have on SuSE Linux 8.0 installed SAP DB 7.3.0 Build 024-000-085-555 > > >>and MySQL ( one of the latest). > > >> > > >>In my network i have two computers (W2K, Win98 SE) with them the > > >>connection to SAP DB takes a long time. > > >> > > >> From the W2K i tried to connect via JDBC-Explorer (JBuilder 4) to the > > >>SAP DB and for testing to the MySQL, with MySQL the connection time is > > >>normal, with SAP DB it takes a long time. > > >> > > >>Here is a piece of my log4j-File, how it is on the W2K computer and how > > >>it is normal: > > >> > > >>normal: > > >>09:28:26 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > > >>bearbeiten > > >>09:28:28 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > > >> > > >>very slow: > > >>09:26:20 simon.MaschinenListe.bearbeiten(MaschinenListe.java:2094) > > >>bearbeiten > > >>09:28:56 simon.MaschinenListe.bohren(MaschinenListe.java:2137) bohren > > >> > > >>The performance is normally __TWO__SECONDS__ and not __TWO__MINUTES__ > > >>In this time while this computer is connected to SAP DB all connection > > >>are very slow..... > > >> > > >> > > > > > >Check your DNS configuration! > > > > > >Simon > > > > > > > > > > > >>Connecting from the W2K machine to SAP DB 7.3.0. (Build 025) on a W2K > > >>machine, the speed is normal... > > >> > > >>I have really no idea, how to solve this strange behavior. > > >> > > >>If anybody has ideas, please let me know. > > >> > > >>regards > > >>Andreas > > >> > > >>_______________________________________________ > > >>sapdb.general mailing list > > >>[EMAIL PROTECTED] > > >>http://listserv.sap.com/mailman/listinfo/sapdb.general > > >> > > >> > > >_______________________________________________ > > >sapdb.general mailing list > > >[EMAIL PROTECTED] > > >http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > > > > > > > > > > I did, i found no problems, i connect via a TCP/IP-adress. > > I have a second W2K computer, the DNS configs on this computers are the > > same, with the other computer, i have _no_ connection problems. > > That doesn't mean anything. If the server makes reverse lookup and one > of the W2K computers has PTR records, the other doesn't, it's a > difference even if both W2K computers are configured the same way. > > Simon > > > > > regards > > Andreas > > > --__--__-- > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > End of sapdb.general Digest _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
