|
Problem IC87868
|
Status: Geschlossen |
DB2 SHOWS PAGE MAP ERROR WHILE RESIZING A LARGE NUMBER OF CONTAINERS IMMEDIATELY AFTER CREATION OF TABLESPACE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
If we create tablespace with large numbers (say 124) and try
to resize them after creation ,it shows error as
example given below.
db2 "alter tablespace USERSPACE4 RESIZE (all containers 2000K)"
DB21034E The command was processed as an SQL statement because
it was not a valid Command Line Processor command. During SQL
processing it
returned:SQL0259N Container map for table space is too
complicated.
SQLSTATE=54037.
However ,if we try to reconnect the db and resize ,it
completes resize successfully.
The above problem is not seen in case we create tablespace with
small number of containers (say 64). |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* db2luw users *
****************************************************************
* PROBLEM DESCRIPTION: *
* If we create tablespace with large numbers (say 124) and *
* try *
* to resize them after creation ,it shows error as *
* example given below. *
* *
* db2 "alter tablespace USERSPACE4 RESIZE (all containers *
* 2000K)" *
* DB21034E The command was processed as an SQL statement *
* because *
* it was not a valid Command Line Processor command. During *
* SQL *
* processing it *
* returned:SQL0259N Container map for table space is too *
* complicated. *
* SQLSTATE=54037. *
* *
* However ,if we try to reconnect the db and resize ,it *
* completes resize successfully. *
* *
* The above problem is not seen in case we create tablespace *
* with *
* small number of containers (say 64). *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 v10 fp2 *
**************************************************************** |
| Local-Fix: |
Reconnect the db and try to resize the containers |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.11.2012
01.04.2013
01.04.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
