Before you start
DB2 Express-C is a no-cost version of DB2 Express Edition (also known as DB2 Express) for the community. DB2 Express-C is a data server for use in development and deployment of applications, including XML, C/C++, Java™, .NET, PHP, and more. It can be run on up to two dual-core CPU servers, with up to 4GB of memory, with any storage system setup with no restrictions on database size or any other artificial restrictions.
If you are a database application developer, application developer, XML developer, or someone curious about new database technology, this tutorial is for you. Learn details about the new XML capabilities of DB2, which is available in the community edition product. If you're tired of either shredding XML data or treating it as a large object (BLOB, CLOB, and so on) to force-fit into a relational database, take this tutorial to explore the advantages of DB2 Express-C.
After completing this tutorial, you will know how to:
- Install and set up DB2 Express-C
- Use DB2 Developer Control Center to create a new database
- Create data (both relational and native XML) into the database
- Use XQuery and SQL/XML to query the XML and relational data with DB2 Developer Workbench
This tutorials assumes that you have some understanding of XML, SQL, and basic database design. Knowledge of XQuery and SQL/XML functions will be helpful, but are not required.
To complete the steps in this tutorial, you need to have DB2 Express-C installed.