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

ON DPF SQL1042C ERROR IS RETURNED FOR ANY TRANSACTION RUNNING AFTER
DIAGPATH HAS BEEN RENAMED AND BEFORE IT GETS RE-CREATED.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
All transactions running against a multipartitioned database get 
SQL1042C 
error after DIAGPATH is renamed and before it gets re-created. 
 
EX: 
 
1. Update DIAGPATH dbm cfg parameter: 
 
 
db2 -v update dbm cfg using diagpath '"/home/db2inst1/current 
$h$n"' 
 
 
2. Restart the instance for the changes to be in effect: 
 
db2stop force 
 
db2start 
 
 
 
3. List the paths that were created under 
/home/db2inst1/current to make sure they were updated: 
 
ls /home/anik/current/HOST_p6db2serv 
 
NODE0000  NODE0001  NODE0002 
 
 
4. Ran a simple select to make sure no sql1042c error is 
returned: 
 
db2 "select count(*) from employee" 
 
1 
----------- 
         42 
 
  1 record(s) selected. 
 
 
5. Then renamed the "current" directory: 
 
mv current current_old 
 
6.Right after this, i ran the same select above and got -1042 
error: 
 
SQL1042C  An unexpected system error occurred. 
 
With this APAR fix, SQL1042C will not be returned even if the 
diagpath is not available, thus it will not cause the running 
transactions to fail.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users using DB2 v95 fp8 and earlier                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ON DPF SQL1042C ERROR IS RETURNED FOR ANY TRANSACTION        * 
* RUNNING AFTER DIAGPATH HAS BEEN RENAMED AND BEFORE IT GETS   * 
* RE-CREATED.                                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v95 FP9                                       * 
****************************************************************
Local-Fix:
No Local Fix
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First Fixed in DB2 v95 FP9
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC76561 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.05.2011
13.03.2012
13.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList