IBM Support

IT28801: BACKUP WITH AIX COMPRESSION NX842 RETURN SQL2079 GETMAXCOMPRESSEDSIZE PROMISED THAT THIS BUFFER WOULD BE BIG ENOUGH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using NX842 on AIX either during log archive compression or
    during backup compression either by specifying the compression
    library libdb2nx842.a or through the registry variable
    DB2_BCKP_COMPRESSION=NX842 SQL error -2079 can be returned and
    the backup fails with the following message:
    
    2019-03-24-21.45.34.212841+060 E9253174A650         LEVEL: Error
    PID     : 8389064              TID : 15632          PROC :
    db2sysc 1
    INSTANCE: db2inst1          NODE : 001           DB   :
    MYDB
    APPHDL  : 1-13167              APPID: *N1.db2inst1.190324204533
    AUTHID  : DB2INST1             HOSTNAME: HOST1
    EDUID   : 15632                EDUNAME: db2bm.17516.0 (MYDB)
    1
    FUNCTION: DB2 UDB, database utilities,
    sqlubManageCompressedObject, probe:1434
    DATA #1 : String, 86 bytes
    GetMaxCompressedSize promised that this buffer would be big
    enough.
    srcSize / tgtSize:
    DATA #2 : signed integer, 4 bytes
    17
    DATA #3 : signed integer, 4 bytes
    20
    
    2019-03-24-21.45.34.213683+060 E9253825A693         LEVEL:
    Severe
    PID     : 8389064              TID : 15632          PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001           DB   :
    MYDB
    APPHDL  : 1-13167              APPID: *N1.db2inst1.190324204533
    AUTHID  : DB2INST1              HOSTNAME: HOSTX
    EDUID   : 15632                EDUNAME: db2bm.17516.0 (MYDB)
    1
    FUNCTION: DB2 UDB, database utilities,
    sqlubManageCompressedObject, probe:1440
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -2079
    DATA #2 : Hexdump, 22 bytes
    0x0000000113102A18 : FFFF F7E1 6C69 6264 6232 6E78 3834 322E
    ....libdb2nx842.
    0x0000000113102A28 : 6100 0000 0001
    a.....
    
    2019-03-24-21.45.34.214146+060 E9254519A995         LEVEL:
    Severe
    PID     : 8389064              TID : 15632          PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001           DB   :
    MYDB
    APPHDL  : 1-13167              APPID: *N1.db2inst1.190324204533
    AUTHID  : DB2INST1             HOSTNAME: HOSTX
    EDUID   : 15632                EDUNAME: db2bm.17516.0 (MYDB)
    1
    FUNCTION: DB2 UDB, database utilities,
    sqlubManageCompressedObject, probe:1440
    MESSAGE : SQL2079N  An error was reported by the shared library
    "".  Return
              code: "".
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2079   sqlerrml: 15
    sqlerrmc: libdb2nx842.a 1
    sqlerrp : sqlubMan
    sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000001
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or later                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28801

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-04-15

  • Closed date

    2019-10-31

  • Last modified date

    2021-01-12

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

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

    IT30804

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
13 January 2021