A fix is available
APAR status
Closed as program error.
Error description
internal structure is built incorrectly.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 users * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C200BA when loading data * * to a table after migration to V8 * **************************************************************** * RECOMMENDATION: * **************************************************************** After migration to version 8, ALTER TABLE ADD PARTITION can be used to add partition to a partitioned table. If the partitioned table space was created with page size that is 8K or larger, then the above abend may occur when data is inserted into the new partitions. The problem was caused by incorrect values stored in the internal structure when a partitioning index is created. However, the incorrect value will not cause any operational problem prior to version 8.
Problem conclusion
DB2 code has been fixed so that new indexes will be created with the correct value stored in the internal structure.
Temporary fix
Comments
APAR Information
APAR number
PK48984
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-07-13
Closed date
2007-12-29
Last modified date
2008-02-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK32679 UK32680
Modules/Macros
DSNGDBIX
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 February 2008