DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

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

First fixed in Version 9.7 Fix Pack 11.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

09.02.2015
12.10.2015
12.10.2015

9.7.FP11