PI15802: GEN ADB1455E ADB2REP: UNEXPECTED SQLCODE IN : FETCH C_TRIGDEP2 SQLCODE100

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:
  
  ADB1455E ADB2REP:  Unexpected sqlcode in : Fetch c_trigdep2
  
  DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH,
  UPDATE, OR DELETE,
            OR THE RESULT OF A QUERY IS AN EMPTY TABLE
  DSNT418I SQLSTATE   = 02000 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXRFF SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -110  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF92'  X'00000000'  X'00000000'
  

Local fix

• Rerun the job.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the Generate (GEN)          *
  *                 function to generate a TRIGGER.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN function fails with error       *
  *                      message ADB1455E / msgadb1455e and      *
  *                      SQLCODE=100 / SQLCODE100:               *
  *                                                              *
  *                      ADB1455E ADB2REP:                       *
  *                      Unexpected sqlcode in :                 *
  *                      Fetch >trigger_name<                    *
  *                                                              *
  *                      DSNT404I SQLCODE = 100,                 *
  *                      NOT FOUND:  ROW NOT                     *
  *                      FOUND FOR FETCH,                        *
  *                      UPDATE, OR DELETE,                      *
  *                      OR THE RESULT OF                        *
  *                      A QUERY IS AN EMPTY                     *
  *                      TABLE                                   *
  *                      SQLSTATE   = 02000                      *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      When generating a TRIGGER.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN failed when generating a TRIGGER.
  

Problem conclusion

• This APAR does not fix the problem but instead allows for the
  collection of additional diagnostic information when the
  problem happens.
  

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:

  UI20541 UI20542

Modules/Macros

•    ADB2REM  ADB2REP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20541

     UP14/08/20 P F408

• RB10 PSY UI20542

     UP14/08/20 P F408

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.