November 2009 Blog Posts (12)

DB2 Express C 9.7 licensing changes

Licensing for DB2 Express C changed in 9.7 version a bit. DB2 Express C is still free to use and distribute, but DB2 Express C FTL - Fixed Term License is no more. FTL licensing option was moved to regular DB2 Express Edition.

This is good move because people sometimes criticised that DB2 Express FTL have more issues than regular express version. Also it will make easier sw maintenance for IBM because they can now concentrate on 3 DB2 Editions (Express, Workgroup, Enterprise). DB2…


Added by Radim Kolar on November 29, 2009 at 11:45am — 1 Comment

First FixPak for DB2 9.7 LUW is here

IBM Information Management released long awaited Fixpack for DB2 9.7 also known as Cobra. This fixpack comes with

really impressive list of fixes. This list of fixes is not complete list of fixes included in fixpak. IBM, as usual, omits some included fixes from being listed. This is really annoying because our and customers DBA can not easily check (without running their testcases) if their… Continue

Added by Radim Kolar on November 26, 2009 at 8:21am — No Comments

Heterogeneous Batch in IBM Optim pureQuery

Optim pureQuery provides many benefits which include improved quality, improved developer productivity and dramatically improved performance over JDBC based solutions against databases which support static package binds, such as DB2.

Most often discussed about the performance benefits is static packages. However, if you have high-volume INSERT and UPDATE applications, static SQL is only a part of the benefit. pureQuery offers a Heterogeneous Batch capability which can… Continue

Added by Dan Galvin on November 24, 2009 at 11:37pm — 1 Comment

Compiling Apache Derby 10.3 database

Apache Derby is very often used opensource Java database. It is also known as Cloudscape or JavaDB. There are several branches available, but 10.3 is most used Derby branch today. It can be found in Websphere 7, Rational Software Team Concert/Foundation, Websphere CE 2.1 and probably in many many others. 10.1 and 10.2 branches are considered obsolete and 10.4 and 10.5 are considered too…


Added by Radim Kolar on November 20, 2009 at 6:08pm — No Comments

Rational Team Concert-C and DB2 Express-C

Rational Team released version of their Rational Team Concert software. There is some excitement about this version because its not only first bugfix version in shining new 2.0 RTC line, but there are also important licensing changes:

  1. It can be freely used up to 10 users (was 3 before)
  2. You can now use any supported database engine (was DerbyDB only)

These important changes makes Rational…


Added by Radim Kolar on November 15, 2009 at 2:29pm — 1 Comment

A Fast Way to Get Started with DB2's SQL Replication

SQL Replication is a database replication technology built into DB2 and InfoSphere Warehouse. People often ask me what's the fastest way to get started with it. I think it's best just to set up a simple configuration and go from there. That's what I'm going to show in this post. It should take about 5-10 minutes. You can then extend that…


Added by david t on November 13, 2009 at 12:30pm — 1 Comment

DB2 and CouchDB sitting under a tree

Recently, I have been learning lots of interesting stuff, not directly related to db2 or database administration. I have been poking around ruby, reading about JSON, and been curious about couchdb. I wanted to test all these things out in a mini project.

Without any practical use in mind, rather than just trying stuff out, I decided to make a db2 analytics tool. Yes, yet another db2 analytics tool, because I also wanted to somehow tie ruby/json/couchdb back to my database… Continue

Added by bakukang the dba on November 12, 2009 at 12:52am — No Comments

DB2 9.7 adoption rate

I am amazed how fast is DB2 version 9.7 moving into production. It is much faster then 9.5. I started to see first signs of 9.5 used in production for about 1 year after release.

DB2 9.7 is entirely different. Its already used, deployed on testing systems and used as standard version for new projects. Its pretty good success because there is not even single fixpak for v9.7 out. Fixpak 1 is awaited because it will add Oracle compatibility to DB2 Express Edition, which is very…


Added by Radim Kolar on November 9, 2009 at 5:00pm — No Comments

Regular Expressions in DB2 9.1

Can anyone tell me how to use regular expression in LOCATE function to locate a non alphanumeric character in a string?
I know the regular expression for non alphanum characters is '\W' but not able to implement it correctly in the function.

Thanks in Advance

Added by Mokshit Chawla on November 4, 2009 at 9:31am — 1 Comment

000-735 exam for procedure developer? any reference book or material except the pdf's on the IBM site

Hi All

I am planning to give IBM 000-735 exam for DB2 9.5 procedure developer. Please give the link/URL to any training material / reference book for the exam. if you have a soft copy of the material please mail me on

Thanks in Advance.

Added by Mokshit Chawla on November 4, 2009 at 9:27am — No Comments

Configuration of pureQuery 1.2 with Spring

Initially, version 1.1.x of Data Studio pureQuery had some support in the Spring Mods. This allowed configuration of pureQuery "DAO" classes with Spring. The Spring compent is spring-pdq.jar and is available at the following link:

That support has been updated now by Matt Anderson… Continue

Added by Dan Galvin on November 3, 2009 at 9:56am — No Comments

Big database migrations matrix

People are changing database backends for their applications for various reasons. I was interested about current trends in database migrations. I used google to search how much documents can be found to particular database migration direction.

i tried mysql first to see if google can return relevant data:

migration "from mysql" 63 700 documents found

migration "to mysql" 242 000 documents found

That was pretty much expected result because mysql is highly popular… Continue

Added by Radim Kolar on November 3, 2009 at 7:41am — No Comments

Monthly Archives













Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service