This paper documents the download, installation, and initial use of IBM DB2 Express-C on a Windows-based IBM ThinkPad. The author walks through the installation process — including both graphical and command-line interfaces — and evaluates the quality of IBM's documentation and sample data sets. The paper examines key features of DB2 Express-C, including multidimensional table creation, administrative partitioning, XML integration, and ACID compliance. It also situates DB2 Express-C within the competitive enterprise database landscape, comparing IBM's XML architecture to Oracle's Fusion initiative. The analysis concludes that DB2 Express-C offers significant potential for enterprise application development despite being a free, low-end offering.
IBM DB2 Express-C for Microsoft Windows was downloaded, installed, and used as the basis of analysis in this paper. What differentiates IBM DB2 Express-C from many comparable low-end enterprise-level databases is its support for XML integration, dual-core processors, and 2 GB of memory. IBM has been selling its DB2 databases for decades to enterprises globally and has made this version available as a free download. While it is a low-end, freely downloadable version, IBM has been generous in its support for many core features.
IBM has also included access to its online support communities and forums. These communities and forums are highly valuable for gaining insights into administration, development best practices, XML integration, and writing programs with this application. The system on which the downloaded application runs for purposes of this analysis has dual-core processors and 2 GB of memory. The insights gained from the implementation and initial programming using this application form the foundation of this report.
The IBM ThinkPad used for completing this analysis is connected to the Internet via a cable modem running at speeds comparable to a fractional T1 connection. This made the initial download of the DB2 Express-C software installation packages fast, with 389 MB of data retrieved in less than five minutes. After the software was downloaded from the IBM site, the installation process was initiated and captured in a series of screen captures shown in the Appendix of this analysis.
IBM's documentation was excellent in that it defines the initial installation process beginning with the Control Center. IBM also takes time to explain how the installation process can be completed using a command-line interface. Both approaches were successfully attempted and completed for this analysis, with the Control Panel delivering more consistent results. Within twenty minutes of downloading and installing the software, the DB2 Control Center was up and running. The first application of the database was initiated using the db2cc command. IBM is careful to explain how both the graphical interface-based Command Center and the command line deliver identical results. The first three pages of the documentation are excellent in this regard, providing a strong foundation for learning how to interact with the application and command line.
Following the invocation of the first application, the command db2sampl -xml sql was completed to create a table as defined in the user documentation. IBM provides a sample data set to accomplish this quickly so that students and programmers alike can get up and running with DB2 Express-C without delay. The graphical interface and command-line approaches to defining the table worked identically, as IBM's documentation had indicated they would.
IBM's approach of supporting both interfaces ensures flexibility for users with different technical backgrounds. Those comfortable with graphical tools can use the Control Center, while advanced users and administrators can rely on the command line for scripting and automation. The consistency between the two interfaces is a notable design strength of the application.
"Table creation, batch programming, and scripting value"
"Partitioning, XML architecture, ACID compliance, and Oracle comparison"
The IBM DB2 Express-C free application was downloaded from the IBM website after opting in and creating an online identity. The documentation was delivered as part of the download and was very easy to work with and understand. As a result, within 20 minutes the application was installed, up and running, and being used to create tables. IBM provides sample data that significantly speeds up the learning process. This application has significant potential for creating integrated applications across an enterprise.
You’re 51% through this paper. Sign up to read the remaining 2 sections.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.