PM51233: MSGIRX0040I ERROR RUNNING ADB2DIP WHEN REPORTING DROP IMPACT ON DATABASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS DROP DATABASE fails when
  Drop Impact Report is requested, and ADB2GEN produces more than
  9999 catalog records.
  .
  Problem only occurs when the number of catlog records written is
  a 5 digit number, or larger. Error messages reported are similar
  to the following:
  .
  For BATCH job execution:
           ADB2GEN - Summary of catalog records written
                    Number of catalog records written:   12341
    1064 +++      g.seq2   = format(reccount,4)
     236 +++   call BldOutTbl       /*Load Output Table       */
  IRX0040I Error running ADB2DIP, line 1064: Incorrect call to
           routine ISPD117
  The initially invoked CLIST ended with a return code = 20040
  ...
  For online execution, entering YES to prompt in panel ADB26DD :
  .
       Display Drop Impact Report ===> YES (Yes, No, or Batch)
  .
  the following error reports are seen, online:
  .
  *Function : SELECT CMD(%ADB2DIP DATABASE T2323605 TSO DEBUGPN())
  *
  * Retcode  : 20040
  *
  * Zerrmsg  : ADB221S
  .
  *Function : ADBR RUN PROGRAM(ADBMAIN) PLAN(ADB10MPE) PARMS(
      '/PANEL=ADB2,DB2S=DSN9,')
  *   Retcode  : 1000
  .
  Additional symptoms: rc1000 rc20040 ADB2DIP msgadb221s
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who drop DB2 objects and choose to      *
  *                 display the Drop Impact Report.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      DROP DATABASE fails when a Drop Impact  *
  *                      Report is requested and ADB2GEN         *
  *                      produces more than 9999 catalog         *
  *                      records.                                *
  *                                                              *
  *                      Problem only occurs when the number     *
  *                      of catalog records is a 5 digit         *
  *                      number or larger. Error messages        *
  *                      reported are similar to the following:  *
  *                                                              *
  *                      For batch job execution:                *
  *                      ADB2GEN - Summary of catalog            *
  *                                records written               *
  *                                Number of catalog records     *
  *                                written:   12341              *
  *                      1064 +++ g.seq2 = format(reccount,4)    *
  *                         236 +++  call BldOutTbl              *
  *                      IRX0040I Error running ADB2DIP,         *
  *                               line 1064: Incorrect call      *
  *                               to routine ISPD117             *
  *                      The initially invoked CLIST ended       *
  *                      with a return code = 20040              *
  *                      .                                       *
  *                      For online execution:                   *
  *                      Function : SELECT CMD(%ADB2DIP          *
  *                                  DATABASE dbname TSO         *
  *                                  DEBUGPN())                  *
  *                                                              *
  *                      Retcode  : 20040                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS Drop Impact Report
  function fails when the program ADB2GEN produces more than
  9999 catalog records.
  

Problem conclusion

• 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:

  UK75070 UK75071

Modules/Macros

•    ADB2DIP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75070

     UP11/12/24 P F112

• R720 PSY UK75071

     UP11/12/24 P F112

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.