PH68271: ADB1223E ADB2REM: UNEXPECTED SQLCODE IN : FETCH C_PENDING_DROP_COL LOOP; DSNT408I SQLCODE = -305, ERROR: T 25/09/24 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This problem will happen only when GEN is run on objects that
  have old, unmaterialized pending changes executed prior to Db2
  12.
  

Local fix

• As a workaround, customer can materialize these pending changes
  or drop them. To find affected objects, run SQL: 'SELECT * FROM
  SYSIBM.SYSPENDINGDDL WHERE REORG_SCOPE_LOWPART IS NULL;' .
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who process table spaces and tables that     *
  *                 have unmaterialized pending changes from     *
  *                 ALTER operations that were executed in       *
  *                 Db2 11 or earlier                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADB1223E ADB2REM:  Unexpected sqlcode   *
  *                      DSNT408I SQLCODE = -305                 *
  ****************************************************************
  This change corrects processing of table spaces and tables to
  support unmaterialized pending changes from Db2 11 or earlier.
  This APAR also re-ships all parts in PE APARs PH67403 and
  PH67457.
  

Problem conclusion

• The problem has 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:

  UO05253

Modules/Macros

• ADB1000  ADB2     ADB21II1 ADB21S   ADB21SA  ADB21SA0 ADB21SAP
  ADB21SAR ADB21SAY ADB21SP  ADB21T   ADB21TA  ADB21TAP ADB21TAV
  ADB21VV  ADB21XA  ADB21XAR ADB21XAS ADB26CXC ADB27AC  ADB27AP
  ADB27C   ADB27C0  ADB27CA  ADB27CAA ADB27CMR ADB27CPC ADB27CPV
  ADB27CX  ADB27DUP ADB27PAS ADB28MC  ADB2ALL0 ADB2CDC  ADB2CID
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CVC  ADB2DEP  ADB2ELOB
  ADB2FMM  ADB2FMP  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2OVW  ADB2PA
  ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2PCO  ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2REU  ADB2REY
  ADB2REZ  ADB2RGC  ADB2RPT  ADB2WCL  ADB2WIN  ADB2WVL  ADB33
  ADB44    ADB7000  ADB80    ADBASW   ADBCCM   ADBCCMM  ADBCDTS
  ADBCEST  ADBCHST  ADBCP    ADBCRCR  ADBCSPG  ADBCVC   ADBCVCT
  ADBCVEY  ADBCVIC  ADBCVOC  ADBDAT   ADBDK    ADBE7ALT ADBGDDL
  ADBGMP   ADBGMSP  ADBH1SA  ADBH1SAR ADBH1TA  ADBH1TAV ADBH7C
  ADBH7CA  ADBH7CPV ADBHPCO  ADBLI    ADBNSPB  ADBP7AD  ADBPA
  ADBPA1   ADBPPDC  ADBSPCO  ADBTEP2  ADBTEPI  ADBTEPR  ADBTEPU
  ADBV99   ADBVERS  ADBVFC   ADBVFCA  ADBVFCF  ADBVVFG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO05253

     UP25/10/11 P F510 {

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.