Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList