Practical InterBase Administration

"Practical InterBase Administration Training" is a course for InterBase database administrators, devoted to effective administration, maintenance and optimization of databases.
  1. InterBase distributive files
    1. Files and their purpose (Windows, Linux)
    2. Installation packages
    3. Minor version update
  2. Transactions and versioning engine
    1. Multi-versioning engine – garbage collection, sweep
    2. Transaction control – OIT, OST, OAT, Next
    3. Version control – gstat, Database Analyst
    4. dealing with long-running transactions and garbage
  3. Administrative tasks and command-line tools
    1. isql
    2. gbak ( backup, restore, incremental backups – gbak -di.)
  4. IBCONFIG
    1. Parameters
    2. iblockpr
    3. Optimizing parameters for better performance