home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC73999 Status: Geschlossen

ADMIN_MOVE_TABLE FAILS WITH SQL0104N DURING SAMPLING TO CREATE A
COMPRESSION DICTIONARY

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Users will get SQL0104N: 
 
An unexpected token "," was found following " ".  Expected 
tokens may include:  "CONCAT".  SQLSTATE=42601 
 
Prerequisites: 
 
- Row compression enabled on source table. If target table is 
given, row compression is enabled on the the target table. 
 
- Database need to run under a locale that uses comma in 
floating point numbers e.g. de_DE 
- Table that should be moved is bigger than 
DEEPCOMPRESSION_SAMPLE (default: 20MB).
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V97 and prior                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ADMIN_MOVE_TABLE FAILS WITH SQL0104N DURING SAMPLING TO      * 
* CREATE A                                                     * 
* COMPRESSION DICTIONARY                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* - If applicable, change your database server to a different  * 
*                                                              * 
* database locale that uses dot in floating point numbers e.g. * 
*                                                              * 
* en_US.                                                       * 
*                                                              * 
* - Use ADC instead of sampling by setting                     * 
* DEEP_COMPRESSION_SAMPLE                                      * 
* to 0 using ADMIN_MOVE_TABLE_UTIL. This may lead to a         * 
* suboptimal                                                   * 
* compression dictionary.                                      * 
****************************************************************
Local-Fix:
- If applicable, change your database server to a different 
database locale that uses dot in floating point numbers e.g. 
en_US. 
- Use ADC instead of sampling by setting DEEP_COMPRESSION_SAMPLE 
to 0 using ADMIN_MOVE_TABLE_UTIL. This may lead to a suboptimal 
compression dictionary.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Upgrade to DB2 V97 FP4 or higher
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC74019 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.01.2011
02.05.2011
02.05.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList