The DB2DEMO program demonstrates the functionality of IBM DB2 10.1 for Linux, UNIX, and Windows.

George Baklarz (baklarz@yahoo.com), DB2 Technical Pre-Sales Support, IBM

George Baklarz, B.Math, M.Sc (Comp Sci), is a manager in the DB2 Worldwide Pre-sales Support Group. He has more than twenty-one years of experience with DB2 and has co-authored the DB2 UDB Version 8.1 Database Administration Certification Guide (Prentice-Hall, 2003), DB2 Version 8: The Official Guide (Prentice-Hall, 2003), and Apache Derby -- Off to the Races (Prentice-Hall, 2005). In his spare time he teaches database theory at the University of Guelph and presents at a variety of conferences, including the International DB2 Users Group. You can reach George when he's not traveling at baklarz@yahoo.com.



05 December 2012 (First published 01 May 2003)

The DB2DEMO program demonstrates the functionality of IBM® DB2® 10.1 for Linux®, UNIX®, and Windows®, including:

SQL features

  • Referential integrity
  • Domains and constraints
  • Triggers
  • Recursive SQL
  • Outer joins

Advanced object-relational features

  • Large object support (BLOBs)
  • User-defined types
  • User-defined functions
  • Table functions
  • Row-types and typed tables
  • Reference types
  • SQL PL stored procedure language

XML support

  • SQL/XML functions
  • XML data type
  • XQuery language extensions

Business intelligence features

  • Star schema support
  • Multi-dimensional analysis
  • Dynamic bitmap indexes
  • Automatic summary tables
  • Compression
  • Table partitioning

and more!

Prerequisites

In order to use this program, you need the following configuration:

  • Windows operating system (Windows XP/2003/Vista/Windows 7)
  • Browser (Internet Explorer, Firefox, Chrome, or any suitable browser)
  • Access to a DB2 system with the SAMPLE database

Your workstation or laptop should have a minimum of 1GB of memory to run Windows and DB2, although more than 2GB is ideal. The DB2DEMO program itself needs approximately 5MB of disk space for the program and help files, but this can grow to 20MB to hold the sample tables that are created during the demonstration.

The program will work with DB2 Version 8+, but not all features will work if you use a down-level server. In addition to having a DB2 server available, the SAMPLE database must be created beforehand, otherwise the program will not be able to run any of the examples. The SAMPLE database is normally created as part of the First Steps program after the DB2 installation is complete. If you need to create the SAMPLE database, use the db2sampl command.

While the SAMPLE database is the default database used by the DB2DEMO program, any database can be accessed by the program on all of the DB2 supported platforms, including:

  • AIX®
  • HP
  • SUN
  • Linux (all platforms)
  • Windows Vista® Windows XP®, Windows 2003, Windows 7

Although the database can reside on one of these machines, the actual client (demo) must run on Windows XP/2003/Vista/Windows 7. For details on how to do this, please see the installation section in the documentation.

Download DB2DEMO now and explore what things DB2 can do!

Downloads

DescriptionNameSize
DB2 demo program for DB2 9.5DB2DemoSETUP.exe5.3MB
DB2 demo program guideDB2Demo-Program-Guide.pdf493KB

Resources

Learn

Get products and technologies

  • Download a trial version of DB2 for Linux, UNIX, and Windows.
  • Now you can use DB2 for free. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edtion and provides a solid base to build and deploy applications.
  • Download IBM product evaluation versions and get your hands on application development tools and middleware products from Business analytics, Information Management, Lotus®, Rational®, Tivoli®, WebSphere®, and more.

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=292237
SummaryTitle=DB2 demo program
publish-date=12052012