COUNT column is fast in DB2

COUNT column is fast in DB2

Antonio Cangiano just set up a simple benchmark comparing COUNT(column) performance between untweaked DB2 Express-C and MySQL.

The results:

{ Read More }

Create a free site on Radiant CMS and DB2

Create a free site on Radiant CMS and DB2

Antonio just put up a a great tutorial for creating a free website using Radiant CMS and DB2 on Amazon.

A great thing about this configuration is that it uses an Amazon micro instance, and Amazon lets new customers try out micro instances for free for a year. I talk a lot about free cloud offers, but usually I mean that our software is free while you are still paying someone for the hardware. In this case, the hardware is free too.

Radiant is a content management system (CMS). Other popular CMS software includes Drupal and Joomla, with blogging tools like Wordpress increasingly gaining CMS-like features.

In my experience, the hardest part of running a website is maintenance. Keeping the content up to date while posting new things can be a challenge. A CMS like Radiant makes this a lot easier by separating your content from the sites structure and appearance, so one doesnt distract you from the other. From the point of view of a site owner, a CMS-drived website really is far superior to the traditional hand-rolled websites of yesteryear.

Whats this got to do with the glory of the free DB2 Express-C database? Well, thats where your content gets stored.

So, I dare you -- launch a site on Radiant CMS and DB2 today.

Cheers,

Leons Petrazickis
DB2 Community Team

{ Read More }

Create a database with Data Studio for DB2

Create a database with Data Studio for DB2

Data Studio is a free utility for managing DB2 databases. It has SQL and XQuery syntax highlighting, code validation, and tools for helping you build stored procedures and various other database objects. You can use it to explore a database by drilling down through schemas, tables, and so on. Naturally, you can use it to create databases.

Click on the "Create database" button in the "Data Source Explorer" pane.

You want to create a DB2 for Linux UNIX Windows (LUW) database. Before DB2 9, LUW was known as UDB.

Enter the following values and test the connection:

• DB2 as the instance name. DB2 is the default instance name on Windows. You can find out the name of your instance by issuing the db2set -g command.
• localhost as the host. This refers to your own computer.
• 50000 as the port. This is the default DB2 port.
• Your own username on Windows, or the DB2 instance owner username (typically db2inst1) on Linux.
• The corresponding password.

Enter a name and location for the database and then click Run to create the it.

• TEST is as good a database name as any for our purposes.
• On Windows, you generally enter a drive letter like C: or D: for the database path. On Linux, you should enter a full path like /db2/data

Congratulations! Your database is ready for use.

Downloads

• DB2 Express-C - Free database server.
• Data Studio Standalone - Utility for writing SQL and XQuery code as well as managing databases.
• Data Studio IDE - Adds the ability to create Java stored procedures and web services.
• Getting Started with Data Studio for DB2 - Free e-book.

Cheers,

Leons Petrazickis
DB2 Express-C Community Team

{ Read More }