Database Startup and Shutdown

[Franky Brandt]

I just learned about the ability to shutdown a database and bring it back online again, (after using interbase / firebiard for 33 years), see
https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/gfix/firebird-gfix.html#gfix-dbstartstop

I know this can be done with gfix but does anyone know of Delphi components (firedac, ibobjects, unidac) that do the same?
Like there are components for the backup service, restore service etc

[Stefan Heymann]

In IBDAC (www.devart.com) there is a TIbcConfigService that you can use to set the shutdown mode. In IBO there is a TIboConfigService component. Maybe there is such a ConfigService component in the other suites, too?

You can get the currrent shutdown mode from the header statistics.

HTH

Best Regards

Stefan

[Dimitry Sibiryakov]

Franky Brandt wrote 30.04.2024 11:57:
> I know this can be done with gfix but does anyone know of Delphi components
> (firedac, ibobjects, unidac) that do the same?

For FireDAC:

> IBAdvanced The ';' separated list of additional parameters. You can find the full list of supported parameters in the FireDAC.Phys.IBWrapper unit (see the DPBInfos constant array). You can find the description of each Code listed there in the Interbase/Firebird manuals.

Look at this array and if you see isc_dpb_shutdown/online - you can use them.
Otherwise this example is exactly what you are asking about:
https://docwiki.embarcadero.com/Libraries/Athens/en/FireDAC.Phys.IBBase.TFDIBConfig

The same for the rest.

--
WBR, SD.

[Pavel Cisar]

Hi,

Dne 30. 04. 24 v 12:03 Stefan Heymann napsal(a):

>
>> I just learned about the ability to shutdown a database and bring it back
>> online again, (after using interbase / firebiard for 33 years), see
>> https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/gfix/firebird-gfix.html#gfix-dbstartstop
>
>> I know this can be done with gfix but does anyone know of Delphi components
>> (firedac, ibobjects, unidac) that do the same?
>> Like there are components for the backup service, restore service etc
>
> In IBDAC (www.devart.com) there is a TIbcConfigService that you can use to set the shutdown mode. In IBO there is a TIboConfigService component. Maybe there is such a ConfigService component in the other suites, too?

Yes, IBX for Lazarus from MWA (https://mwasoftware.co.uk/ibx) supports
it too, see TIBXConfigService. The advantage over IBO or IBDAC is that
IBX is open source.

best regards
Pavel Cisar
IBPhoenix

[Franky Brandt]

All clear, thanks guys!

Op dinsdag 30 april 2024 om 12:14:37 UTC+2 schreef pci...@gmail.com:

[Stefan Heymann]

>> In IBDAC (www.devart.com) there is a TIbcConfigService that you can use to set the shutdown mode. In IBO there is a TIboConfigService component. Maybe there is such a ConfigService component in the other suites, too?

> Yes, IBX for Lazarus from MWA (https://mwasoftware.co.uk/ibx) supports it too, see TIBXConfigService.

> The advantage over IBO or IBDAC is that IBX is open source.

It is possible to purchase IBDAC and IBO with the sources. You probably mean "free" instead of "open source".


Regards

Stefan

[Hamish Moffatt]

On 30/04/2024 11:35 pm, Stefan Heymann wrote:

The advantage over IBO or IBDAC is that IBX is open source.

It is possible to purchase IBDAC and IBO with the sources. You probably mean "free" instead of "open source".

Open source does not just mean "source available", it means you can modify it and share it.

Hamish

[Mark Rotteveel]

Paying for access to the sources is source available, not open source.

Mark
--
Mark Rotteveel