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

Many DB2 filesystems on single AIX volume group may be "Failed/S
tuck/Pending Offline" state after failover in shared-disk HA env

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
In using a shared disk configuration on AIX, with DB2 and TSA, 
if you have one volume group consisting of multiple file 
systems, after failover, some resource groups could be in a 
"Pending Offline" state. 
 
For Example, you have a VG called "db2vg1" with mulitple DB2 
filesystems, for logs, tablespaces etc, like the following: 
 
/db2/db2inst1 <-- DB2 instance home 
/db2/db2inst1/log_dir  <-- DB2 log directories 
/db2/db2inst1/temp1  <-- DB2 temporary space 
/db2/db2inst1/data1  <-- DB2 data space 
/db2/db2inst1/data2  <-- DB2 data space 
/db2/db2inst1/db2dump  <-- DB2 diagnostic data 
 
After a failover operation, the lssam output (shown below), may 
indicate several DB2 mount 
resources are in "Pending Offline", eventually reaching a Failed 
Offline" or "Stuck Online" state. 
 
------lssam output snippet------ 
**Pending offline** IBM.ResourceGroup:db2_db2inst1_0-rg 
Request=Lock 
Binding=Sacrificial Control=SuspendedPropagated Nominal=Online 
|- Offline IBM.Application:db2_db2inst1_0-rs Binding=Sacrificial 
Control=SuspendedPropagated 
  |- Offline IBM.Application:db2_db2inst1_0-rs:hostname01 
  '- Offline IBM.Application:db2_db2inst1_0-rs:hostname02 
>><< 
Binding=Sacrificial Control=SuspendedPropagated 
  |- Offline IBM.Application:db2inst1-db2_db2inst1-rs:hostname01 
  '- Online IBM.Application:db2inst1-db2_db2inst1-rs:hostname02 
|- **Pending offline** 
IBM.Application:db2inst1-db2inst1_log_dir-rs 
Binding=Sacrificial Control=SuspendedPropagated 
  |- Offline 
IBM.Application:db2inst1-db2inst1_log_dir-rs:hostname01 
  '- **Pending offline** 
IBM.Application:db2inst1-db2inst1_log_dir-rs:hostname02 
-------------------------------------
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 users on AIX platforms                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.5 FP10 or subsequent fix pack.              * 
****************************************************************
Local-Fix:
NA
Lösung
Problem First Fixed in DB2 Version 9.5 Fix Pack 10
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC82615 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.04.2012
19.02.2013
19.02.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP10
Problem behoben lt. FixList in der Version
9.5.0.10 FixList