ITworks

Starting DB2 instances on boot

After migrating our hosted application to a virtual server I realized, that as usual the system is a “maintenance free” Linux, meaning we set it up as it were and left it running for ages without touching it. On the occasion of power failure the applications were started manually.

As I don’t want to restart everything by hand, whenever our system is restarted I decided to iron these glitches out. OK, the system is only restarted about twice a year, but I tend to forget to restart things manually, so that’s the real reason.

Continue reading Starting DB2 instances on boot…

DB2 Express-C 9.5 on Debian

For our current pet project we’ve decided to use DB2 Express-C as a database back-end. The choice is made, so our junior developers could practice their art on databases that resemble enterprise databases more than MySQL or Postgres. (We have already ruled out SAPDB/MaxDB on previous occasions.)

Continue reading DB2 Express-C 9.5 on Debian…

Quick and dirty way to create DB2 update scripts

In on of our major projects we store some of our business logic data as database metadata, but provide GUI interface for updates. Since clicking through the project’s GUI is much easier, than creating and verifying scripts for each tiny modification, our developers got lazy and we had to find a way to create SQL scripts to bring releases up to date. This basically means, we had to create a script generator that compares the data in source and destination databases and creates SQL INSERT, UPDATE and DELETE statements that can be used to modify the destination to source.
Continue reading Quick and dirty way to create DB2 update scripts…

Off-line SWT application

One of our current Customers have a very interesting requirement for an upcoming project. The nature of the project requires mobile clients and frequent (or even instant) database updates, but there is no guarantee to have constant connectivity. We more or less have full control on the choice of tools to use for this application, but since our developer resources are limited, it would be great if we could use the architecture from a previous project. We’ve been working with András on this for quite a while and it seems we found a pretty interesting way to do this.
Continue reading Off-line SWT application…