|
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) |
