Problem:

I get a compilation error COBDB0006S Required DB software: 'db2aprep' could not be found.

We installed DB2 Runtime Client 9.7.5 and the new product IBM Data Studio 3.1.1. I can't connect to my database via Host Compatibility Option any more. 

Solution:

In order to compile correctly against UDB v9.1 by using the HCO, you need DB2AGAPI.DLL and DB2APREP.DLL to be present in sqllib/bin installation folder of you DB2 Client product.

Install either DB2 LUW 9.7 or DB2 Connect because they contain the needed dlls.

In our product documentation it is written:

***********************************************

Prerequisite Software

Before you can use Host Compatibility Option, you must have installed and configured either the IBM Database Connect or IBM Universal Database (UDB) software. If you are using UDB version 7.1 or later, you must also install the DB2 Application Development Client (formerly called DB2 SDK) or you will not be able to compile any DB2 programs.

************************************************

Incident: 2572861

Product: Mainframe Express 3.1