The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 demo program

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.

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

Date: 05 Dec 2012 (Published 01 May 2003)

Activity: 5485 views
Comments:

Get the downloads

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

Description	Name	Size	Download method
DB2 demo program for DB2 9.5	DB2DemoSETUP.exe	5.3MB	HTTP
DB2 demo program guide	DB2Demo-Program-Guide.pdf	493KB	HTTP

Information about download methods Get Adobe® Reader®

Resources

Learn

Visit the developerWorks resource page for DB2 for Linux, UNIX, and Windows to read articles and tutorials and connect to other resources to expand your DB2 skills.
Learn about DB2 Express-C, the no-charge version of DB2 Express Edition for the community.
Learn more about the Professional certification program from IBM.
developerWorks tutorials: Check out the many developerWorks tutorials available to help you with certification preparation.

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