IBM Support

IT39053: DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When MSSQL abnormally shuts down during load activity from Db2
    fedearation client, corresponding federated client application
    was not terminated/completed itself.
    
    When tried to force off using db2 "force
    application(app_handle)"
    It doesn't succeed and still listing in snapshot or in db2 list
    utilities output
    
    For example:
    
    
    db2 "force application(48428)"
    DB20000I  The FORCE APPLICATION command completed successfully.
    DB21024I  This command is asynchronous and may not be effective
    
    db2 list application |grep 48428
    DSUSER   db2bp          48428
    ***.**.**.**.*****.210629152127
    As per application snapshot , it is waiting for input from
    federated source
    ```
    Application handle                         = 48428
    Application ID                             =
    **.**.**.35.*****.210629152127
    Sequence number                            = 00004
    Application name                           = db2bp
    CONNECT Authorization ID                   = TESTUSER
    Application status                         = Federated request
    pending
    Status change time                         = 06/29/2021
    23:16:19.771470
    Application code page                      = 819
    Locks held                                 = 7
    Total wait time (ms)                       = 0
    
    
    db2 list utilities
    ID                               = 6248
    Type                             = LOAD
    Database Name                    = TESTDB
    Member Number                    = 0
    Description                      = [LOADID:
    102879.2021-06-29-22.21.27.497712.0 (36;12)]
    [***.**.153.35.*****.210629152127] OFFLINE LOAD CURSOR AUTOMATIC
    INDEXING REPLACE NON-RECOVERABLE CISOPEN .ADR
    Start Time                       = 06/29/2021 22:21:27.505907
    State                            = Executing
    Invocation Type                  = User
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 LUW Users                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39053

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-11-12

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

    IT37589

  • 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

  • RB10 PSY

       UP

[{"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.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022