DB2 demo program

George Baklarz (baklarz@ca.ibm.com), Program Director, DB2 Technical Sales, IBM

01 May 2003
Updated 27 Feb 2008

	Get the downloads

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

Welcome to the DB2 demo program!

This demonstration program also contains all of the scripts referenced in The DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep, Sixth Edition ISBN 013185514, by George Baklarz and Paul Zikopoulos.

This book is a complete guide to the IBM’s relational database servers, known as DB2. DB2 is available on many operating systems, and the book has been written to cover the version available on Linux, UNIX, and Windows. Any significant differences in the implementation of DB2 on various operating systems are highlighted.

If you are planning to become certified, or you would simply like to understand the powerful new DB2 database servers from IBM, then this book and DB2DEMO are great resources. This book can be used as a self-study guide to help you prepare for the DB2 certification exams, or as a guide to DB2 on the Linux, UNIX, and Windows platforms. The DB2DEMO program, along with the book, are great tools for helping you learn DB2 and obtaining your DB2 Certification!

For more details on the DB2 certification program, visit www.ibm.com/certify.

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

• Windows Operating System
  
  Any one of the following systems will work with the demonstration:
  • Windows XP/2003/Vista
  
  
• Internet Explorer, Firefox, or any suitable browser
  
  
• Your workstation or laptop should have a minimum of 512M of memory to run Windows and DB2, although more than 512M is ideal. The DB2DEMO program itself needs approximately 20MB of disk space for the program and help files.

The program will work with either DB2, Version 8 or DB2 9, but not all features will work if you use a downlevel server. Before you run the demo you should first create the SAMPLE database. The SAMPLE database can be created using the First Steps portion of the install, or with the db2sampl command. It can be installed on a DB2 server running on any of the supported platforms, including:

• AIX®
• HP
• Solaris Operating Environment
• Linux
• Linux on zSeries®
• Windows 2003, Windows XP®, Windows Vista®

Although the database can reside on one of these machines, the actual client (demo) must run on Windows XP/2003/Vista.

Note: The DB2DEMO program can also be used against other DB2 databases in your environment. The SAMPLE database is used for demonstrating various SQL commands, but you could do many of the examples against any other database that is catalogued on your system.

Download DB2DEMO now and explore what things DB2 can do!

Downloads

	Information about download methods			Get Adobe® Reader®

Resources

• The DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep, Sixth Edition, ISBN 013185514, by George Baklarz and Paul Zikopoulos: Learn the latest details on DB2 9.5 and prepare for the DBA certification exam.
  
  
• 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.
  
  

• Download a free trial version of DB2 Enterprise 9.
  
  
• 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 DB2, Lotus®, Rational®, Tivoli®, and WebSphere®.

• Participate in the discussion forum.
  
  
• Check out developerWorks blogs and get involved in the developerWorks community.
  
  

About the contributor

		George Baklarz has spent 23 years in IBM working on various aspects of database technology. From 1987 to 1991 he worked on SQL/DS as part of the product planning department, system test team, performance team and application development group. In 1991, Baklarz was part of the team that helped moved the OS/2 ES database to Toronto to become part of the DB2 family of products. Since this time he has worked on tradeshow support, vendor enablement, competitive analysis, product marketing, product planning, and technical sales support. Today, Baklarz works with customers to help them understand the new DB2 technology directions and uses their feedback to help improve the DB2 family of products. Baklarz has a PhD in Computer Engineering and is the author of a number of DB2 books including his latest book: The DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep, Sixth Edition, ISBN 013185514.

Back to top