home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT05511 Status: Geschlossen

PD UDFS (PD_GET_DIAG_HIST, PD_GET_LOG_MSGS, OR PDLOGMSGS_LAST24HOURS ) MAY
FAIL ON SQL0443N INTERMITTENTLY.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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
Lösung
fixed in fp5.
Workaround
Increase the available memory may help. E.g. Free some used 
memory
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.11.2014
18.02.2015
18.02.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList