|
Problem IT05511
|
Status: Closed |
PD UDFS (PD_GET_DIAG_HIST, PD_GET_LOG_MSGS, OR PDLOGMSGS_LAST24HOURS ) MAY FAIL ON SQL0443N INTERMITTENTLY. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
PD UDFs (pd_get_diag_hist, pd_get_log_msgs, or
pdlogmsgs_last24hours ) may fail on SQL0443N intermittently.
E.g:
select
timestamp,pid,processname,appl_id,component,msgtype,msgseverity,
substr(msg,1,500) from sysibmadm.pdlogmsgs_last24hours where
timestamp >= (current timestamp - 12 hours) and msgseverity =
'C'
SQL0443N Routine "SYSPROC.PD_GET_LOG_MSGS" (specific name
"PD_GET_LOG_MSGS") has returned an error SQLSTATE with
diagnostic text "API cal". SQLSTATE=5U0ZZ SQL Code: -443; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* v10.5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* PD UDFs (pd_get_diag_hist, pd_get_log_msgs, or *
* pdlogmsgs_last24hours ) may fail on SQL0443N intermittently. *
* *
* E.g: *
* *
* select *
* timestamp,pid,processname,appl_id,component,msgtype,msgsever *
* ity, *
* substr(msg,1,500) from sysibmadm.pdlogmsgs_last24hours where *
* timestamp >= (current timestamp - 12 hours) and msgseverity *
* = *
* 'C' *
* SQL0443N Routine "SYSPROC.PD_GET_LOG_MSGS" (specific *
****************************************************************
* RECOMMENDATION: *
* apply fp5. *
**************************************************************** |
| Local Fix: |
Increase the available memory may help. E.g. Free some used
memory |
| Solution |
fixed in fp5. |
| Workaround |
Increase the available memory may help. E.g. Free some used
memory |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.11.2014
18.02.2015
18.02.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
