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
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.