DB2 Express-C component roadmap
DB2 Express-C data server
DB2 Express-C offering contains several components. These components are available on our downloads page for download as separate files. The core component is the data server which hosts hybrid XML and relational databases.
The DB2 Express-C data server is available for Windows, Linux, Linux on POWER (iSeries™ and pSeries®), and Solaris x64. There is also a beta for Mac OS X on Intel x64, ideal for cross-platform development.
If you will be installing DB2 Express-C server on Linux and want to use languages other then English, you will also need to download and install the DB2 National Language Package, which is available on the additional downloads page.
DB2 development tools
DB2 Express-C integrates with IBM Data Studio Developer, a full function Integrated Development Environment based on Eclipse. Additional administrative functionality is available in IBM Data Studio Administrator, which replaces the earlier Control Center. If you plan to build SQL scripts, stored procedures, user defined functions or XML Queries, download the IBM Data Studio tools.
Applications developed for DB2 often need to be deployed to client workstations or application servers. To enable these client workstations and applications servers to connect to your DB2 Express-C server you will need to install various drivers on these workstations and application servers. These are available on the additional downloads page.
If your application is developed using Java you can download the IBM Data Server Driver for JDBC and SQLJ. Or if your application is developed using C or C++ and the ODBC interface, download and install the IBM Data Server Driver for ODBC and CLI. For applications developed using other programming languages or APIs, download and install the IBM Data Server Runtime Client. Or if you want to have a full-function client workstation with Command Line Processor and database administration tools, download IBM Data Server Client.
DB2 optional server components
DB2 Express-C data server's functionality can be extended to provide very fast searches of the text information stored in DB2 by using DB2 Text Search (OmniFind) on top of DB2 Express-C. Text Search is included as a core component in DB2 Express-C 9.5.2.
DB2 Express-C provides full enablement for industry standard web services based on SOAP and XML. This allows you to access data stored in the DB2 Express-C server as a web service. DB2 web services require an application server for deployment. This application server can be installed on the same server as the DB2 Express-C server or on a separate server. You can use IBM WebSphere or Apache Tomcat to deploy these services. WebSphere Application Server Community Edition (WASCE) is available for free download.
The DB2 Spatial Extender allows you to store spatial point, line and polygon values in a DB2 table column and perform spatial queries using standard SQL. DB2 Spatial Extender is supported by applications from ESRI and MapInfo as well as open source projects GeoTools, GeoServer and uDig.