|
Problem IT18263
|
Status: Closed |
SOME DUMP FILES ARE GENERATED DURING ROLLFORWARD OR CRASH RECOVERY EVEN IT RUNS SUCCESSFULLY WITH NO ERRORS.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Even when crash recovery is successful with no errors, dump
files named BPS*.events.bin are generated in DIAGPATH. Users
can delete these files if the rollforward runs successfully.
Here is the repro step in 11.1GA:
$ db2 create db sample on $PWD
$ cd $USER/NODE0000/
$ db2 connect to sample
$ db2 "create table t1(i int)" ; db2 +c insert into t1 values
1,2,3,4,5
$ db2 set write suspend for database
$ tar cf sample.tar SQL00001/ SAMPLE/
$ db2 set write resume for database
$ db2 terminate
$ mv SQL00001 SQL00001.org ; mv SAMPLE SAMPLE.org
$ tar xf sample.tar
$ ls -lFrt ?/sqllib/db2dump/ | tail -4
-rw-r----- 1 db2inst1 db2users 6291316 Mar 15 11:39
db2eventlog.000
-rw-rw-rw- 1 db2inst1 db2users 91678 Mar 15 11:45
db2diag.log_2016-03-15-11.45.33
-rw-rw-rw- 1 db2inst1 db2users 10651 Mar 15 18:40
db2inst1.nfy
-rw-rw-rw- 1 db2inst1 db2users 254156 Mar 15 18:40
db2diag.log
$ date; db2inidb sample as snapshot
Tue Mar 15 18:41:31 JST 2016
DBT1000I The tool completed successfully.
$ ls -lFrt ?/sqllib/db2dump/ | tail -5
-rw-r----- 1 db2inst1 db2users 1048696 Mar 15 18:41
SAMPLE.20160315184157.000.SQLB.BPSMed.events.bin
-rw-r----- 1 db2inst1 db2users 1048696 Mar 15 18:41
SAMPLE.20160315184157.000.SQLB.BPSLow.events.bin
-rw-r----- 1 db2inst1 db2users 8388728 Mar 15 18:41
SAMPLE.20160315184157.000.SQLB.BPSHi.events.bin
-rw-rw-rw- 1 db2inst1 db2users 282606 Mar 15 18:41
db2diag.log |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1 Fix Pack 1. *
**************************************************************** |
| Local Fix: |
Delete the files manually. |
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : IT14328
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.12.2016
20.12.2016
20.12.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
