11. Database Startup and Shutdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 11.1. Database Shutdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 11.3. New Startup and Shutdown States in Firebird 2.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . -at(tach) shutdown new database attachments -b(uffers) set page buffers -co(mmit) commit transaction -ca(che) shutdown cache manager -fu(ll)

the shared cache file was disabled. hdr_shutdown_mask (bit one of two) 0x1080 (bits 7 and 12) Used with bit 12 (see below) to indicate the database shutdown mode. hdr_sql_dialect_3 0x100 (bit 8) If Indicates the current backup mode. hdr_shutdown_mask (bit two of two) 0x1080 (bits 7 and 12) Used with bit 7 (see above) to indicate the database shutdown mode. The final two database flags use use a pair of bits to indicate various states of backup and shutdown. hdr_backup_mask These two bits determine the current database backup mode, as follows: Flag Value Description 0x00 (Both bits zero)

-837 335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database %s shutdown in %d seconds -841 335544677 version_err Too many versions -842 335544697 precision_err Precision 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -901 335740947 gfix_type_shut Must specify type of shutdown -901 335544340 infona No information of this type available for object specified -901 336330772 invalid_savepoint Unable to find savepoint with name %s in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "%s" Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT

-837 335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database @1 shutdown in @2 seconds -841 335544677 version_err Too many versions -842 335544697 precision_err Precision 336723986 gsec_no_usr_name No user name specified -901 335740947 gfix_type_shut Must specify type of shutdown -901 335544339 infinap Information type inappropriate for object specified -901 336723987 gsec_err_add invalid_savepoint Unable to find savepoint with name @1 in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "@1" -901 335544840 no_update Cannot update -901 335544842

the occasional need to turn it off for some once-only condition where the server needs a forced shutdown. The gfix utility now has the -NoLinger switch, which will close the specified database immediately CHANGE_SHUTDOWN_MODE Shut down database and bring online TRACE_ANY_ATTACHMENT Trace other users' attachments MONITOR_ANY_ATTACHMENT Monitor (tables MON$) other users' attachments ACCESS_SHUTDOWN_DATABASE READ_RAW_PAGES | CREATE_USER_TYPES | USE_NBACKUP_UTILITY | CHANGE_SHUTDOWN_MODE | TRACE_ANY_ATTACHMENT | MONITOR_ANY_ATTACHMENT | ACCESS_SHUTDOWN_DATABASE | CREATE_DATABASE | DROP_DATABASE | USE_GBAK_UTILITY

Restart shared cache manager. Рестарт общего менеджера КЭШа. -838 335544560 shutwarn Database @1 shutdown in @2 seconds. База данных @1 уйдет в состояние шатдаун через @2 секунд. -841 335544677 version_err specified. Не определено имя пользователя. -901 335740947 gfix_type_shut Must specify type of shutdown. Требуется определить тип шатдауна. -901 335544339 infinap Information type inappropriate for найти точку сохранения транзакции с именем @1 в контексте транзакции -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "@1" Указание режима «шатдауна» неверное для базы данных

335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database shutdown in seconds -841 335544677 version_err Too many versions -842 335544697 precision_err value between 0 and 32767 inclusive required -901 335740947 gfix_type_shut Must specify type of shutdown -901 335740948 gfix_retry Please retry, specifying an option -901 335740951 gfix_retry_db Please -902 335544506 shutinprog Database shutdown in progress -902 335544528 shutdown Database shutdown -902 335544557 shutfail Database shutdown unsuccessful -902 335544569 dsql_error Dynamic

-837 335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database @1 shutdown in @2 seconds -841 335544677 version_err Too many versions -842 335544697 precision_err Precision 336723986 gsec_no_usr_name No user name specified -901 335740947 gfix_type_shut Must specify type of shutdown -901 335544339 infinap Information type inappropriate for object specified -901 335544340 infona invalid_savepoint Unable to find savepoint with name @1 in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "@1" -901 335544840 no_update Cannot update -901 335544842

-837 335544518 cache_restart restart shared cache manager -838 335544560 shutwarn database @1 shutdown in @2 seconds -839 335544686 jrn_format_err journal file wrong format -840 335544687 jrn_file_full invalid_savepoint Unable to find savepoint with name @1 in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "@1" -901 335544840 no_update cannot update -901 335544842 isc_tpb_lock_write in TPB because the transaction is in read only mode -901 335544917 shutdown_timeout Firebird shutdown is still in progress after the specified timeout Anhang B: Fehlercodes und Meldungen

Ser- vices Manager (Administrador de Servicios), tareas de soporte como backup/restore, data- base shutdown (sacar de línea la base de datos) etc. a través de la red. Otras tareas de servi- cio tienen que (en Windows y Linux) que le permite realizar tareas de administración (backup/resto- re, database shutdown, manejo de usuarios, estadísticas, etc.) programáticamente. Se puede conectar al Administrador de herramienta de administración preferida. Si la base de datos restaurada es correcta, desactive (shutdown) el servidor. Haga una copia del archivo de la antigua base de datos y luego copie el archivo (o