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 |
