A fix is available
APAR status
Closed as new function.
Error description
OC-OBJECT COMPARE LOB SUPPORT Non-LOB support new function was also delivered via this APAR as a new return code was added to the job output for the T03COMP step when the following message is issued: Table data conversion jobstep will be generated However the conversion will fail because of datatype mismatch The step will now terminate with a RC=08 when there is an invalid data conversion. Object Compare terminates due to incorrect RUNSTATS Utility statements: tablespace and table names are wrong. Error message: DSNU049I DSNUGPRS - INVALID OPERAND x FOR KEYWORD 'RUNSTATS'
Local fix
APPLY PTF.
Problem summary
**************************************************************** * USERS AFFECTED: who wish to change or unload tables with * * LOB columns. * **************************************************************** * PROBLEM DESCRIPTION: Changes to objects with LOB columns * * was previously restricted or offered * * limited capability. * * * * Additionally, LOB column data was * * unloaded to the SYSREC data set, * * with limitations on the maximum * * record length allowed. * * * * With this APAR, compare scenarios * * involving LOB objects now have * * expanded capabilities to allow * * changing the objects. * * * * Additionally, objects with LOB columns * * can now be unloaded with base table * * data going to the SYSREC data set and * * the LOB column data going to the data * * set as directed by the LOB TEMPLATE. * * This capability requires that the apply * * job be built as a work statement list. * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** This APAR delivers the supporting elements in DB2 Object Comparison Tool to allow changing of objects with LOB columns, and to unload LOB column data to a separate output data set using a LOB TEMPLATE.
Problem conclusion
Temporary fix
Comments
Apply the PTF to enable this support.
APAR Information
APAR number
PK70014
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
720
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-08-04
Closed date
2008-12-15
Last modified date
2009-03-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK42511
Modules/Macros
GOCGAJOB GOCGCMP GOCTUNL GOC2CMF GOC2CMP GOC2CMR GOC2CMS GOC2CMT GOC2DTC H25G720J
Fix information
Fixed component name
DB2 OBJECT COMP
Fixed component ID
5697G6400
Applicable component levels
R720 PSY UK42511
UP08/12/23 P F812
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":"SSAUVH","label":"IBM Db2 Object Comparison Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021