IBM Support

IZ69055: Error: "Attempt to access item beyond bounds of memory" running COBOL application after upgrade from DB2 v8.2 to DB2 v9.5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After upgrading from DB2 v8.2 to DB2 v9.5, the following memory
    error is reported when running an existing Cobol application
    that used to run fine in the DB2 v8.2 environment and which
    calls the sqlgcrea function.
    
    Error:
    error code: 114, pc=0, call=1, seg=0
    114     Attempt to access item beyond bounds of memory (Signal
    11)
    
    Steps to run the program:
    
    1- installed DB2 v9.5
    2- recompiled Cobol application with Micro Focus Cobol on the
    new system
    3- ran application. Result: Error reported
    Note: Running the old module (without recompiling it) runs fine,
    it only fails if it is recompiled on the new system.
    
    
    The following is a sample error output:
    
    $ ./COBDB2 COLTEST,/data/db2/coltest
    CREATing database ...
    please wait... this will take a while ...
    
    Execution error : file 'COBDB2'
    error code: 114, pc=0, call=1, seg=0
    114     Attempt to access item beyond bounds of memory (Signal
    11)
    
    Running the MicroFocus debug utility shows that the error is
    occurring on the "call sqlgcrea" statement.
    

Local fix

  • Modify sqlenv.cbl file to add $IF clause. For example, the
    modified file will look like this:
    
    (...)
          * default extent size
               05 SQLTSEXT               PIC S9(9) COMP-5.
    $IF P64 SET
               05 FILLER                    PIC X(4).
    $END
               05 SQLCATTS               USAGE IS POINTER.
               05 SQLUSRTS               USAGE IS POINTER.
    (...)
    
    
    instead of like this:
    
    (...)
          * default extent size
               05 SQLTSEXT               PIC S9(9) COMP-5.
    
               05 FILLER                    PIC X(4).
    
               05 SQLCATTS               USAGE IS POINTER.
               05 SQLUSRTS               USAGE IS POINTER.
    (...)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The sqledbdesc structure is incompatible between 32-bitcobol *
    * applications and 64-bit db2. This leads to memoryboundary    *
    * issues at run-time.See CRM 39121,344,000 for details.Cobol   *
    * progrma worked fine in old environment. Moving to db2v9.5    *
    * fp4 and recompiled and now failing.After running the old     *
    * module against the system it workedok.  After compiling the  *
    * new module with Micro Focus on oursystem32 they got the      *
    * following error.Below is the error they are getting when     *
    * running COBDB2.They  have run the MicroFocus debug utility   *
    * to determinethat the error is occurring on the call sqlgcrea *
    * statement../COBDB2 COLTEST,/data/db2/coltestCREATing         *
    * database ...please wait... this will take a while            *
    * ...Execution error : file 'COBDB2'error code: 114, pc=0,     *
    * call=1, seg=0114    Attempt to access item beyond bounds of  *
    * memory(Signal 11)                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.5 Fix Pack 6.                       *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 9.5 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ69055

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-29

  • Closed date

    2010-07-12

  • Last modified date

    2010-07-12

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

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

    IC68709 IC68710

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 July 2010