DB2 - Problem description
Problem IT29582 | Status: Closed |
DB2DART SHOULD DETECT WHEN A CONTAINER SIZE IS LESS THAN THE SIZE OF THE TOTALPGS+PAGESIZE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
A backup can fail with an SQL0902C when the container for a tablespace was truncated and is smaller than the size of the Total Pages*PageSize for that tablespace. The db2dart tool should detect this level of corruption but currently does not. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
Use the "truncate" command to extend the tablespace container. For example, assume a tablespace has a total of 2000 pages and has a PageSize of 8K (8192 bytes).. 2000*8192=16384000 So the command to run would be: truncate --size=16384000 C0000000.LRG ... where C0000000.LRG is the container file name for the tablespace in question. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.06.2019 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |