DB2Demo – Updated for DB2 10.5!
October 16, 2013 Leave a comment
George Baklarz – Program Director, DB2 presales , IBM
Trying to demonstrate what a database does is rather boring. It stores data. It retrieves data. Sometimes it does it in clever ways, but at the end of the day it’s just manipulating data. Which is where DB2Demo comes in.
The program has evolved over the years and now contains over 2000 examples of SQL. Stuff that you never knew you could do (or perhaps care about!). All that is needed is a Windows XP or Windows 7 system with access to a local DB2 database. Most likely you have a copy of DB2 Express-C or similar version on your laptop so the installation is pretty simple. You download and install DB2Demo, make sure you have DB2 installed locally on your system, and then start the program.
If you’re connecting to a database on a server, you may need the IBM Data Server Runtime Client or the IBM Data Server Driver for ODBC and CLI (CLI Driver). You can get that from IBM.COM (see links below). Connecting to the database is pretty simple – database name, userid, and password and you’re connected.
For best results, I’d recommend having your own DB2 database installed locally on your system. That way you can play with the database and try things out without impacting other users (they may not like you dropping databases, etc…).
So once you are connected, the program will open up a list of SQL that you can play with – everything back to Version 1 of DB2 LUW. While the documentation (yes, there is documentation!) is pretty thorough, I’ll take you through a tour of how to use the demo in another segment.
For now, enjoy demonstrating a database for once!
George Baklarz has spent 28 years in IBM working on various aspects of database technology. From 1987 to 1991 he worked oon SQL/DS as part of the product planning department, system test team , performance team and application development group.