A fix is available
APAR status
Closed as new function.
Error description
Support for Db2 v12 FL 507.
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 enhancements to * * support Db2 12 function level 507. * * * * Changes are in the following * * areas: * * * * 1. Driver * * 2. Parser and DDL reader * * 3. Create * * 4. GEN * * 5. Compare * * 6. Masking * * 7. WSL cloning * * 8. Formatter * * 9. Change Management (CM) import * **************************************************************** The following enhancements support Db2 12 function level 507: 1. Driver The APPLCOMPAT field is displayed on the main Db2 Admin Menu (panel ADB2). This field uses the value of the CURRENT APPLICATION COMPATIBILITY special register. This value is initially set to the APPLCOMPAT value with which the ADBMAIN (driver) package was bound (APPLCOMPAT value of BIND PACKAGE ADBMAIN member). 2. Parser and DDL reader The Admin SQL parser and DDL reader is enhanced to support CREATE OR REPLACE PROCEDURE. 3. Create When creating a procedure, a user can select the 'OR REPLACE' option on panel ADB26CO 'Create Procedure'. This option allows creating a procedure that already exists and replacing the existing procedure. Also, panel ADB26COV 'Create Procedure Options' has a new SPECIFIC clause that is prefilled with the procedure name that was entered by the user. 4. GEN A new option 'R' is available for CREATE PROCEDURE on panel ADB2GENS 'Generate SQL from DB2 catalog'. This option generates the CREATE OR REPLACE procedure statement for an external non-SQL procedure or a native SQL procedure (NSP). 5. Compare Compare supports CREATE OR REPLACE PROCEDURE for an NSP so that the NSP can be altered without dropping and recreating the NSP when Db2 allows it. 6. Masking Users can mask the specific name of an NSP with the STPNAME name mask, which also masks the stored procedure name. 7. WSL cloning Work statement list (WSL) cloning supports masking the specific name of a NSP with the STPNAME name mask. 8. Formatter Formatter now supports formatting CREATE OR REPLACE PROCEDURE with the SPECIFIC clause. 9. Change Management (CM) import CM import supports the new OR REPLACE option of the CREATE PROCEDURE statement. CM import also supports masking the specific name of a NSP with the STPNAME name mask.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH28647
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-19
Closed date
2020-09-28
Last modified date
2020-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71802
Modules/Macros
ADB1000 ADB2 ADB26 ADB26CO ADB26COV ADB27AC ADB28MC ADB2CID ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2FMT ADB2GENS ADB2GENX ADB2GET ADB2ISQ ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2RE ADB2REE ADB2REG ADB2REH ADB2REY ADB2REZ ADB2WCL ADB2WIN ADB2WVL ADB3000 ADB7000 ADB82 ADBASW ADBCCM ADBCCMM ADBCDTS ADBCEST ADBCHST ADBCRCM ADBCRCR ADBCSPG ADBDAT ADBDK ADBE7OA0 ADBH ADBH6CO ADBH6COV ADBH8MG ADBHGEN ADBHPCO ADBLI ADBMAIN ADBNSPB ADBP7O ADBP7OA0 ADBPA ADBPA1 ADBTEP2 ADBTEPI ADBTEPR ADBTEPU ADBV99 ADBVERS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI71802
UP20/09/30 P F009
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
12 February 2021