Symptom
- When attempting to perform an incremental online backup, the backup fails with the following error:
2017-01-01-00.00.00.000000-360 E84060782A979 LEVEL: Severe
PID : 1234 TID : 56789 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL :000000 APPID: *LOCAL.db2sid.000000000000
AUTHID : DB2SID HOSTNAME: saphost
EDUID : 00000 EDUNAME: db2bm (SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubGetBufSpace, probe:495
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:
- Offline backup and full online backup both complete successfully
- Incremental backup can fail with
Backup_Dev: SQL Message: SQL2048N An error occurred while accessing object "DMS.TABLESPACE.DATA". Reason code: "5
Read more...
Environment
Db2 Luw 9.7FP11
Db2 Luw 10.1FP4
Db2 Luw 10.5FP5
Keywords
SQL2048N, -2048, incremental online backup, DMS.TABLESPACE.DATA , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview