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. |
