Hello, I'm having difficulties using SAPDB 7.3.0.29 on Win2000. Using a Java application (with the latest JDBC driver) I write into the database updating a row (I receive signs of life from another machine and store the time of arrival in the database)
Using the Database Manager 7.4.2.6 I watched the number of locks on the database (instance -> information -> locks). The thing that confuses me is that the number of locks (both row and table locks) only increases. It really never decreases even if I shut down my application. Referring to the manual this is the number of currently held locks. It is possible that there are more than 10.000 table locks in a database containing about 30 tables? (The request timeout is 30 seconds). There is another problem which I think is related to this: (still the same application mentioned above) In some special occasions the remote machine does not send a sign of life but an alert. In this case there a some actions needed to be taken. This causes the application to perform a number of additional database operations (like storing the alert message...) For tests I created an alert every 2 seconds (which resulted in an increased but not extrem load). After about 100 alerts the available space for data started to shrink extrem fast. Of course the where rows inserted but the space was consumed much faster than anticipated. Finally the data space usage reached 50 % (starting at 13 % of 100 MB). At this point no more operations on the database were possible. After restarting the database (online -> offline -> online) the data space usage was back about the value before my test (there was a negligible increase due to the added data). The same application already completed test runs with more than 15.000 alerts when using MySql oder MS SQL-Server. A similar situation never occured there. I'd be grateful for any help I could get (since I'm quite new to SAPDB). i. A. Steven Dolg Software Developer _____________________________ Silverstroke AG Ludwig-Erhard-Stra�e 2 D-76275 Ettlingen Phone +49 (0) 7243 / 346-12 23 Fax +49 (0) 7243 / 346-12 79 <mailto:[EMAIL PROTECTED]> <http://www.silverstroke.com> _____________________________ This mail and any files transmitted with it is intended to be confidential and for the use of only the individual or entity named above. If the reader of this message is not the intended recipient, you are notified that retention, dissemination, distribution or copying of this mail and files transmitted with it is strictly prohibited. If you receive this mail in error, please notify us immediately by mail or phone and delete the mail and any files transmitted with it. Thank you! We also like to inform you that communication via mail over the internet is insecure, and third parties may have the possibility to access or manipulate the mail and any files transmitted with it. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
