home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT07041 Status: Geschlossen

INCREMENTAL BACKUP MAY FAIL WITH SQL2048N

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL USING INCREMENTAL BACKUP                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 6                       * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 Version 10.5 Fix Pack 6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.02.2015
28.08.2015
28.08.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.6 FixList
10.5.0.7 FixList