PH67162: JULY 2025 BUG FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• July 2025 Bug Fixes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes to resolve     *
  *                      the issues described in the problem     *
  *                      summary.                                *
  ****************************************************************
  This APAR fixes the following issues:
  
  1. When GEN is called to generate the DDL for a view that has a
     128-character name, a message about an oncode=150 is raised:
     IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
     From entry point VIEW_STMT at statement nnnnn at compile unit
     offset
  2. When exporting a mask with spaces in the name to Change
     Management, error message ADB9072E is displayed.
  3. A WSL validation job might hang when authorization switching
     is enabled on the GOC5 panel.
  4. IBM00441W ONCODE 150 in ADD_SYMBOL_COLS_CTLG can occur when
     generating DDL for a view with more than 25 columns and at
     least one LOB column.
  5. The DDL reader fails with message "ONCODE condition 8094 has
     been detected from location INSERT_SQL_VAR" when the
     processed DDL includes the DROP FUNCTION with parameters.
  6. When the terminal is configured with Model 2 (24x80), the
     following panels fail with message "Panel definition too
     large, greater than screen size":
     - GOCMENU
     - GOC1
     - GOC12
     - GOC13
     - GOC1VS
     - GOC3
  
  7. When creating the catalog copy over the existing one created
     by another user, DDLBNDxx job fails with SQLCODE=-204
     during ALTER TABLE XSRANNOTATIONINFO DROP RESTRICT ON DROP.
  8. When GEN is executed with the 'CREATE INDEX' option set to N,
     the primary key is missing from the table.
     When GEN is executed with the 'CREATE INDEX' option set to Y,
     the DDL contains an explicit index instead of implicit one.
  

Problem conclusion

• The problems have been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO03983

Modules/Macros

• ADB2CC   ADB2CLUP ADB2ISQ  ADB2PA   ADB2PRP  ADB2REM  ADBPC15
  ADBRPGM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03983

     UP25/07/09 P F507

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.