JR43526 EngMonApp error: This column type is not currently supported by this driver

DETAILS:
EngMonApp failed when connecting to Oracle database 11.2.0.2.
Oracle 11.2.0.2 changed default XMLTYPE storage type from CLOB to binary.
The branded Progress DataDirect JDBC driver does not support XMLTYPE binary storage.

IMPORTANT INFORMATION:

If you have not got a previously created a DSODB repository, then the 
update is complete after the standard patch install and you should follow 
the instructions in the README or readme.txt file in the directory:
	.../IBM/InformationServer/Server/DSODB/scripts/Oracle11g
to create your new DSODB repository.
  
If you have an existing DSODB repository then there is a manual step that 
must be performed before the patch is effective. The patch requires an
update to the operations database schema, where the storage type of
XMLTYPE columns must be modified.
Before running this manual step you should make sure DSAppWatcher is not 
running, by either stopping the DataStage AppWatcher service on windows 
or running:
  .../IBM/InformationServer/Server/DSODB/bin/DSAppWatcher.sh -stop
on unix as the datastage administration user (e.g. dsadm).  
  
There are two options for the manual step:

Option 1 - Drop and re-create the schema (recommended)

You must first drop the existing DSODB schema, and then re-create it using
the patched files. The instructions to follow in order to drop and to 
re-create the DSODB database are described in the README or readme.txt file
in the directory:
  	.../IBM/InformationServer/Server/DSODB/scripts/Oracle11g
If you still have the scripts that you generated when creating the DSODB
repository originally, then you can use these to drop the existing
repository first. If you do not have those scripts then when you run the
generate_ddl script, you must specify the same arguments as when creating
the original DSODB repository, so that the drop scripts will drop that
original repository. For example, if the original DSODB repository was
created as a new database, with the 'new' argument to generate_dll, you 
must include the 'new' argument in order to generate appropriate drop 
scripts. 

Option 2 - Alter the existing schema 

Alternatively you could modify the DSODB schema in-place. In order to
do this you should run the patched script file 
        alter_dsodb_xmltype_columns.sql
found in 
  	.../IBM/InformationServer/Server/DSODB/scripts/Oracle11g
Enter the command:
    sqlplus oracle_system_user/oracle_system_password@database_service_name 
           @alter_dsodb_xmltype_columns.sql
   
    Example: sqlplus system/manager@ORCL @alter_dsodb_xmltype_columns.sql
  
After performing either of the manual steps, you should restart AppWatcher
by starting the DataStage AppWatcher service on windows or running:
    .../IBM/InformationServer/Server/DSODB/bin/DSAppWatcher.sh -start
on unix as the datastage administration user (e.g. dsadm).