|
Problem IC87868
|
Status: Closed |
DB2 SHOWS PAGE MAP ERROR WHILE RESIZING A LARGE NUMBER OF CONTAINERS IMMEDIATELY AFTER CREATION OF TABLESPACE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| 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). |
| Problem Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.11.2012
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
