All;



Thank you for your efforts. He are a few more details to answer your
questions, below.



We have over 200 customers, each with their own server hardware, network
and IB installation. Each customer has between 10 and 60 concurrent
users (obviously, this varies widely among customers depending on the
size of their business).



The application is written in Delphi with the BDE and does use some of
the VCL Transaction and IB Transaction components included in Delphi,
however, I have not as yet familiarized myself with the transaction
boundary standards that are in use (I've been here for about a month).



This problem occurs with some regularity, although without any obvious,
repeatable characteristics (at least, none that have been discovered as
yet) in terms of some particular transaction or operation. However, in
all cases, the database and server PC become almost completely
unresponsive. Backups are not possible. The system will not recover
until it is rebooted, which, unfortunately, is happening by brute force
(i.e., RESET BUTTON) at the hands of the customer. When the system
comes back up, assuming that IB can open the database, oftentimes
performance is just okay (not great). Once a backup and restore has
been done on the DB, the system then performs as normal for a while.
Please note that this is happening for a smallish subset of our
installed base. We have not as yet been able to identify any universal
connection among the involved customer installations (other than the IB
version 6.0.1.0, which is in most all installations).



I will look into the transaction boundaries for the client application.



Thanks very much for you assistance.



Regards,



Hugh J Borst

hborst@...





-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Tuesday, April 01, 2003 1:29 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: FB & IB Compatibility



On Tue, 1 Apr 2003 15:19:34 +0000 (UTC), hugh_borst
<hborst@...>
wrote:

> My firm is currently using an Open Source IB extensively across our
> enterprise. We are concerned about our upgrade path as we do not want

to

> incur per server license fees for our product. To this end we are
> interested in participating in the FireBird project, however, several
> questions as to compatibility have arisen. If anyone can help answer
> these Qs, we would very much appreciate the assistance.

Hugh, the most important thing now is to sort out the current problems.
As
someone said, the problem may well be with the application: a problem
with
long running transactions. Check the statistics on the header page
(gfix
and IBconsole can show this). If a backup+restore (with gbak) solves
the
speed problem (and in particular if the backup is slow), this indicates
an
application problem. This may be alleviated, but the apps need fixing.

When you say 200 clients, is this ONE server and 200 clients (or 200
server
installations)? If there is one server (or just a few servers) you
should
be able to easily upgrade to a later IB (e.g. 6.0.1.6). I would think
that
client softare need not be upgraded. A move to Firebird (or later IB
versions) will need more work.


[Others have answered the compatibility Q's]


Regards,
Aage J.






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=240537.3105911.4426332.1728375/D=egroupweb/S=1705
115386:HM/A=1368546/R=0/*http:/shop.store.yahoo.com/cgi-bin/clink?netfli
x2+shopping:dmad/M=240537.3105911.4426332.1728375/D=egroupweb/S=17051153
86:HM/A=1368546/R=1/1049225336+http://us.rmi.yahoo.com/rmi/http://www.ne
tflix.com/rmi-framed-url/http://www.netflix.com/Default%3Fmqso=60156051>




<http://us.adserver.yahoo.com/l?M=240537.3105911.4426332.1728375/D=egrou
pmail/S=:HM/A=1368546/rand=419079821>


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]