home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT07041 Status: Closed

INCREMENTAL BACKUP MAY FAIL WITH SQL2048N

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem 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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL USING INCREMENTAL BACKUP                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 6                       * 
****************************************************************
Local Fix:
Solution
First fixed in DB2 Version 10.5 Fix Pack 6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.02.2015
28.08.2015
28.08.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.6 FixList
10.5.0.7 FixList