PM21881: CM IMPORT FAILS WITH ABENDS322 ONCODE150 STRINGSIZE CONDITION FROM ENTRY POINT ADB2CID AT STATEMENT 1273

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool Change Management IMPORT operation of
  customer's CHG file fails with abends322 showing the following
  error message in joblog:
  .
  IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
    From entry point ADB2CID at statement 1273 at compile unit
    offset +0000
  .
  When deleting statements from a change on panel ADB2C1S
  the following message may be seen:
  UNEXPECTED SQLCODE IN : DELETE FROM ADBCHGS
   DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH,
  UPDATE, OR DELETE
  
  Additional symptoms: abend322 timeout SQLCODE100
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use Import.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      When running Import in batch            *
  *                      mode an ONCODE=150                      *
  *                      occurs:                                 *
  *                                                              *
  *                      ONCODE=150 The STRINGSIZE               *
  *                          condition was raised.               *
  *                          From entry point ADB2CID at         *
  *                          statement 1273 at compile unit      *
  *                          offset +00001908                    *
  *                          address 34A18228.                   *
  *                                                              *
  *                      When a change is displayed              *
  *                      and the ST command is used to           *
  *                      display the statements on panel         *
  *                      ADB2C1S "CM - Change                    *
  *                      Statements", a D - delete               *
  *                      command can return a SQLCODE            *
  *                      100.                                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Change Management Import running in batch mode
  receives an ONCODE=150.  A delete of a statement
  on panel ADB2C1S "CM - Change Statements" can
  result in a SQLCODE 100.
  

Problem conclusion

• Program ADB2CID was modified to eliminate the
  ONCODE message and SQLCODE 100.
  

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:

  UK60742

Modules/Macros

•    ADB2CID
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK60742

     UP10/09/30 P F009

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.