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… Continue
Added by Radim Kolar on November 29, 2009 at 11:45am —
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 —
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 —
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… Continue
Added by Radim Kolar on November 20, 2009 at 6:08pm —
Rational Team released 220.127.116.11 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:
- It can be freely used up to 10 users (was 3 before)
- You can now use any supported database engine (was DerbyDB only)
These important changes makes Rational… Continue
Added by Radim Kolar on November 15, 2009 at 2:29pm —
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… Continue
Added by david t on November 13, 2009 at 12:30pm —
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 —
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… Continue
Added by Radim Kolar on November 9, 2009 at 5:00pm —
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 —
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 firstname.lastname@example.org
Thanks in Advance.
Added by Mokshit Chawla on November 4, 2009 at 9:27am —
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 —
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 —