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

Search for additional results

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