| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT37810 | Status: Closed |
REDUCE DB2DIAG.LOG MESSAGE "GET USER MAPPING" AND "SQLQG_FEDSTP_HOOK, PROBE:40 MESSAGE" | |
| product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
| Problem description: | |
Sometime, we can see lots of useless waring message "Get user
mapping options from the catalog failed." in db2diag.log
2021-07-26-23.25.59.675175-240 I1452175E782 LEVEL:
Warning
PID : 67615 TID : 140027761780480 PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
TESTDBU
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.210727032553
UOWID : 5 ACTID: 1
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 27 EDUNAME: db2agent (TESTDBU)
FUNCTION: DB2 UDB, Query Gateway, sqlqgGetUserInfo, probe:45
MESSAGE : ZRC=0x80040001=-2147221503=SQLD_NOREC "NO MORE RECORDS
FOUND ON FETCH"
DIA8000C An unexpected end of file was reached "".
DATA #1 : String, 49 bytes
Get user mapping options from the catalog failed.
DATA #2 : String, 6 bytes
DB2INST1
DATA #3 : String, 7 bytes
SERVER1
OR
2021-06-16-15.18.20.874080+480 I3894A463 LEVEL: Error
PID : 24772814 TID : 37523 PROC :
db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: MYHOST1
EDUID : 37523 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_fedstp_hook, probe:40
MESSAGE : Unexpected error returned from outer RC=
DATA #1 : Hexdump, 4 bytes
0x000000012A66CC20 : 8026 0160
.&.`
these messages can be ignored by customer side. so change above
message PD Level. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * no impact * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v11.1m4fp7 or v11.5.7 * **************************************************************** | |
| Local Fix: | |
N/A | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * no impact * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v11.1m4fp7 or v11.5.7 * **************************************************************** | |
| Comment | |
Db2 v11.4.7 and v11.5.7 contain this fix, now there will no more waring message "Get user mapping options from the catalog failed." in db2diag.log | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.07.2021 01.03.2022 03.04.2022 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
