1. Download DB2 Express C db2exc_912_WIN_x86.zip

  2. Download DB2 Spatial Extender from the DB9 Fix Pack. Choose your OS and browse over “DB2 Spatial Extender -> Language Independent”. There is a current problem installing the DB2 Spatial Extender from the main “Spatial Offering” Site with DB2 Express C because of the versions, DB2 Express C was made after FP2 (Fix Pack 2), while DB2 Spatial Extender was made before FP2. When installing the old DB2 Spatial Extender, it will prompt you with “No Action Available”, to resolve the problem, install the DB2 Spatial Extender FP2 (v9fp2_win_gse.exe).

  3. Leveraging MySQL skills to learn DB2 Express contains comparison between MySQL and DB2. It also contains default installation instructions which make installing easier.

  4. New to DB2 from the DB2 Wiki is a good start in understanding DB2’s concepts.

  5. Browse over the User Guide of Spatial Extender to understand the Spatial Extender capabilities.

  6. Geoserver Integration? Read Open Web Mapping from Penn State Univ.

  7. Manually starting DB2 Services on boot:

DB2 – DB2COPY – DB2 – Allows applications to create, update, control, and manage relational databases.

DB2 Management Service (DB2COPY1) – Manages DB2 registry entries for backward compatibility purposes for the DB2 Copy DB2COPY1

DB2 Remote Command Server (DB2COPY1) – Supports remote DB2 command execution for the DB2 copy named DB2COPY1.

DB2 Security Server (DB2COPY1) – Authenticates DB2 database users when the authentication is performed at the client computer for the DB2 copy named DB2COPY1.

DB2DAS – DB2DAS00 – Supports local and remote database administrative requests.