home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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