DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* 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.                        * 
****************************************************************

N/A

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.08.2014
14.07.2015
14.07.2015