|
Problem IC78956
|
Status: Closed |
INCORRECT SPACE ESTIMATION MAY RESULT IN SQL2094 DURING ALTER TABLESPACE WITH REBALANCE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 fixpack 6 *
**************************************************************** |
| Local Fix: |
create new container paths in different file system |
| available fix packs: |
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 |
create new container paths in different file system |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84596
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.09.2011
03.08.2012
03.08.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
