SAP Knowledge Base Article - Preview

2533170 - DB6: Incremental online backup fails with SQL2048N

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.