[firebird-support] What regular maintenance actions does Firebird need in order to function properly?

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 Besides, backing up my databases and measuring the effectiveness of the page cache, what other regular maintenance actions does Firebird need in order to function properly? thanks in advance

[firebird-support] [FB3 CS] Server stops accepting new connections - lock denied

Classic Server stops accepting new connections, while already active ones continue to work regularly. Load conditions seems irrilevant, we had a total of 4 events in less than a week, two of these during very low load conditions and two in average conditions. Error in firebird.log (this is the

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

03.05.2018 23:04, blackfalconsoftw...@outlook.com [firebird-support] wrote: > However, I though only the issuance one "SUSPEND" was enough to flush the > entire buffer of > all records... No. One SUSPEND - one record in result set. Two SUSPENDs - two records and so on. Watch this in

RE: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

András... Thank you very much for your assistance. Your suggestion seemed to work like a charm. However, I though only the issuance one "SUSPEND" was enough to flush the entire buffer of all records... Steve

RE: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

of records? Thank you... __ Information from ESET Mail Security, version of virus signature database 17326 (20180503) __ The message was checked by ESET Mail Security. http://www.eset.com [Non-text portions of this message have been removed]

[firebird-support] Problem returning multiple rows from a CTE-recursive procedure

Hello... I have been in the process of converting my application's SQL Server T-SQL code to Firebird PSQL procedures. So far so good until I got to the one where I built a Firebird procedure with a recursive CTE in it. The following code is an exact match to my original SQL Server T-SQL

Re: [firebird-support] Proper way to handle an open Firebird database...

On 3-5-2018 17:05, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Yes That is right, I want to backup the database. > > I have a gap in the nigth to do it. > > I understand that by using gbak or nbackup Firebird doesnt need to be > shutdown. Yes, and if you use alter database

Re: [firebird-support] Proper way to handle an open Firebird database...

Thank you On Thursday, May 3, 2018, 10:07:21 AM CDT, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote:   > When I need to copy my Firebird database: Do I need to shutdown the > Firebird instance first? Yes. Becaus when you don't do

Re: [firebird-support] Proper way to handle an open Firebird database...

Yes That is right, I want to backup the database.  I have a gap in the nigth to do it.  I understand that by using gbak or nbackup Firebird doesnt need to be shutdown.  Besides that, is there any other advantage of gbak or nbackup against an ordinary copy of the database? By the way If a need to

Re: [firebird-support] Proper way to handle an open Firebird database...

> When I need to copy my Firebird database: Do I need to shutdown the > Firebird instance first? Yes. Becaus when you don't do that, the server may access the file during your copy process and you would get a corrupt file copy. > and If yes, what is the proper way to shutdown and startup it?

Re: [firebird-support] Proper way to handle an open Firebird database...

03.05.2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > 1. When I need to copy my Firebird database: Do I need to shutdown the > Firebird instance > first? and If y es, what is the proper way to shutdown and startup it? You may shut it down or use nbackup or use

Re: [firebird-support] Proper way to handle an open Firebird database...

On 3-5-2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server 2012R2 > > I have two questions: > > 1. When I need to copy my Firebird database: Do I need to shutdown the > Firebird instance first? and If

[firebird-support] Proper way to handle an open Firebird database...

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 I have two questions: - When I need to copy my Firebird database: Do I need to shutdown the Firebird instance first? and If yes, what is the proper way to shutdown and startup it? - When I need to restart Windows Server,

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

Thank you very much!On Thursday, May 3, 2018, 3:30:32 AM CDT, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote:   03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.27050 64 bits >

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.27050 64 bits > Windows Server 2012R2 > > ¿Is there a way to calculate the effectiveness of incrementing the page cache > buffer ? select cast(mon$page_reads as double

[firebird-support] Measure the effectiveness of incrementing page buffer...

Firebird ver 2.5.7.27050 64 bitsWindows Server 2012R2 ¿Is there a way to calculate the effectiveness of incrementing the page cache buffer ? thanks in advance