DB2 - Problembeschreibung
Problem IC74391 | Status: Geschlossen |
SYSPROC.ADMIN_MOVE_TABLE MAY RETURN SQL0104N IF TARGET TABLE HAS A DIFFERENT PCTFREE SETTING | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
SYSPROC.ADMIN_MOVE_TABLE() may return in error when PCTFREE is different between source and target tables and source table has the default PCTFREE value which is stored as "-1" in syscat.tables. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Using SYSPROC.ADMIN_MOVE_TABLE with different PCTFREE * * between source and target tables * **************************************************************** * PROBLEM DESCRIPTION: * * The issue occurs when the source table of the * * SYSPROC.ADMIN_MOVE_TABLE procedure has been defined with the * * default value for PCTFREE and the target has a different * * PCTFREE value. Following is an example on how this issue * * could occur: * * * * db2 create database test_1 * * db2 connect to test_1 * * db2 create tablespace systoolspace * * * * # 1. Create a table T1 with default PCTFREE * * db2 "CREATE TABLE S.T1 (I INT NOT NULL, C CHAR(1))" * * * * # 2. Create a table T2 with the same definition as table T1 * * except for the PCTFREE setting * * db2 "CREATE TABLE S.T2 (I INT NOT NULL, C CHAR(1))" * * db2 "ALTER TABLE S.T2 PCTFREE 10" * * * * # 3. Call ADMIN_MOVE_TABLES as follows: * * db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('S','T1','T2','','INIT')" * * SQL0104N An unexpected token "-" was found following "R * * TABLE S.T2 PCTFREE". * * Expected tokens may include: "<space>". SQLSTATE=42601 * * * * With the example above both source table T1 and T2 have a * * different PCTFREE setting and source table T1 has the * * default PCTFREE setting since it was not specified at table * * creation. This can further be confirmed by looking at * * PCTFREE value for source table T1 which is stored as "-1" in * * SYSCAT.TABLES. For the example above, this would be as * * follows. * * * * $ db2 "select tabname, pctfree from syscat.tables where * * tabname in ('T1','T2') and tabschema = 'S'" * * * * TABNAME PCTFREE * * ----------------------- --------- * * T1 -1 * * T2 10 * * * * 2 record(s) selected. * **************************************************************** * RECOMMENDATION: * * Upgrade to version 9.7 Fixpack 5 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in version 9.7 Fixpack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.02.2011 13.12.2011 13.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |