Practical InterBase Administration

Practical InterBase Administration is for InterBase DBAs: effective maintenance and optimization, parallel to the Firebird administration course.

About 5-6 hours · English · All courses

Syllabus

InterBase distribution files
- Files and their purpose (Windows, Linux)
- Installation packages
- Minor version updates
Transactions and the versioning engine
- Multi-versioning, garbage collection, sweep
- Transaction control: OIT, OST, OAT, Next
- Version control with gstat and Database Analyst
- Long-running transactions and garbage
Administrative tasks and command-line tools
- isql
- gbak (backup, restore, incremental gbak -di)
IBCONFIG
- Parameters
- iblockpr
- Tuning for better performance