DB2 FOR LUW / DB2FORLUW / 970 - DB2

On Windows, while using Data Studio, If the queries were run 
through DAS, content specified inside two '%' signs or adjacent 
to single '%' sign can be omitted by windows, as Windows env 
variable. 
 
For example: 
CALL SYSPROC.AUTOMAINT_SET_POLICY ( 'AUTO_REORG', BLOB('<?xml 
version="1.0" encoding="UTF-8"?><DB2AutoReorgPolicy 
xmlns="http://www.ibm.com/xmlns/prod/db2/autonomic/config"><Reor 
gOptions dictionaryOption="Keep" indexReorgMode="Offline" 
useSystemTempTableSpace="false"/><ReorgTableScope 
><FilterClause>TABSCHEMA LIKE ''%OPM%'' or TABSCHEMA LIKE 
''%SYS%''</FilterClause></ReorgTableScope ></DB2AutoReorgPolicy> 
') ); 
 
Can be treated as: 
 
CALL SYSPROC.AUTOMAINT_SET_POLICY ( 'AUTO_REORG', BLOB('<?xml 
version="1.0" encoding="UTF-8"?><DB2AutoReorgPolicy 
xmlns="http://www.ibm.com/xmlns/prod/db2/autonomic/config"><Reor 
gOptions dictionaryOption="Keep" indexReorgMode="Offline" 
useSystemTempTableSpace="false"/><ReorgTableScope 
><FilterClause>TABSCHEMA LIKE '''' or TABSCHEMA LIKE 
''''</FilterClause></ReorgTableScope ></DB2AutoReorgPolicy> ') 
);

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v9.7fp11 or above                                  * 
****************************************************************

Use other connectors than DAS to connect to server through Data 
Studios.

First fixed in v9.7fp11

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.03.2014
23.10.2015
23.10.2015

9.7.FP11