A fix is available
APAR status
Closed as new function.
Error description
LOB SUPPORT IN OBJECT COMPARISON TOOL FOR Z/OS
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool * * for z/OS who include LOB objects in the * * Compare process. * **************************************************************** * PROBLEM DESCRIPTION: The following has been fixed: * * * * - Explicit LOB objects should not be * * generated if partitions are added to * * a Partition-by-Growth (PBG) table * * space via an 'ALTER TABLE ADD * * PARTITION' statement. * * * * - DDL is generated by DB2 Object * * Compare if a table with a LOB * * column is in a PBG table space * * and the source contains an incomplete * * set of LOB objects. In this case an * * explicit index was generated for an * * auxiliary table when the auxiliary * * table was converted from explicit to * * implicit during the compare process. * * * * - Explicitly created LOB objects are * * generated in the Changes (CHG) file * * in an incorrect sequence if a new * * partition is added through an 'ALTER * * TABLE ADD PARTITION' statement for * * a table with a LOB column in a non-PBG * * table space. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following has been fixed: - Explicit LOB objects should not be generated if partitions are added to a Partition-by-Growth (PBG) table space via an 'ALTER TABLE ADD PARTITION' statement. - DDL is generated by DB2 Object Compare if a table with a LOB column is in a PBG table space and the source contains an incomplete set of LOB objects. In this case an explicit index was generated for an auxiliary table when the auxiliary table was converted from explicit to implicit during the Compare process. - Explicitly created LOB objects are generated in the Changes (CHG) file in an incorrect sequence if a new partition is added through an 'ALTER TABLE ADD PARTITION' statement for a table with a LOB column in a non-PBG table space.
Problem conclusion
Temporary fix
Comments
Problems have been resolved.
APAR Information
APAR number
PI22605
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-07-24
Closed date
2014-08-14
Last modified date
2014-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB7000
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI20538
UP14/08/20 P F408
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:
03 September 2014