My team just put out DB2 Express-C 9.7.5. The big new feature is Oracle compatibility, which is now available in the free edition. It includes PL/SQL, CLPPlus, and other related things.
DB2 Express-C is a free database. It’s fairly straightforward to install on your own machine or deploy on a public cloud like Amazon EC2 or IBM SmartCloud Enterprise. Disclaimer: I’m the guy who puts together the DB2 virtual images for SCE.
DB2 University is a good place to learn how to use DB2 at your own pace.
This is the syllabus for the workshop I’m chairing at CASCON 2011 with @mariusbutuc and @bsteinfe. If you’re interested, you can also take the course at your own pace online at BigDataUniversity.
SSH
Attendees will be provided with access to machines running Hadoop in a cloud environment. The necessary SSH credentials will be provided in class.
Materials
I’ve written about issues related to “SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing” before, but I thought I’d add a few short notes.
If your machine can’t ping itself, cat /etc/hosts. Chances are, you need to add a line like the following:
127.0.0.1 myhostname.mydomain myhostname
If DB2SYSTEM is set to the wrong value, db2set -g DB2SYSTEM=`hostname` will fix it on Linux.
If db2nodes.cfg has the wrong value, overwrite it with the right one.
I’ll be chairing the Crunching Big Data in the Cloud with Hadoop and BigInsights workshop at CASCON 2011 in Toronto on Wednesday, November 9th. @BSteinfe and @MariusButuc will be joining me as co-chairs.
The workshop will be an all day hands-on introduction to Hadoop, HDFS, MapReduce, Hive, and JAQL. The plan is to have ready Hadoop clusters running in the cloud for the various exercises.
Hadoop is a parallelized data processing framework. It lends itself very nicely to running in cloud environments like Amazon EC2 and IBM SCE, as the core concept is to split sophisticated queries across clusters of commodity hardware. On a basic level it’s an implementation of MapReduce in Java, but a great many tools in its eco system make it easy to formulate and execute queries on the fly.
The material will have some things in common with the free Hadoop Fundamentals course you can take on Big Data University today, though naturally adapted for the CASCON themes and with added hands-on instruction.
Next steps
(Edit: Corrected instructions so that HTTP links in other apps will still open in Firefox.
)
There’s an intranet application that I need to use that does not work in Firefox 4, Firefox 5, Chrome, Opera, or Safari. It also runs painfully slowly in Microsoft Internet Explorer 8. Since it does support Firefox 3.6, I thought I’d try running two different versions of Firefox side by side.
http://www.personalizemedia.com/media/socmedcounter.swf
Here’s an interesting example from the InfoSphere BigInsights/Hadoop class I’m attending right now. Note that Social, Mobile, Games, and Heritage are tabs that you can switch between.
Google+ is Google’s new social network. It takes aim at both Facebook and Twitter, but I think its unique intersection of features also positions it to succeed LiveJournal in a way that neither Facebook nor Blogger ever could.
Let’s back up a bit. What is LiveJournal?
LiveJournal, or Zhivoi Zhurnal as its Russian userbase calls it, is a social network masquerading as a blogging platform. It started in 1999, 3 years before Friendster, and provided:
Google+ has all of these features. Not just that, but it exposes them much better than inertia-laden LiveJournal ever did, and it is amenable to long posts.
LJ is a smaller fish than Facebook, with only 32,000,000 friends of whom only 2,000,000 are active, but targeting this community could give Google a sufficient core of users to take on the Facebook behemoth.
Will LiveJournal users migrate? I’m not sure. LiveJournal satisfies several rather different demographics. 48% of its active user base is Russian, exemplified by President Dmitry Medvedev and various photoblogs. There’s a big celebrity news community called Oh No They Didn’t. There’s also a significant scifi and comics fandom userbase exemplified by Scans Daily that is already moving to a clone site called DreamWidth. Some of these groups may be more amenable to the lure of Google+ than others.
I can say that the circle of people I met back when I had a journal on Slashdot in the early 2000s migrated to G+ overnight, and LiveJournal fostered and fosters similar communities. They could very well follow and give Google the critical mass that it craves.
My work for the past couple years has been to develop DB2 images and templates for various cloud platforms and to engage the DB2 community online. This is still the case, but increasingly I’m spending my time working with IBM InfoSphere BigInsights.
BigInsights is IBM’s distribution of Hadoop.
What’s Hadoop? It’s a great way to crunch through massive amounts of unstructured data like email archives, geographic stuff, economic measurements, and so on to find interesting patterns. It rests on the Map-Reduce algorithm, which is what Google uses when you search. Much Google’s success rests on Map-Reduce’s ability to scale out on commodity hardware.
(Notably, the whole Cloud Computing thing is the flip side of using massive arrays of commodity hardware. Since you have so much of it, you need a way to automate and abstract the management as much as possible. Since you’ve automated and abstracted away management, you might as well sell it as a service.)
Hadoop itself is an Apache Software Foundation project nurtured by Yahoo among others. It’s gaining an increasing number of commercial distributions including Cloudera, IBM, and now Hortonworks.
You can quickly try out BigInsights Basic on the cloud or download it to your own machine.
I really do recommend the macro that
There’s a DB2 Chat with the Lab on Wednesday next week which will cover, among other things, the DB2 images I’ve developed for IBM Workload Deployer over this past while. I recommend checking it out, as the speakers know their stuff and this is a pretty cool product.
Easily Deploy Database Workloads on Private Clouds
Date:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Wednesday, June 29, 2011 (29.6.2011)
Time:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 12:30 AM – 2:00 PM Eastern Time (ET)
11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 10 PM
Speakers:Â Â Â Â Â Â Â Â Sal Vella, Leon Katsnelson, Rav Ahuja, Chris GruberAs more and more businesses look for ways to reduce costs within IT, their research typically discovers cloud computing. However Public Clouds are not an option for many enterprise workloads and applications with strict security and privacy requirements. Organizations with such needs can benefit from building Private Clouds within their own data centers. In this webcast we will look at a fast path to deploying private clouds for database workloads.
We will specifically look at instant provisioning of DB2 systems and databases in a private cloud infrastructure using the IBM Workload Deployer (IWD), previously called the WebSphere CloudBurst Appliance. We will also look at how IWD can be easily used for implementing complete web application patterns with web servers, application servers (WebSphere), and DB2 database servers with high availability options.
To learn more, please join experts from the IBM labs – Sal Vella, Leon Katsnelson, Rav Ahuja, and Chris Gruber.
Presentation charts will be available from ibm.com/db2/labchats just before the webcast starts.
I was writing a response to a forum post in Russian and thought to run it through Google Translate for verification. If nothing else, it would catch the sort of misspelling I tend to make.
It surprised me by completely reversing the meaning of what I wrote:
That’s the complete opposite meaning!
This is the first time I’ve been irritated enough to correct a Google translation. It’s a common word, so I’ m not sure what could have led to the misapprehension on Google’s part.
