|
Problem IC73999
|
Status: Closed |
ADMIN_MOVE_TABLE FAILS WITH SQL0104N DURING SAMPLING TO CREATE A COMPRESSION DICTIONARY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Upgrade to DB2 V97 FP4 or higher |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC74019
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2011
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
