DB2 FOR LUW / DB2FORLUW / B10 - DB2

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

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.11.2018
16.01.2020
04.03.2020