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

IN HADR, AFTER TAKEOVER AND TAKEBACK, ATS TASKS ON PRIMARY GET ERRORS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In HADR, calling original primary A and original standby B. 
 
Start HADR at A and B. 
Machine B: 
db2 start hadr on database <dbname> as standby 
 
Machine A: 
db2 start hadr on database <dbname> as primary 
 
After sometime B takeovers and B becomes primary 
 machine B: 
db2 "takeover hadr on db solar" 
 
 
Now if A takes back and becomes primary again 
machine A: 
db2 "takeover hadr on db solar" 
 
You will see messages like below in db2diag.log and tasks will 
not be run 
 
 
2011-04-04-06.20.00.329816-240 I47959E332          LEVEL: Event 
PID     : 26779                TID  : 1124096320   PROC : db2acd 
INSTANCE: lappanna             NODE : 000 
FUNCTION: DB2 UDB, Administrative Task Scheduler, 
AtsDaemon::run, probe:800 
DISPATCH: Dispatch execution thread - Database: SOLAR    Task: 
TASK204 (Task ID: 1) 
 
2011-04-04-06.20.00.339311-240 E48292E564          LEVEL: Event 
PID     : 26779                TID  : 1132489024   PROC : db2acd 
INSTANCE: lappanna             NODE : 000 
APPID   : *LOCAL.lappanna.110404102000 
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, 
probe:1550 
MESSAGE : ECF=0x82BA0001=-2101739519 
REPORT  : Task not ready to run - Task ID: 1 
          Task Name      : TASK204 
          Database       : SOLAR 
          Current Time   : 2011-04-04 10:20:00.339292000 (UTC) 
          Next Execution : 2011-04-04 10:30:00.000000000 (UTC)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of Administrative task scheduler in HADR environment   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Please see error Description                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW  V97FP5                                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem first fixed in DB2 LUW V97FP5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.08.2011
07.12.2011
07.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList