A fix is available
APAR status
Closed as program error.
Error description
Running GOC2CMP returns: ADB7350E Module : ADB2CMF detected an ONCODE condition 520 in MODIFY_TOKENS at 26403 ADBC002E - Severe error. Compare terminates ADB0380E Module ADB2CMP - Severe error Compare terminates and: IBM0421S ONCODE=520 The SUBSCRIPTRANGE condition was raised. From entry point MODIFY_TOKENS at statement 26403 at compile unit offset +00000C26 at entry offset +00000C26 at address 3B624CD6. ERROR condition was raised Traceback of user routines: Compile Unit Entry Stmnt CU offset Entry offset Addr MODIFY_TOKENS 26403 +00000C26 +00000C26 3B624CD6 STORE_TGT_VIEW 23764 +00001EEC +00001EEC 3B63B44C KEEP_OBJECT 12064 +00006842 +00006842 3B6936CA DROP_OBJECT 14639 +0000E92A +0000E92A 3B6809AA CMR0008 2849 +000047AC +000047AC 3B5CCACC DROP_OBJECT_DRIVER 32062 +00000374 +00000374 3B4690BC COMPARE_FILES 5446 +0000A0A2 +0000A0A2 3B50A40A ADB2CMF 3585 +000020A8 +000020A8 3B459768 ADB2CMP 4439 +000089DE +000089DE 3B54AC16 GOC2CMP 172 +000000E2 +000000E2 3BC8C17A
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool * * for z/OS who compare VIEWs or TRIGGERs * * when the source or target VIEW or TRIGGER * * has a search-condition clause and the * * column name in the search condition is * * qualified by the table OWNER and table * * name. * **************************************************************** * PROBLEM DESCRIPTION: When comparing a source or target VIEW * * or TRIGGER that has a search-condition * * clause, Object Compare may return one * * or more of the following error * * messages: * * * * ONCODE=520 / ONCODE520, * * ADB7350E / msgadb7350e, * * ADBC002E / msgadbc002e, and * * ADB0380E / msgadb0380e * * * * ADB7350E Module : ADB2CMF * * detected an ONCODE condition * * 520 in MODIFY_TOKENS at 26403 * * * * ADBC002E - Severe error. * * Compare terminates * * * * ADB0380E Module ADB2CMP * * - Severe error Compare terminates * * * * IBM0421S ONCODE=520 * * The SUBSCRIPTRANGE * * condition was raised. * * From entry point * * MODIFY_TOKENS at * * statement 26403 at * * compile unit offset >offset< * * at entry offset >offset< * * at address >address< * * ERROR condition was raised * **************************************************************** * RECOMMENDATION: * **************************************************************** When comparing a source or target VIEW or TRIGGER that has a search-condition clause, Object Compare may return one or more of the following error messages: ONCODE=520 / ONCODE520, ADB7350E / msgadb7350e, ADBC002E / msgadbc002e, and ADB0380E / msgadb0380e
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI37101
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-03-17
Closed date
2015-05-14
Last modified date
2015-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI27634 UI27635
Modules/Macros
ADB2CMR ADB2PA
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":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 June 2015