PH36475: ONCODE-8094 IN ADBTEP2 WHEN ATTEMPTING TO AUTOMATICALLY SET APPLCOMPAT TO OVERCOME ADB5146E SQLCODE = -20008

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ONCODE-8094 in ADBTEP2 when attempting to automatically set
  applcompat to overcome SQLCODE -20008:
  
  ADB5146E ADBTEP2  Unexpected SQLCODE -20008 in :EXECUTE
  ADB7953I ADBTEP2  Current applcompat = V12R1M508. Set to
                                    function level 503 and retry.
  IBM0534S ONCODE=8094  Protection exception
           From entry point ADB8SQL at statement 424 at compile
           unit
           offset >offset< at entry offset >offset< at
           address >offset<.
  
  
  Keyword:  msgadb5146e; msgadb7953I; oncode8094; sqlcode2008N
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for z/OS *
  *                 who use ADBTEP2 to retry the same DDL        *
  *                 statement when SQLCODE -20008 is returned    *
  *                 for deprecated objects.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: At retry, the existing DDL statement in *
  *                      the storage was damaged. Therefore,     *
  *                      ONCODE=8094 is returned.                *
  ****************************************************************
  ONCODE=8094 is returned because of damaged
  storage:
  
  ADB5146E ADBTEP2 Unexpected SQLCODE -20008 in :EXECUTE
  ADB7953I ADBTEP2 Current applcompat = V12R1M508. Set to
  function level 503 and retry.
  IBM0534S ONCODE=8094 Protection exception
  From entry point ADB8SQL at statement 424 at compile unit
  offset >offset< at entry offset >offset< at
  address >offset<.
  
  Note: Statement numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  

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:

  UI75083

Modules/Macros

• ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75083

     UP21/04/28 P F104

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.