PI93889: GOC APAR - BATCH ANALYZE COMMENT ON INDEX ADB1223E ADB2REM UNEXPECTED SQLCODE IN: SELECT SYSTABLES - SQLCODEN302

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• GOC APAR - BATCH ANALYZE COMMENT ON INDEX ADB1223E ADB2REM:
  UNEXPECTED SQLCODE IN: SELECT SYSTABLES - SQLCODEN302.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool          *
  *                 for z/OS who compare huge number of          *
  *                 objects.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: B37 error for SR2OUT data set occurs    *
  *                      if data set spreads to multiple         *
  *                      volumes.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When comparing huge number of objects which causes SRC2OUT
  data set spread to multi-volumes B37 error is encountered.
  

Problem conclusion

Temporary fix

Comments

• The problem has been resolved by using SRCSOUT and
  TGTSOUT data sets as SORT output and therefore avoiding
  the refer-back.
  

APAR Information

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

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

Modules/Macros

•    GOCCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB20 PSY UI54444

     UP18/03/20 P F803

• RC10 PSY UI54445

     UP18/03/20 P F803

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.