|
Problem IT00394
|
Status: Geschlossen |
IF CONNECTING TO A DATABASE ON WINDOWS THROUGH IBM SSH, SOME SQLS FROM DATA STUDIO FAIL WITH '< WRONG USAGE' MESSAGE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
If you connect to a database on Windows from Data Studio
through IBM SSH, some SQL statements fail with '< wrong usage'
message.
For example,
When you perform 'Configure Automatic Maintenance' with
Automatic table and index reorganization option, 'CALL SYSPROC'
is generated but it fails with '< wrong usage' message.
When you try the following SQL on Data Studio SQL Editor, it
fails with '< wrong usage' message.
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>
') ) |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* IBM SSH on Windows user *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix *
* Pack 4) or higher *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.03.2014
23.02.2015
23.02.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
