|
Problem IC84596
|
Status: Closed |
INCORRECT SPACE ESTIMATION MAY RESULT IN SQL2094 DURING ALTER TABLESPACE WITH REBALANCE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When new file system paths are added to the filesystem which
already contains pre existing containers
on the same file system path for the tablespace, the free space
information from the file system is
pulled, and translated into a path-specific information. For
example, if 2 new paths are added to a
filesystem which already had 2 pre existing paths for the same
tablespace in the same filesystem, the new space estimation is
calculated
Total freespace / number of filepaths
And hence in this case it would be,
total freespace/4
which is incorrect, as this check is neglecting the fact that
only two out of these four paths are going to require
the freespace for the container creation, and hence may result
in SQL2094N |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users before this release *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to the latest fix pack *
**************************************************************** |
| Local Fix: |
create new container paths in different file system |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
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 :
| 14.06.2012
06.11.2012
06.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
