Subject | Re: [firebird-support] Re: DB modified date is over a month old, but Forced Writes are ON?? |
---|---|
Author | Norman Dunbar |
Post date | 2011-06-09T19:36:06Z |
Evening all,
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html
The "completely sdhut down the database" command would be:
gfix -shut full -attach 0 <database>
(That's a zero by the way)
A full shutdown prevents even sysdba from getting a connection.
Then check it with:
gstat -header <database> | grep Attributes
Attributes full shutdown
So, restarting it afterwards is just as simple:
gfix -online normal <database>
Might be useful to Raymond.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
> Check the release notes - I'm really not an expert in the shutdown modes.There are details here in the gfix manual:
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html
The "completely sdhut down the database" command would be:
gfix -shut full -attach 0 <database>
(That's a zero by the way)
A full shutdown prevents even sysdba from getting a connection.
Then check it with:
gstat -header <database> | grep Attributes
Attributes full shutdown
So, restarting it afterwards is just as simple:
gfix -online normal <database>
Might be useful to Raymond.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767