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.
SAP Knowledge Base Article - Preview