DB2 - Problembeschreibung
Problem IT27001 | Status: Geschlossen |
POSSIBLE TRAPS AND/OR EBADF (ERRNO 9) ERRORS WHEN USING UTL_MAIL.SEND() AND THE ROUTINES FAILS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
Db2 might crash with errors like the following in the db2diag.log, pointing to a possible Disk issue, although there is no relevant disk problem. FUNCTION: DB2 UDB, oper system services, sqloSystemErrorHandler, probe:10 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. CALLED : OS, -, fstat64 OSERR : EBADF (9) "Bad file number" The problem is due to calling UTL_MAIL.SEND() (not limited to just this routine) When such a routine fails it will attempt to close the 'file descriptor' to the SMTP server 3 times in a row instead of 1. If something else opened a file and got the same file descriptor in between then results can end up in trap or errors (EBADF - errno 9) for any system call dealing with a file descriptor. One way to check for this issue is to use traces: cat > trcmask | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.11.2018 16.01.2020 04.03.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |