NetWorker: DB2 schedule backup failing with SQL2025N An I/O error occurred
Oversigt: DB2 schedule backup failing with Vendor error: rc = 25 returned from function sqluvput due DD to timeout
Denne artikel gælder for
Denne artikel gælder ikke for
Denne artikel er ikke knyttet til et bestemt produkt.
Det er ikke alle produktversioner, der er identificeret i denne artikel.
Symptomer
NetWorker Module for Databases and Applications (NMDA) backup of DB2 databases are impacted:
HH/MM/YY HH:MM:SS (pid 54460472): HH/MM/YY HH:MM:SS nw_ddcl_fsync: dfd=2998496 HH/MM/YY HH:MM:SS (pid 54460472): HH/MM/YY HH:MM:SS DDP LOG: [33F0038:110CB3210] ddcl_ddcp_commit(): Commit forcing close of ddcp file //MTREE/DEVICE_FOLDER/active/LONG-SSID on hostname DD_NAME; pid=54460472 HH/MM/YY HH:MM:SS (pid 54460472): HH/MM/YY HH:MM:SS DDP LOG: [33F0038:110CB3210] ddcl_ddcp_close(): Closing File //MTREE/DEVICE_FOLDER/active/LONG-SSID via ddcp on hostname DD_NAME, pid is 54460472 HH/MM/YY HH:MM:SS (pid 54460472): HH/MM/YY HH:MM:SS DDP LOG: [33F0038:110CB3210] ddp_fsync() failed, Err: 5057-File handle is stale HH/MM/YY HH:MM:SS (pid 54460472): HH/MM/YY HH:MM:SS fsys_fsync(): Sync'ing a file failed [5057] ([54460472] [1] DAY MONTH DD HH:mm:SS YYYY ddp_fsync() failed, Err: 5057-File handle is stale
Db2diag.log shows similar messaging.
YYYY-MM-DD-HH.mm.SS I179696A735 LEVEL: Error PID : 30277794 TID : 61164 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 61164 EDUNAME: db2med.55250.0 (EDWPROD) 0 FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:655 DATA #1 : String, 120 bytes Vendor error: rc = 25 returned from function sqluvput. Return_code structure from vendor library /usr/lib/libnsrdb2.o: YYYY-MM-DD-HH.mm.SS E180432A384 LEVEL: Error PID : 30277794 TID : 61164 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 61164 EDUNAME: db2med.55250.0 (EDWPROD) 0 FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:995 MESSAGE : Media controller -- problem writing to vendor device. rc = -2025 YYYY-MM-DD-HH.mm.SS E180817A420 LEVEL: Error PID : 30277794 TID : 61164 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 61164 EDUNAME: db2med.55250.0 (EDWPROD) 0 FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:995 MESSAGE : SQL2025N An I/O error occurred. Error code: "". Media on which this error occurred: "".
Årsag
The Issue is due to large backup window which runs more than 3 hours causing a data domain default timeout.
DB2 backup file was opened, but not written to in 3 hours (10,800 seconds). The file was abandoned and deleted by Data Domain File System as per OST_ABANDON_TIMEOUT design.
Løsning
A Data Domain support request is required. The OST_ABANDON_TIMEOUT system parameter can be adjusted on the Data Domain to allow more time for these large backups to complete. This change requires bash mode access on the data domain. It is not recommended to access bash mode without DD support.
Berørte produkter
Data Domain, NetWorker Module for Databases and ApplicationsProdukter
NetWorker Family, NetWorker, NetWorker ModuleArtikelegenskaber
Artikelnummer: 000067659
Artikeltype: Solution
Senest ændret: 21 apr. 2026
Version: 5
Find svar på dine spørgsmål fra andre Dell-brugere
Supportservices
Kontrollér, om din enhed er dækket af supportservices.