Friday, November 09, 2012

The Tech Side of #SocBiz - Working with DB2 Databases

All right, so you're doing the Social Business and/or mobile thing.  You're talking about deploying (or may have already deployed) Sametime, Connections, Lotus Mobile Connect, Lotus Notes Traveler, and/or Websphere Portal.  Well, there's something behind the scenes that you should know - you're going to be, at least in part, a.....wait for it....database analyst!

Surprised?  Well, all of these products depend upon database services provided by IBM's DB2 database product.  Sure, DB2 has been around for quite some time, but it's likely that you (as an "applications team" person) never really had to step into that world of tables, elements and SQL.  That's going to change, if for no other reason that your own vested interests in performance tuning, system monitoring and other typical admin tasks.  For instance, Sametime meeting rooms are now (as of the 8.5 release) nothing more than database constructs; just about everything that goes on in a Sametime meeting room is stored in the backend DB2 database.  (That's how you get the "always on" feature!)  Ditto for the content in Connections.  So, you'll need to dip your toes into the DB2 water and get a feel for things.

Well, IBM has a few tools that can help you get up to speed before you ever start that first deployment.  Best of all, they're FREE!

Obviously, most of us don't have a "spare server" laying about on which to install DB2 in all its glory...but there's an easier way to get started.  DB2 Express-C is a fully functional "mini-DB2" database product; basically, its limitations are a single install (i.e. no clustering/failover facility) and throttled horsepower (it will only use up to 2 CPU cores and 4GB of RAM).  It's available for Windows (32- and 64-bit), Linux (32-/64-bit Intel and POWER), Solaris X86-64 and Mac OS X.  (Yes, you can run DB2 on your Mac!)  DB2 Express-C will let you try your hand at just about anything you'll need to do in a production DB2 environment, including developing your own stored SQL procedures and implementing a DB2 security model.  Why, an enterprising person might even take the database creation scripts from a Sametime install CD and create that exact same environment in DB2 Express-C!  (Yes, that's a hint...)  There's even a free "Getting Started with DB2 Express-C" book available for download, so there's no reason not to jump on board.

Now that you have a DB2 server, you'll want a tool with which to "go explore."  Enter IBM Data Studio.  This Eclipse application has guided steps for most of the common database activities, so it's a simple thing from the start.   You can do everything from direct database management (e.g. dropping/creating databases, modifying tables) to health monitoring and job management (with the add-on Web Console component).  I found Data Studio exceptionally simple to use, and was doing production work within roughly 15 minutes of installation.  It's available for Red Hat Linux, SUSE Linux, and Windows, and there's also a free "Getting Started with IBM Data Studio" book to be had as well.

Whether you're planning for a specific deployment, learning DB2 for the first time, or just wanting to know enough to speak with your database team in their native language, these DB2 tools should be more then enough to send you on your way.

Enjoy!

No comments: