Opensource databases such as MySQL and PostgreSQL supports non standard SELECT extension for limiting number of returned rows from query. You can see description in PostgreSQL manual. Look for keywords LIMIT and OFFSET. LIMIT specifies the maximum number of rows to return, while OFFSET specifies the number of rows to skip before starting to return…Continue
Another DB2 upgrade mini-guide. I was asked to upgrade DB2 Express 9.5.4 to DB2 Express 9.7. Reason for this was that old DB2 Express 9.5.4 was 90-day demo version and demo key expired. Upgrading DB2 will generate new 90-day key and allows to use DB2 for some more time which would be enough for finishing application development. It was small VMware DB2 instance with 1GB ram for using during application development.
I pointed that installation of DB2 Express C will be better because it…Continue
Added by Radim Kolar on January 28, 2010 at 4:28pm — No Comments
Added by Radim Kolar on January 23, 2010 at 9:41am — No Comments
Few weeks ago IBM did Virtual Experice version of IOD 2009 Las Vegas conference. Using web technologies you can join virtual conference and listen to sessions (more than 30 available), download presentations, chat and mail with other online people (usually 2-5 people around, nice opportunity to find new potential customer) . Its really nicely done and you should take a look and spend there few hours. Its time good spent.
You can register (free)…Continue
Added by Radim Kolar on December 3, 2009 at 1:32pm — No Comments
Yesterday, DB2 Express C 9.7.1 was released. I have one non root db2 9.7.0 copy floating around and wanted to update it. Non root db2 installations are very convenient for casual testing. They can be installed quickly by regular user and you do not need to seek assistance of unix administrator.
Updating DB2 Express C linux installations with standard db2 install program is not possible - you have to do reinstall because unix db2 installer do not have ability to do updates like ms…Continue
Added by Radim Kolar on December 2, 2009 at 11:00am — No Comments
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 26, 2009 at 8:21am — No Comments
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 — No Comments
Rational Team released 18.104.22.168 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:
These important changes makes Rational…Continue
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 — No Comments
Added by Radim Kolar on November 3, 2009 at 7:41am — No Comments
Added by Radim Kolar on August 17, 2009 at 6:03am — No Comments
Added by Radim Kolar on August 10, 2009 at 12:28pm — No Comments
Added by Radim Kolar on April 19, 2009 at 9:01am — No Comments