PK56285: ABEND0C8 IN ADB27AC ROUTINE CONVERT_UNLOAD SECONDARY SYMPTOM ONCODE340 SIZE CONDITION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running DB2 Object Compare Tool against a very large DDL set
  can result in abend0c8 in convert step. Oncode 340 size
  condition is also noted. Error messages appear similar to:
  SYSTEM ABEND CODE 0C8   REASON CODE 00000008
  IBM0342S ONCODE=340  The SIZE condition was raised.
     From compile unit ADB27AC at entry point CONVERT_UNLOAD
     at statement 7362 at compile unit offset +0009D67C
     at entry offset +00006644 at address 2D3E3C74.
  .
  Additional symptoms: abends0c8 0c8 s0c8 rc8 rc08
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool attempting to        *
  *                 alter a table generating more than           *
  *                 32767 conversion errors.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a table alter generates more than    *
  *                      32767 conversion errors, module         *
  *                      ADB27AC abends with an 0C8.             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Since the variable used to count the number of conversion
  errors, nbr_conv_errors, is declared as Bit(15), it can only
  count up to 32767.
  

Problem conclusion

• Increase the size of nbr_conv_errors from Bit(15) to Bit(31).
  

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

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK35294

     UP08/04/16 P F804

• R720 PSY UK35295

     UP08/04/16 P F804

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.