Firebird shutdown and restart - Forums

Additional

	Forums	Categories Rules

Welcome, Guest
Please Login or Register to post messages. Lost Password?

Forums

AnyDAC

AnyDAC General English

Firebird shutdown and restart

(1 viewing) 1 Guest

TOPIC: Firebird shutdown and restart

Forum Tools

#21533

StefanEschenlohr

Fresh Boarder

Posts: 3

Karma: 1

Firebird shutdown and restart 2012/07/20 03:06 (10 Months ago)
Hello, are there any AnyDac functions to shutdown or restart a firebird database using delphi code? thx
Logged
The administrator has disabled public write access.

#21536

Support

Moderator

Posts: 5635

Karma: 99

Re:Firebird shutdown and restart 2012/07/20 04:15 (10 Months ago)

Hello

You can shutdown database using connection definition parameter:

Code:

IBAdvanced=shutdown=<mode>

There mode is the mask consisting of the flags:

Code:



  // ---------------------------------------------------------------------------

  // isc_dpb_shutdown specific flags

  // ---------------------------------------------------------------------------

  isc_dpb_shut_cache        = $1;

  isc_dpb_shut_attachment   = $2;

  isc_dpb_shut_transaction  = $4;

  isc_dpb_shut_force        = $8;

  // FB20

  isc_dpb_shut_mode_mask    = $70;

  isc_dpb_shut_default      = $00;

  isc_dpb_shut_normal       = $10;

  isc_dpb_shut_multi        = $20;

  isc_dpb_shut_single       = $30;

  isc_dpb_shut_full         = $40;

There is no possibility just to restart DB database. Also, I am not sure what really happens when IBAdvanced=shutdown is specified.

With best regards,
DA-SOFT Technologies Support Team

Logged

The administrator has disabled public write access.

#21564

tommi

Senior Boarder

Posts: 47

Karma: 2

Re:Firebird shutdown and restart 2012/07/24 06:17 (10 Months ago)
Is there no way to use firebird's gfix with AnyDAC (e.g. as a service like gbak)?
Logged
The administrator has disabled public write access.

#21567

Support

Moderator

Posts: 5635

Karma: 99

Re:Firebird shutdown and restart 2012/07/24 23:15 (9 Months, 4 Weeks ago)
You should use TADIBValidate component: www.da-soft.com/anydac/docu/uADPhysIB_TADIBValidate.html
With best regards, DA-SOFT Technologies Support Team
Logged
The administrator has disabled public write access.

#21569

tommi

Senior Boarder

Posts: 47

Karma: 2

Re:Firebird shutdown and restart 2012/07/25 01:51 (9 Months, 4 Weeks ago)

Ok. But gfix offers the following commands:

Shutdown all connections and only allow a single connection to a database:

Code:

gfix -shut single -force 0 database.fdb

Allow multiple connections from a SYSDBA/owner of the database:

Code:

gfix -shut multi -force 0 database.fdb

Go from single to multi mode, use:

Code:

gfix -online multi database.fdb

To bring the database fully online, just use the -online switch without any parameters:

Code:

gfix -online database.fdb

Is it possible to use AnyDAC for this commands?

Logged

The administrator has disabled public write access.

#21570

Support

Moderator

Posts: 5635

Karma: 99

Re:Firebird shutdown and restart 2012/07/25 20:42 (9 Months, 4 Weeks ago)

Additionally it is possible to specify

Code:

IBAdvanced=online=<mode>

Also, we will extend TADIBValidate to support Shutdown / Online.

With best regards,
DA-SOFT Technologies Support Team

Logged

The administrator has disabled public write access.

Forum List

AnyDAC

AnyDAC General English