Install DB2 Express-C 10.5 on Ubuntu Trusty 64 bit/(Upgrading from DB2 9.7 32 bit)

DB2 Express-C is a fully functional and very powerful database offering from IBM, that can be used for free. Currently it’s limited to two cores and 4GB RAM, that’s enough to be used in small-medium applications.

DB2 plays well with LXC, and I had no problem using it for years in a hosted server environment.

Continue reading “Install DB2 Express-C 10.5 on Ubuntu Trusty 64 bit/(Upgrading from DB2 9.7 32 bit)”

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”

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”