SAP Knowledge Base Article - Preview

2944421 - DB2 backup failing with SQL2048N error

Symptom

Online/Offline backup results in the following errors occurring in db2diag.log:

LEVEL: Severe
PID : 0000 TID : 123456789 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-00000 APPID: *LOCAL.db2sid.0000000
AUTHID : DB2SID HOSTNAME: hostname
EDUID : 000 EDUNAME: db2bm.111.1(SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:382
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 : sqlubRea
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:

LEVEL: Error

EDUID : 00 EDUNAME: db2pfchr (DX2) 0
FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : Codepath, 8 bytes

DATA #2 : String, 17 bytes
End of file hit !

Error during direct Read V

DATA #5 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 331
File System Block Size = 4096 bytes
File System Type = xfs
Storage Sector Size = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = Yes
File Not Tracked = Yes
Remote Storage Read = No
Remote Storage Write = No
Extended File Handle = No
Use Local, No Delete = No


Read more...

Environment

Db2 Linux Unix and Windows 11.1.4.4

Product

SAP NetWeaver 7.5

Keywords

ADM6006E, RHEL, SLES, db2set DB2_USE_FAST_PREALLOCATION=OFF , 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.