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

DB2INSPECT FAILS WITH SQL1143N ERROR BECAUSE A FILE ERROR OCCURED, MISSING
FODC DIRECTORY.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Example: 
 
db2 "inspect check database indexdata results keep 
node44.inspectdb.out ON DBPARTITIONNUM (44)" 
SQL1143N  The operation cannot complete because a file error 
occurred for the file "node44.inspectdb.out". 
 
"FODC is in progress state" is not reset after data collection. 
Therefore utilities like INSPECT will not write to db2dump 
directory, but to an old FODC directory. If this FODC directory 
was previously deleted errors like SQL1143N can occur. This is 
the same scenario as described in 9.7 APAR IC74893 and IC87297. 
 
Following errors will be reported in the db2diag.log: 
 
2014-08-07-10.28.31.391058+000 I248060A490 LEVEL: Severe 
PID : 12845298 TID : 9289 PROC : db2sysc 44 
INSTANCE: db2xxxx NODE : 044 
EDUID : 9289 EDUNAME: db2pfchr (xxxxx) 44 
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSMapAndRead, 
probe:30 
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error 
occurred (DOS)" 
DIA8402C A disk error has occurred. 
DATA #1 : <preformatted> 
Converting to non-critical read error. 
 
2014-08-07-10.28.31.392201+000 E248551A852 LEVEL: Critical 
PID : 12845298 TID : 9289 PROC : db2sysc 44 
INSTANCE: db2xxxx NODE : 044 
EDUID : 9289 EDUNAME: db2pfchr (xxxxx) 44 
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSMapAndRead, 
probe:10 
MESSAGE : ADM14001C An unexpected and critical error has 
occurred: "BadPage". 
The instance may have been shutdown as a result. "Automatic" 
FODC 
(First Occurrence Data Capture) has been invoked and diagnostic 
information has been recorded in directory 
 
**** 
 
Following DB2 trace collection can be used to capture 
diagnostics on partition where db2inspect fails: 
 
db2 connect to <database>; 
db2trc on -m "*.*.DART.*.*"; 
db2 "INSPECT CHECK DATABASE RESULTS KEEP db2_inspect.log ON 
DBPARTITIONNUM (44)"; 
db2trc dmp trc.dmp; 
db2trc off; 
db2trc fmt -c trc.dmp trc.fmtc; 
db2trc fmt trc.dmp trc.fmt; 
db2trc flw -t -wc trc.dmp trc.flw; 
 
From the db2 trace collected above in trc.fmt file, it shows db2 
inspect is trying to create the output file here: 
/db2fs/db2edwp1/NODE0044/db2dump/FODC_BadPage_2014-08-07-10.28.3 
1.391243_0044
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2inspect fails with sql1143n error because a file error    * 
* occured, missing FODC directory.                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in version DB2 V10.1 FP5.                        * 
****************************************************************
Local-Fix:
N/A
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.08.2014
14.07.2015
14.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList