A fix is available
APAR status
Closed as program error.
Error description
This APAR contains fixes for various defects found internally, regarding changes done to Native Stored Procedures (NSPs) and other issues. Keywords: SQLCODE = -551; SQLCODE551N; SQLCODE = -478; SQLCODE478N; SQLCODE = -20314; SQLCODE20314N; ONCODE = 520; ONCODE520; ADB9409E; msgadb9409e; ADB3014E; msgadb3014e; SQLCODE = -478 ; SQLCODE478N; ONCODE = 8094; ONCODE8094; SQLCODE20356N
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool for * * z/OS and Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides fixes for the * * following issues: * * * * 1. Applying a native stored * * procedure (NSP) change in the * * source to the target might cause * * SQLCODE=-551 due to a missing NSP * * execution privilege. * * * * 2. Compare might generate an * * incorrect work statement list (WSL) * * for a sequence with a dependent * * user-defined type (UDT). The WSL * * fails with SQLCODE=-478. * * * * 3. The wrong version of an NSP * * might be activated when Change * * Manager processes the CREATE OR * * REPLACE statement for the NSP. * * * * 4. An incorrect line command on the * * ADB27CA panel might block a correct * * primary command due to the "Too * * many operations" error. * * * * 5. No warning message is displayed * * when the EXTERNAL NAME value on the * * ADB26COV panel is invalid for an * * NSP. * * * * 6. The ADB26COV panel allows altering * * the CCSIDs parameters. An error * * (SQLCODE = -20314) might occur after * * applying the changes. * * * * 7. An error (ONCODE = 520) might * * occur when comparing a function * * that has more then 30 parameters of * * default/user-defined type. * * * * 8. Parser error ADB9409E might * * occur when importing a Compare * * changes file in Change Manager with * * the 'replace existing change' option * * on the ADB2CRO panel. * * * * 9. Lost parameters for an NSP causes * * DROP and CREATE operations. * * * * 10. Clone table GRANTs are not * * propagated during a comparison when * * a new clone table is added as a * * source-only object. When a new * * history table with GRANTs is added * * to the comparison, an ALTER TABLE * * ADD VERSIONING statement might be * * generated with an incorrect history * * table name. When the source is DDL * * and the history table GRANTs are * * placed after the ALTER TABLE ADD * * VERSIONING statement, history table * * GRANTs are not propagated. * * * * 11. When the 'S' line command is * * issued on the ADBPMPSO panel for * * the wrong parameter type, the * * uninformative error "Invalid value" * * is displayed. * * * * 12. Sequence information is not * * displayed on the ADBP7Q panel after * * applying virtual changes. * * * * 13. WSL validation might fail with * * error ADB3014E on the CREATE * * PROCEDURE statement. * * * * 14. An error (SQLCODE = -478) might * * occur when dropping an NSP with a * * dependent NSP by using Compare. * * * * 15. When Change Manager changes * * table partitions and virtual * * changes are used, Analyze can fail * * with ONCODE condition 8094 or an * * invalid NUMPARTS value can be * * generated for the CREATE TABLESPACE * * statement. When the ALT function * * applies virtual changes to table * * partitions, the ADD command on * * the ADB27CPV panel adds a partition * * with the wrong partition number. * * * * 16. An error (SQLCODE = -20356) * * might occur during a TRUNCATE * * operation on a parent table when * * recovering a change with the * * original data. * **************************************************************** This APAR provides fixes to resolve the above errors. Keywords: SQLCODE551N; SQLCODE478N; SQLCODE20314N; ONCODE520; msgadb9409e; msgadb3014e; SQLCODE478N; ONCODE8094; SQLCODE20356N
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH37477
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-05-24
Closed date
2021-08-13
Last modified date
2021-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI76735
Modules/Macros
ADB21TAV ADB26 ADB26COU ADB26COV ADB27CA ADB27CPV ADB2C14 ADB2CDC ADB2CID ADB2CIMP ADB2CM1 ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2MSK ADB2OVW ADB2RE ADB2REE ADB2REG ADB2REM ADB2REP ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RPT ADB2WVL ADBCCMM ADBCDTS ADBCP ADBCVC ADBCVCP ADBCVCT ADBCVEY ADBCVIC ADBCVOC ADBE7QA0 ADBGDDL ADBH6COV ADBMAIN ADBP7Q ADBP7QA0 ADBP7SA0 ADBPMSPO ADBVFC ADBVFCA ADBVFCF ADBVVFG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI76735
UP21/08/19 P F108
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
02 September 2021