PI46732: GEN ADB1223E ADB2REM: UNEXPECTED SQLCODE IN : SELECT SYSAUXRELS 100

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function fails
  with a message:
  ADB1223E ADB2REM:  Unexpected sqlcode in : Select sysauxrels 100
  .
  DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH,
  UPDAT
            OR THE RESULT OF A QUERY IS AN EMPTY TABLE
  DSNT418I SQLSTATE   = 02000 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXRFF SQL PROCEDURE DETECTING ERROR
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the Generate (GEN)          *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using GEN on table                 *
  *                      SYSIBM.SYSDBD_DATA,                     *
  *                      SYSIBM.SYSSPTSEC_DATA,                  *
  *                      or SYSIBM.SYSSPTSEC_EXPL,               *
  *                      GEN fails with a Return Code 12 /       *
  *                      RC=12, SQLCODE = 100 /                  *
  *                      SQLCODE100, error message               *
  *                      ADB1223E / msgadb1223e,                 *
  *                      and warning message                     *
  *                      ADB1666W / msgadb1666w:                 *
  *                                                              *
  *                      DSNT404I SQLCODE = 100,                 *
  *                      NOT FOUND:  ROW NOT                     *
  *                      FOUND FOR FETCH,                        *
  *                      UPDATE OR THE RESULT                    *
  *                      OF A QUERY IS AN EMPTY                  *
  *                      TABLE                                   *
  *                      DSNT418I SQLSTATE   = 02000             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      ADB1223E ADB2REM:                       *
  *                      Unexpected sqlcode                      *
  *                      in : Select sysauxrels 100              *
  *                                                              *
  *                      ADB1666W A SYSAUXRELS                   *
  *                      row was not found                       *
  *                      for the DB2 auxiliary table             *
  *                      SYSIBM.SYSDBD_DATA.                     *
  *                      The DB2 table space                     *
  *                      will not be generated.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using GEN on table SYSIBM.SYSDBD_DATA,
  SYSIBM.SYSSPTSEC_DATA, or SYSIBM.SYSSPTSEC_EXPL,
  GEN fails with a Return Code 12 / RC=12, SQLCODE = 100,
  error message ADB1223E / msgadb1223e, and warning message
  ADB1666W /msgadb1666w.
  

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:

  UI33503 UI33504 UI33505

Modules/Macros

•    ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI33503

     UP15/12/04 P F512

• RB10 PSY UI33504

     UP15/12/04 P F512

• RB20 PSY UI33505

     UP15/12/04 P F512

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.