June 2010 Blog Posts (5)

DB2 Express

Is entry level database server. It is limited to max 4 cpu cores or 200 PVU and 4 GB RAM. Capacity sub licensing is allowed, you can split server by virtualization technology and install multiple copies of DB2 Express on it.

DB2 can be licensed per server, PVU or FTL. Licensing per PVU is oldest licensing type, every CPU core has some PVU value assigned. Most…

DB2 9.7.2 comes with new feature - transportable schemas. They are somewhat similar to transportable tablespaces which are old Oracle feature introduced in 8i and enhanced in 10g. Most significant improvement in 10g was making them cross platform. Cross platforms transfers require more administrator work, they are not automatic.

In Oracle you need to create metadata and hand copy database files. Then import metadata and add transfered files to target database. You might need to run…

This manual is useful for Linux only. On windows just run installer and it will update DB2 copy for you.

Because fixpacks are not supported for DB2 Express C Edition, you can not just unpack new db2 image and run ./installFixPack. If you do, it will return an error. You also can not install new db2 image over old, installer will refuse to do it.

Cookbook for update operation is very simple:

1. Install to new DB2 to new location
2. Switch DB2…