IBM Support

IT31387: WHEN DB2_TWO_PHASE_COMMIT=Y AND READONLY=TRUE ON FEDERATION, GETFODC_FORCEDBSHUTDOWN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When setting DB2_TWO_PHASE_COMMIT=Y and readOnly=true on
    Federation
    environment, JDBC/JCC connecting query can not be run.
    
    The associated SQLP_APP_READ_ONLY and FODC_ForceDBShutdown
    errors
    can be found at db2diag.log as below:
    ---
    2019-11-19-11.53.55.384145+540 I17632602A885        LEVEL: Error
    PID     : 14483848             TID : 67955          PROC :
    db2sysc 2
    INSTANCE: xxxxxxx              NODE : 002           DB   : xxxxx
    APPHDL  : 2-56035              APPID:
    xx.xxx.xxx.62.53576.191119025348
    AUTHID  : xxxxxxx              HOSTNAME: xxxxxxxxxx
    EDUID   : 67955                EDUNAME: db2agent (xxxxx) 2
    FUNCTION: DB2 UDB, data protection services,
    SQLP_TENTRY::sqlpReserveLogSpace, probe:910
    MESSAGE : ZRC=0x80100149=-2146434743=SQLP_APP_READ_ONLY
              "Read only application trying to write log record"
    DATA #1 : String, 56 bytes
    TID / myTidhdl / sharedLogSpace / totalReservedLogSpace:
    DATA #2 : SQLP_TID8, PD_TYPE_SQLP_TID8, 8 bytes
    00000000035D7DBA
    DATA #3 : Transaction ID handle, PD_TYPE_SQLP_TIDHDL, 4 bytes
    137 (User)
    DATA #4 : unsigned integer, 8 bytes
    0
    DATA #5 : unsigned integer, 8 bytes
    0
    
       --- snip ---
    
    2019-11-19-11.53.56.184558+540 E17679877A837        LEVEL: Error
    PID     : 14483848             TID : 67955          PROC :
    db2sysc 2
    INSTANCE: xxxxxxx              NODE : 002           DB   : xxxxx
    APPHDL  : 2-56035              APPID:
    xx.xxx.xxx.62.53576.191119025348
    AUTHID  : xxxxxxx              HOSTNAME: xxxxxxxxxx
    EDUID   : 67955                EDUNAME: db2agent (URADB) 2
    FUNCTION: DB2 UDB, base sys utilities,
    sqleDoForceDBShutdownFODC, probe:30
    MESSAGE : ADM14005E  The following error occurred:
    "ForceDBShutdown".  First
              Occurrence Data Capture (FODC) has been invoked in the
    following
              mode: "Automatic".  Diagnostic information has been
    recorded in the
              directory named
    
    "/xxxxxx/xxx/db2dump/DIAG0002/FODC_ForceDBShutdown_2019-11-19-11
    .53.5
              6.183996_14483848_67955_002/".
    ---
    

Local fix

  • Configure DB2_TWO_PHASE_COMMIT=N or readOnly=false
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * WHEN DB2_TWO_PHASE_COMMIT=Y AND READONLY=TRUE ON FEDERATION, *
    * GET                                                          *
    * FODC_FORCEDBSHUTDOWN                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW version 11.1.4.6 or later.                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT31387

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-26

  • Closed date

    2021-03-29

  • Last modified date

    2021-03-29

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

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

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
31 March 2021