IBM Support

PK20188: GOC JOB FAILS WITH IBM0855S ONCODE=3809 THE LENGTH OF A DATA AGGREGATE EXCEEDED THE MAXIMUM LIMIT WHEN MASK AND IGNORE USED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Object Comparision Tool job fails with a message:
    IBM0855S ONCODE=3809  The length of a data aggregate exceeded
    the maximum limit
    when the MASK dataset contains a mask with identical values:
    DBNAME:DSNDB06,DSNDB06
    .
    Additional symptoms: oncode3809 abendu4038
    

Local fix

  • Ensure that the masking being used does not specify duplicate
    values.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
    *                 use MASK and IGNORE, may be affected.        *
    ****************************************************************
    * PROBLEM DESCRIPTION: GOC job fails with IBM0855S ONCODE=3809 *
    *                      The length of a DATA AGGREGATE exceeded *
    *                      the maximum limit when  MASK AND IGNORE *
    *                      used.                                   *
    *                      .*                                      *
    *                      ABEND U4038 occurs in GOC2CMP - section *
    *                      CREATE_REORGS                           *
    *                      .*                                      *
    *                      Tables  gets  dropped-recreated instead *
    *                      of  just  a simple ALTER when ID-column *
    *                      is  added  at  the  end of the table in *
    *                      Object Compare.                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The DB2 Object Comparision Tool job fails with a message:
    IBM0855S ONCODE=3809  The length of a data aggregate exceeded
    the maximum limit  when the MASK dataset contains a mask with
    identical values.
    

Problem conclusion

  • Apply the fixes.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK20188

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-02-21

  • Closed date

    2006-03-30

  • Last modified date

    2006-06-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK13141 UK13142

Modules/Macros

  •    GOC2CMF
    

Fix information

  • Fixed component name

    DB2 OBJECT COMP

  • Fixed component ID

    5697G6400

Applicable component levels

  • R310 PSY UK13141

       UP06/04/20 P F604

  • R710 PSY UK13142

       UP06/04/19 P F604

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUVH","label":"IBM Db2 Object Comparison Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021