A fix is available
APAR status
Closed as program error.
Error description
If Run REORG/REBUILD is set to 'A' always, and a partition is being added to a table, Compare may generate two separate REORGs, one after the ALTER to lower the high value of the current last partition, and the second after the ALTER to add a partition. Since the second ALTER has not been executed, the REORG after the first ALTER may cause data loss.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Object Comparison Tool * * for z/OS who compare tables and the * * table needs to have the limit key of * * the last partition updated, and to have * * a new partition added. Also, the user * * specifies "Run REORG/REBUILD" = A * * on panel GOC5 "Generate Compare * * Jobs". * **************************************************************** * PROBLEM DESCRIPTION: An invalid REORG causes data loss. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 Object Comparison Tool compares two tables and specifies "Run REORG/REBUILD" = A on panel GOC5. The table needs to have the limit key of the last partition updated, and to have a new partition added. In the APPLY job, after the update to the limit key of the last partition, there is a REORG utility to be executed. This REORG causes data loss, as some of the data has been discarded.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI70326
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-10-06
Closed date
2017-04-25
Last modified date
2017-05-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI46778 UI46780
Modules/Macros
ADB2CMT
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 May 2017