IBM Support

IT07042: INCREMENTAL BACKUP MAY FAIL WITH SQL2048N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Incremental backup with compression may fail with SQL02048N. In
    db2diag.log you
    may see errors like below:
    
    2014-08-20-05.10.46.150782-300 E33532A679 LEVEL: Severe
    PID : 20644052 TID : 14414 PROC : db2sysc 0
    INSTANCE: xyz NODE : 000 DB : QPC
    APPHDL : 0-3775 APPID: *LOCAL.db2qpc.140820101039
    AUTHID : xyzC HOSTNAME: xyz
    EDUID : 14414 EDUNAME: db2bm.24471.0 (QPC) 0
    FUNCTION: DB2 UDB, database utilities, sqlubGetBufSpace,
    probe:453
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -2048
    DATA #2 : Hexdump, 28 bytes
    0x0000000115C0EA18 : FFFF F800 444D 532E 5441 424C 4553 5041
    ....DMS.TABLESPA
    0x0000000115C0EA28 : 4345 2E44 4154 4100 0000 0005
    CE.DATA.....
    
    2014-08-20-05.10.46.151312-300 E34212A978 LEVEL: Severe
    PID : 20644052 TID : 14414 PROC : db2sysc 0
    INSTANCE: xyz NODE : 000 DB : QPC
    APPHDL : 0-3775 APPID: *LOCAL.db2qpc.140820101039
    AUTHID : xyz HOSTNAME: xyz
    EDUID : 14414 EDUNAME: db2bm.24471.0 (QPC) 0
    FUNCTION: DB2 UDB, database utilities, sqlubGetBufSpace,
    probe:453
    MESSAGE : SQL2048N An error occurred while accessing object "".
    Reason code:
              "".
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 21
     sqlerrmc: DMS.TABLESPACE.DATA 5
     sqlerrp : sqlubGet
     sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
               (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
     sqlwarn : (1) (2) (3) (4) (5) (6)
               (7) (8) (9) (10) (11)
     sqlstate:
    -----------------
    
    In trace, you could see buffer size is shown way high than
    actual allocated buffer size for backup operation.
    
    For eg:
    
    From db2diag.log:
    
    2014-08-29-13.25.50.415614-300 E542514A534 LEVEL: Info
    PID : 8323154 TID : 25450 PROC : db2sysc 0
    INSTANCE: db2qpc NODE : 000 DB : QPC
    APPHDL : 0-2379 APPID: *LOCAL.db2qpc.140829182550
    AUTHID : DB2QPC HOSTNAME: adxsap371
    EDUID : 25450 EDUNAME: db2agent (QPC) 0
    FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers,
    probe:903
    DATA #1 : <preformatted>
    Autonomic backup - tuning enabled.
    Using buffer size = 2057, number = 8.
    
    From trace:
    
    468006   exit DB2 UDB database utilities sqlubQueryBufSpace fnc
    (2.3.21.1105.0)
       pid 27131912 tid 16202 cpid 7209210 node 0 sec 34 nsec
    582305312
       rc = 0
       bytes 12
    
       Data1    (PD_TYPE_UINT,4) unsigned integer:
       41834946
    
    --
    
    Trace is showing 41MB of buffer is free while actual allocated
    buffer size is 2057*4096=8425472 bytes.
    
    Offline backup, online full backup works fine.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 11 or higher.            *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07042

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-02-09

  • Closed date

    2015-10-12

  • Last modified date

    2015-10-12

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

    IT06984

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT07042

Modified date: 12 October 2015