2533170 - DB6: Incremental online backup fails with SQL2048N | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.