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 IC87871 Status: Geschlossen

LASTUSED DAEMON, DB2LUSED PROCESS, MAY SHUT DOWN UNEXPECTEDLY WHEN THE
DATABASE IS QUIESCED.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
The LASTUSED daemon, db2lused process, that is used to update 
the LASTUSED field in certain system catalogs, 
such as syscat.tables, may shut down unexpectedly when a 
database is quiesced (either by QUIESCE DATABASE or 
QUIESCE INSTANCE) and then unquisced. 
 
The user would notice that the process is no longer around in 
the db2pd -edus output even 
though the database is active.  The following error would be 
noticed in the diag: 
 
 
2012-05-02-19.28.12.640875-240 I10151E594          LEVEL: Error 
PID     : 5262                 TID  : 46912954689856PROC : 
db2sysc 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-34                 APPID: *LOCAL.DB2.120502232733 
AUTHID  : db2inst1 
EDUID   : 49                   EDUNAME: db2lused (SAMPLE) 
FUNCTION: DB2 UDB, database monitor, sqmLastUsedDaemon::main, 
probe:20 
RETCODE : ZRC=0x870F00B9=-2029059911=SQLO_SEM_TIMEOUT 
          "Return code from sqlowait when time out value has 
been reached" 
DATA #1 : String, 31 bytes 
Last Used Daemon Shutting Down. 
 
eg. 
 
db2 quiesce db immediate 
 
followed by an 
 
db2 unquiesce db 
 
As the LASTUSED daemon wakes up every 15 mins to gather usage 
information, you may notice the problem 
approximately 15 mins after the database has been unquiesced and 
is active. 
 
db2pd -edus | grep lused 
 
command would show no db2lused process in the list.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP1 or subsequent fix pack.              * 
****************************************************************
Local-Fix:
Avoid quiescing and unquiescing the instance or database.
Lösung
Problem First Fixed in DB2 Version 10.1 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2012
10.12.2012
10.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version