DB2 - Problem description
Problem IT36454 | Status: Closed |
SQL0901N | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
After migrating to DB2 v11.5, DB2 might receive errors like this: 2021-03-29-01.07.30.756190-420 I2317619E559 LEVEL: Severe PID : 1298 TID : 140541102647040 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : XYZ APPHDL : 0-250 APPID: *LOCAL.zzzzzzzzzzzzzzzzz UOWID : 5 ACTID: 1 AUTHID : XYZABC HOSTNAME: hostname EDUID : 26 EDUNAME: db2agent (XYZ) 0 FUNCTION: DB2 UDB, catcache support, sqlrlc_fed_fetch_3pn_pd, probe:528 MESSAGE : invalid federated three part name The problem is likely to occur when a CREATE SERVER name is the same as a SCHEMA name in the database. This can also create many FODC_AppErr folders, filling up the DIAGPATH on the database server. In some cases this can cause DB2 to crash as well. The db2diag.log may show the db2wdog process crashing with a signal 11 like this: 2021-03-31-10.50.48.761389-420 E22948E473 LEVEL: Error PID : 20696 TID : 139937609410304 PROC : db2wdog 0 [XYZ] INSTANCE: db2inst1 NODE : 000 HOSTNAME: hostname EDUID : 2 EDUNAME: db2wdog 0 [XYZ] FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:10594 DATA #1 : Process ID, 4 bytes 20698 DATA #2 : Hexdump, 8 bytes 0x00007F45C37FB3B8 : 0101 0000 0B00 0000 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * After migrating from v10.5.9 to v11.5.5 customer is getting * * many FODC_AppErr folders generated with -901 exceptions. * * MESSAGE : invalid federated three part name * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v11.5.6 * **************************************************************** | |
Local Fix: | |
Change the CREATE SERVER name to something different than any SCHEMA name in the database. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * After migrating from v10.5.9 to v11.5.5 customer is getting * * many FODC_AppErr folders generated with -901 exceptions. * * MESSAGE : invalid federated three part name * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v11.5.6 * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.04.2021 16.06.2021 16.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |