Technology Explorer for IBM DB2 “Flight simulator” Project


Brian Olynyk, team lead of Technology Explorer

Peter Kohlmann, original creator of Technology Explorer

Matthew Vandenbussche, core developer and architect of Technology Explorer

UCOSP Students:

Michael Man SFU <>

Godfrey Chan SFU «»

Lenny Han Toronto «a href=”” target=”_blank”></a>>

Diane Tam Toronto «a href=”” target=”_blank”></a>>

Jean Lalande Laval «»

Sylvain Petitclerc Laval «»

UCOSP FlightSim Team Blog:

Weekly Team Meetings:

Tues and/or Thurs 1-2pm (EST)

Code Sprint Jan 15-17 Overview:


One of the major long term goals for the Technology Explorer for IBM DB2 has been to provide an environment similar to a flight simulator for Database Administrators.  Pilots used to learn to deal with potentially dangerous and stressful situations in a real place.  This was risky and expensive.  Pilots today learn to deal with system failures and extreme conditions on flight simulators.  DBAs still develop their experience on live multi-million dollar production systems.  They could develop skills and confidence faster and more safely on a simulator.

Over the past few years the Technology Explorer for IBM DB2 team has built all the base components to create this simulator as part of our open source project.  The next step is to pull the pieces together into a viable simulation.  The team will use the existing open source building blocks to simulate a stable production system and then disrupt it with a number of planned or unplanned problems.  The system will then walk the DBA through problem recognition and resolution.

Goals for the project would:

  • Extend the existing framework to simulate database management problems
    • Simulate DB2 in production
    • Create a disruption of the system, for example a hard drive failure, lock contention, or excessive workload
    • Guide a DBA to identification and resolution of the disruption
  • Develop at least one example of a problem simulation


PHP, JavaScript, Prototype js library, AJAX, dynamic web pages, HTTP protocol (the impact of it being a stateless system and what has been done to keep memory between requests on both the client and server sides)

Project managed through




Issue Tracker:

Additonal Links:

Steps for adding files(e.g. screencast):


Source code for ibm_db2:

Debugging PHP:  PDT2 (Eclipse for PHP) and install either XDebug or ZendDebug and configure in Apache and Eclipse.