DB2 - Problem description
Problem IT35857 | Status: Closed |
NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
db2 "SELECT * FROM SYSIBMADM.PDLOGMSGS_LAST24HOURS" or db2 "SELECT COUNT(*) FROM TABLE (SYSPROC.PD_GET_LOG_MSGS( CURRENT_TIMESTAMP - 1 DAYS)) AS T" returned 0 record . db2diag.log : 2021-02-09-01.33.44.426000-480 I2264F676 LEVEL: Info PID : 3800 TID : 2552 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-21 APPID: *LOCAL.DB2.210209093217 UOWID : 2 ACTID: 1 AUTHID : ADMINISTRATOR HOSTNAME: sevenths1 EDUID : 2552 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, WLM, sqlrwGetPDLogMsgs, probe:10 MESSAGE : Memory floor and ceiling computed using: DATA #1 : signed integer, 8 bytes 59134566 DATA #2 : signed integer, 8 bytes 59134566 DATA #3 : signed integer, 8 bytes 90708680 2021-02-09-01.33.44.520000-480 E2942F596 LEVEL: Info PID : 3800 TID : 2552 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-21 APPID: *LOCAL.DB2.210209093217 UOWID : 2 ACTID: 1 AUTHID : ADMINISTRATOR HOSTNAME: sevenths1 EDUID : 2552 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, runtime interpreter, sqlriUFOBCacheRelease, probe:1100 DATA #1 : UFOBResultCache Statistics SYSPROC.PD_GET_LOG_MSGS: undef db2 "select FUNCSCHEMA, SPECIFICNAME, FUNCNAME from syscat.FUNCTIONS where SPECIFICNAME='PD_GET_LOG_MSGS'" |pg FUNCSCHEMA SPECIFICNAME FUNCNAME ---------- ------------------- ------------------- SYSPROC PD_GET_LOG_MSGS PD_GET_LOG_MSGS | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.02.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) |