Max transaction limit , Gfix and Gbak

[Asmita Kulkarni]

Hi FB support team ,

 

Here is the background and queries about Max Transaction Limit issue Script Deployment

 

Firebird Setup

We are using database Firebird 2.5 .

 

Firebird  runs in Embedded mode, wrapped in a WCF service .

 

Section A

It installs  following files

•         fbembed.dll

•         firebird.conf

•         firebird.msg

•         ib_util.dll

•         icudt30.dll

•         icuin30.dll

•         icuuc30.dll

Also It installs ADO driver :

FirebirdSql.Data.FirebirdClient.dll

 

After certain number of transactions user encounters max transaction limit on database file.

 

To resolve this issue (Max Transaction Issue )

 

He / She runs following script procedure to reset the transaction counter.

 

          gfix -user SYSDBA -password psw -mode read_only EXAMPLEDB.FDB

          gbak -user SYSDBA -password psw -backup EXAMPLEDB.FDB BKPEXAMPLEDB.FDB

          ren "EXAMPLEDB.FDB" "ORGEXAMPLEDB.FDB"

          gbak -user SYSDBA -password psw -create BKPEXAMPLEDB.FDB EXAMPLEDB.FDB

 

This script can reset transaction count of FDB file to 0 successfully.

 

On this Background There are couple of questions

 

1.       Is there a API for gfix tool, which can be programmatically called to change database mode to read_only?

 

2.       Above script procedure only worked when Firebird 2.5 was fully installed when  script and FDB file copied to Bin folder where gfix and gbak are located. 

          So the question is When this script is copied along with gfix and gbak tools to location where embedded dlls from section A are copied.

          Script was not able to run successfully. It could not run gfix successfully.

          How to deploy gfix and gbak tools along with embedded dlls ? What are the dependencies of these tools?

          Is it be possible to run these tools without installing Firebird database completely?

 

Thanks

         

[Jiří Činčura]

> 1. Is there a API for gfix tool, which can be programmatically called
> to change database mode to read_only?

Yes, look at FbConfiguration class.

> 2. Above script procedure only worked when Firebird 2.5 was fully
> installed when script and FDB file copied to Bin folder where gfix and
> gbak are located.

You don't even have to use these binaries. You can use FbBackup and FbRestore and do it programatically.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/