DB2 - Problem description
| Problem IT03526 | Status: Closed |
DB2 CRASHES WHEN FUNCTION LIO_LISTIO RECEIVES OS ERROR ENOTSUP IN SOLARIS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
DB2 crashes when function LIO_LISTIO receives OS error ENOTSUP
in Solaris
Example db2diag.log messages encountered:
2014-02-13-05.52.22.060783-480 E15998196A813 LEVEL: Error
(OS)
PID : 8736 TID : 3819 PROC : db2sysc
0
INSTANCE: inst NODE : 000
EDUID : 3819 EDUNAME: db2pclnr (ECMDBP) 0
FUNCTION: DB2 UDB, oper system services, sqloDispatchNBlocks,
probe:100
MESSAGE : ZRC=0x83000030=-2097151952
CALLED : OS, -, lio_listio
OSERR : ENOTSUP (48) "Operation not supported"
DATA #1 : signed integer, 8 bytes
5
DATA #2 : Hex integer, 4 bytes
0x00000002
DATA #3 : signed integer, 4 bytes
11
DATA #4 : unsigned integer, 8 bytes
3
DATA #5 : unsigned integer, 8 bytes
3
DATA #6 : unsigned integer, 4 bytes
2
DATA #7 : signed integer, 4 bytes
11
DATA #8 : unsigned integer, 8 bytes
32768
DATA #9 : unsigned integer, 8 bytes
192282624
DATA #10: signed integer, 8 bytes
0
......................
2014-02-13-05.52.22.311700-480 E16022786A840 LEVEL:
Critical
PID : 8736 TID : 3819 PROC : db2sysc
0
INSTANCE: inst NODE : 000
EDUID : 3819 EDUNAME: db2pclnr (ECMDBP) 0
FUNCTION: DB2 UDB, RAS/PD component, pdStartFODC, probe:10
MESSAGE : ADM14001C An unexpected and critical error has
occurred: "Panic".
The instance may have been shutdown as a result.
"Automatic" FODC
(First Occurrence Data Capture) has been invoked and
diagnostic
information has been recorded in directory
"/XXXX/FODC_Panic_2014-02-13-05.52.22
.311204_0000/". Please look in this directory for
detailed evidence
about what happened and contact IBM support if
necessary to diagnose
the problem. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2FORLUW * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 crashes when function LIO_LISTIO receives OS error * * ENOTSUP * * in Solaris * * * * Example db2diag.log messages encountered: * * * * 2014-02-13-05.52.22.060783-480 E15998196A813 LEVEL: * * Error * * (OS) * * PID : 8736 TID : 3819 PROC : * * db2sysc * * 0 * * INSTANCE: inst NODE : 000 * * EDUID : 3819 EDUNAME: db2pclnr (ECMDBP) 0 * * FUNCTION: DB2 UDB, oper system services, * * sqloDispatchNBlocks, * * probe:100 * * MESSAGE : ZRC=0x83000030=-2097151952 * * CALLED : OS, -, lio_listio * * OSERR : ENOTSUP (48) "Operation not supported" * * DATA #1 : signed integer, 8 bytes * * 5 * * DATA #2 : Hex integer, 4 bytes * * 0x00000002 * * DATA #3 : signed integer, 4 bytes * * 11 * * DATA #4 : unsigned integer, 8 bytes * * 3 * * DATA #5 : unsigned integer, 8 bytes * * 3 * * DATA #6 : unsigned integer, 4 bytes * * 2 * * DATA #7 : signed integer, 4 bytes * * 11 * * DATA #8 : unsigned integer, 8 bytes * * 32768 * * DATA #9 : unsigned integer, 8 bytes * * 192282624 * * DATA #10: signed integer, 8 bytes * * 0 * * * * ...................... * * * * 2014-02-13-05.52.22.311700-480 E16022786A840 LEVEL: * * Critical * * PID : 8736 TID : 3819 PROC : * * db2sysc * * 0 * * INSTANCE: inst NODE : 000 * * EDUID : 3819 EDUNAME: db2pclnr (ECMDBP) 0 * * FUNCTION: DB2 UDB, RAS/PD component, pdStartFODC, probe:10 * * MESSAGE : ADM14001C An unexpected and critical error has * * occurred: "Panic". * * The instance may have been shutdown as a result. * * "Automatic" FODC * * (First Occurrence Data Capture) has been invoked * * and * * diagnostic * * information has been recorded in directory * * "/XXXX/FODC_Panic_2014-02-13-05.52.22 * * .311204_0000/". Please look in this directory for * * detailed evidence * * about what happened and contact IBM support if * * necessary to diagnose * * the problem. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.7 fixpack 10 * **************************************************************** | |
| Local Fix: | |
Workaround is to disable Async IO using the following setting: db2set DB2LIOAIODISABLED=TRUE Please note this may affect performance | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.07.2014 24.11.2014 24.11.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.10 |
|