-icu fix database to be usable with present ICU version -k(ill_shadow) kill all unavailable shadow files -l(ist) show limbo transactions -me(nd) shadow files and prevents the database ever running without one. 4.2. Killing Shadows The command to kill all unavailable database shadows, for a specific database, is: gfix -k[ill_shadow] database_name and once completed, the second (and subsequent) sessions would be able to connect. linux_2> gfix -kill_shadow my_employee linux_2> isql my_employee Database: my_employee SQL> show database; Database:

the database killing shadow files. tux> gfix -shut -tran 60 employee tux> gbak -replace overwrite -kill /backups/employee.fbk employee tux> # Check shadows again, use isql as gstat is broken. tux> isql reports zero when there are two, eventually it catches up and reports that there are two, then, if you kill a shadow, it reports that there are now three! Chapter 6. Backup & Restore Recipes 23 6.11. Remote

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 502 Using MON$ATTACHMENTS to Kill a Connection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . established this connection MON$STAT_ID INTEGER Statistics identifier Using MON$ATTACHMENTS to Kill a Connection Monitoring tables are read-only. However, the server has a built-in mechanism for deleting

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 751 Using MON$ATTACHMENTS to Kill a Connection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . MON$ATTACHMENT_ID <> CURRENT_CONNECTION Appendix E: Monitoring Tables 752 Using MON$ATTACHMENTS to Kill a Connection Monitoring tables are read-only. However, the server has a built-in mechanism for deleting