PK40302: ADB2REM: UNEXPECTED SQLCODE IN : SELECT SYSDATATYPES SQLCODE+100 GOCC023E - UNKNOWN CATALOG RECORD FOR NEW "CREATE DISTINCT TYPE"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision job step T02DB2 fails with message:
  Generating DDL for Distinct Type aaa.aaa
  ADB2REM: Unexpected sqlcode in : Select sysdatatypes
  DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH,
  UPDATE, OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE
  R720 will issue a message:
  ADB1617W Requested Datatype aaa.aaa not found
  then fail in step T03COMP with message:
  GOCC023E - Unknown catalog record type:
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ADB2GEN when requesting GEN of      *
  *                 a user defined type.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: If the user defined type is not found,  *
  *                      V71 currently returns a return code of  *
  *                      12 with a sql error message.            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  ADB2GEN now issues a not found message with a return code of 4.
  

Problem conclusion

• The problem has been corrected.
  

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:

Modules/Macros

•    ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK30219

     UP07/10/25 P F710

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.