IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

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 (xxxxx) 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:                                              *
    * Db2 Version 11.5                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 Version 11.5.7.0                              *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Db2 Version 11.5.7.0
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT40916

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-05-12

  • Closed date

    2022-08-25

  • Last modified date

    2022-08-25

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

    IT31387

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
26 August 2022