IBM Support

JR48442: Using server option DB2_REQUESTS_IO_BLOCK_BUF may cause a database forced shutdown when SELECT from NICKNAME

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Select nicknames caused ForceDBShutdown when  server option
    DB2_REQUESTS_IO_BLOCK_BUF is added.
    In db2trace ,we could see the following messages:
     2013-10-23-10.55.02.235018-420 I1112717E578          LEVEL:
    Severe
    PID     : 10812                TID : 47462697920832  PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    FEDDB
    APPHDL  : 0-108                APPID: *N0.db2inst1.131023175322
    AUTHID  : DB2INST1             HOSTNAME:
    xxxxxxx.xxxx.xxxxx
    EDUID   : 127                  EDUNAME: db2agent (TEST) 0
    FUNCTION: DB2 UDB, global services, sqlzeMapZrc, probe:45
    MESSAGE : ZRC=0x8604000B=-2046558197=SQLD_NOENT "OBJECT DOES
    NOT EXIST"
              DIA8412C A table "" could not be found.
    2013-10-23-10.55.02.274040-420 I1130772E882          LEVEL:
    Severe
    PID     : 10812                TID : 47462697920832  PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    FEDDB
    APPHDL  : 0-108                APPID: *N0.db2inst1.131023175322
    AUTHID  : DB2INST1             HOSTNAME:
    xxxxxxx.xxxx.xxxxx
    EDUID   : 127                  EDUNAME: db2agent (TEST) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -980   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQLRI096
     sqlerrd : (1) 0x8604000B      (2) 0x0000000B      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFE0C      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    The trap stack is:
    0        ossDumpStackTraceInternal
    1        ossDumpStackTraceV98
    2        OSSTrapFile::dumpEx
    3        sqlo_trce
    4        sqloDumpDiagInfoHandler
    5        __pthread_mutex_cond_lock
    6        pthread_kill
    7        ossPthreadKill
    8        sqloDumpEDU
    9        sqldDumpContext
    10       sqlrr_dump_ffdc
    11       sqlzeDumpFFDC
    12       sqlzeMapZrc
    13       sqlrrMapZrc
    14       sqlri_djx_rta
    15       sqlriSectInvoke
    16       sqlrr_process_fetch_request
    17       sqlrr_open
    18       sqljs_ddm_opnqry
    19       sqljsParseRdbAccessed
    20       sqljsParse
    21       sqluParseFiletmod
    22       sqluParseFiletmod
    23       sqlfGetEffectiveCAMemSize
    24       sqljsDrdaAsDriver
    25       sqeAgent::RunEDU
    26       sqzEDUObj::EDUDriver
    27       sqlzRunEDU
    28       sqloEDUEntry
    Repro steps:
    The reproduce depends on two factor,
    a) DB2_REQUESTS_IO_BLOCK_BUF is large enough,
    b) remote table's row size is small enough.
    1>. CREATE WRAPPER "MSSQLODBC3" LIBRARY 'libdb2mssql3.so'
    OPTIONS (DB2_FENCED  'Y' )
    2>. create server mssql type mssqlserver version 2008 wrapper
    MSSQLODBC3 options(DB2_REQUESTS_IO_BLOCK_BUF  '256', node
    '<nodename>', dbname '<dbname>')
    3> .create user mapping for <username> server mssql
    options(remote_authid '<username>', remote_password
    '<password>')
    4> .create nickname n1 for mssql."<schema>"."t697"
    5>.select  c1  from n1 fetch first rows only
    

Local fix

  • Drop the server option DB2_REQUESTS_IO_BLOCK_BUF can bypass
    this crash issue
    
    alter server <server-name> options (drop
    DB2_REQUESTS_IO_BLOCK_BUF)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v101fp4                                           *
    ****************************************************************
    

Problem conclusion

  • First fixed in v101fp3
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR48442

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-11

  • Closed date

    2014-06-17

  • Last modified date

    2014-06-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC97761

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPY","label":"General Issues"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2014