A fix is available
APAR status
Closed as program error.
Error description
DELIVER FORWARD FITS FOR AOC 11.2 - VARIOUS APARS - PART 2: PI43880,PI37750,PI39492,PI43895,PI44240,PI44594,PI44576. PI46734,PI47213,PI46254,PI31811,PI43079,PI35322. ALSO CONTAINS FIX FOR APAR PI52775.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR delivers the following * * fixes for DB2 Administration Tool * * for z/OS, Version 11, Release 2: * * * * PI43880 * * DB2 ADMINISTRATION TOOL FOR Z/OS * * WHEN USING DDL COMMAND ON A VIEW * * MAY RESULT IN MESSAGE : * * UNEXPECTED TOKEN AFTER * * AS KEYWORD. * * * * PI37750 * * DB2 ADMIN TOOL DDL LINE COMMAND * * DOES NOT FORMAT VIEW WITH NESTED * * CAST CLAUSE. * * * * PI39492 * * ADBTEP2 CONNECT TO FAILS * * W/ADB5146E ERROR MSG WITH * * NO ADDL INFO. * * * * PI43895 * * DB2 ADMIN ISSUES SQLCODEN423 * * FROM SQ CMD ON PANEL ADB21K. * * * * PI44240 * * RC12 ADB7199E STORED * * PROCEDURE >SP_PACKAGE_NAME< * * CAN NOT BE DROPPED BECAUSE * * STORED PROCEDURE * * >SP_PACKAGE_NAME< DEPENDS * * UPON IT. * * * * PI44594 * * DB2 ADMINISTRATION TOOL FOR * * Z/OS DOES NOT TRIM DATABASE * * AND TABLE SPACE WHEN USING * * CM NO AND RUN REORG/REBUILD. * * * * PI44576 * * DB2 ADMINISTRATION TOOL FOR * * Z/OS ISSUES SQLCODE -601 * * SQLCODEN601 WHILE RUNNING * * A CHANGE WITH CREATE VIEW. * * * * PI46734 * * GEN WORKFILE RELATED OBJECT * * MISSING SYNTAX INDEXBP SEGSIZE. * * * * PI47213 * * ADB7184E A DUPLICATE RECORD * * WAS DETECTED FOR OBJECT STOGROUP. * * * * PI46254 (PI52775 DELIVERY) * * DB2 ADMINISTRATION TOOL FOR Z/OS * * DURING MIGRATION OF TABLESPACE * * WITH IDENTITY COLUMN ENCOUNTERS * * DUPLICATE KEY. * * * * PI31811 * * OBJECT COMPARE FAILS WITH RC8 * * TABLE SAME NAME. * * * * PI43079 * * VALIDATE WORK STATEMENT LIST * * REPORT INCORRECTLY ISSUES * * ADB3014E FOR VIEW COLUMN. * * * * PI35322 * * WSL VALIDATE ISSUES RETURN * * CODE 8 WITH ADB3006E ERROR * * MESSAGES BECAUSE OF * * SQLCODE -553. * * * * Please see the original APAR for * * additional details regarding * * what was fixed. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR delivers the following fixes for DB2 Administration Tool for z/OS, Version 11, Release 2: PI43880 PI37750 PI39492 PI43895 PI44240 PI44594 PI44576 PI46734 PI47213 PI46254 PI31811 PI43079 PI35322 This APAR also contains the fix for APAR PI52775 (provided by the forward fit of PI46254).
Problem conclusion
Fixes are delivered.
Temporary fix
Comments
APAR Information
APAR number
PI54572
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-12-28
Closed date
2016-01-25
Last modified date
2016-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI34739
Modules/Macros
ADBCIMV ADBCVSE ADBTEP2 ADB2CME ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2CM2 ADB2FMT ADB2PA ADB2RE ADB2REE ADB2REG ADB2REM ADB2REZ ADB2WVL ADB21K ADB21KSQ ADB3000 ADB5000 ADB7000
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB20 PSY UI34739
UP16/01/28 P F601
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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2016