DB2 - Problem description
Problem IT37587 | Status: Closed |
DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 LUW Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 LUW Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.07.2021 22.11.2021 22.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |