files under db2dump

[Kamlesh]

Hello,

Under the /home/db2inst1/sqllib/db2dump folder, I have lot of files
created. Below is a snapshot of the contents:

-rw-rw-rw- 1 db2inst1 db2grp1 3583 Nov 03 2004 a86516.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a88738.000
-rw-rw-rw- 1 db2inst1 db2grp1 3071 Nov 05 2004 a91404.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a93490.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a93942.000
-rw-rw-rw- 1 db2inst1 db2grp1 35616005 Jun 14 18:17 db2diag.log
-rw-r--r-- 1 db2inst1 db2grp1 29935110 Dec 02 2004 db2diag1.log
-rw-r----- 1 db2inst1 db2grp1 5242044 Dec 31 09:35 db2eventlog.000
-rw-r----- 1 db2inst1 db2grp1 5242044 Apr 16 07:03 db2eventlog.000.c
-rw-rw-rw- 1 db2inst1 db2grp1 38309113 Jun 14 18:13 db2inst1.nfy
-rw-rw-rw- 1 db2inst1 db2grp1 0 May 11 14:39 g133628.000
-rw-rw-rw- 1 db2inst1 db2grp1 0 May 11 14:36 g143942.000
Some of the filenames starting with name "db2*.*" are taking lot of
space. What is the significance of these files?

Is it safe to delete these files, especially "db2*log*.*".

Regards,
Kamlesh

[shenanwei]

Just delete them.
If you do have some problem, those file is good for diagnose them.

Kamlesh wrote:

Hello,

Under the /home/db2inst1/sqllib/db2dump folder, I have lot of files
created. Below is a snapshot of the contents:

-rw-rw-rw- 1 db2inst1 db2grp1 3583 Nov 03 2004 a86516.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a88738.000
-rw-rw-rw- 1 db2inst1 db2grp1 3071 Nov 05 2004 a91404.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a93490.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a93942.000
-rw-rw-rw- 1 db2inst1 db2grp1 35616005 Jun 14 18:17 db2diag.log
-rw-r--r-- 1 db2inst1 db2grp1 29935110 Dec 02 2004 db2diag1.log
-rw-r----- 1 db2inst1 db2grp1 5242044 Dec 31 09:35 db2eventlog.000
-rw-r----- 1 db2inst1 db2grp1 5242044 Apr 16 07:03 db2eventlog.000.c
-rw-rw-rw- 1 db2inst1 db2grp1 38309113 Jun 14 18:13 db2inst1.nfy
-rw-rw-rw- 1 db2inst1 db2grp1 0 May 11 14:39 g133628.000
-rw-rw-rw- 1 db2inst1 db2grp1 0 May 11 14:36 g143942.000
Some of the filenames starting with name "db2*.*" are taking lot of
space. What is the significance of these files?

Is it safe to delete these files, especially "db2*log*.*".

Regards,
Kamlesh

[Serge Rielau]

Kamlesh wrote:

Hello,

Under the /home/db2inst1/sqllib/db2dump folder, I have lot of files
created. Below is a snapshot of the contents:

-rw-rw-rw- 1 db2inst1 db2grp1 3583 Nov 03 2004 a86516.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a88738.000
-rw-rw-rw- 1 db2inst1 db2grp1 3071 Nov 05 2004 a91404.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a93490.000
-rw-rw-rw- 1 db2inst1 db2grp1 3583 Oct 29 2004 a93942.000
-rw-rw-rw- 1 db2inst1 db2grp1 35616005 Jun 14 18:17 db2diag.log
-rw-r--r-- 1 db2inst1 db2grp1 29935110 Dec 02 2004 db2diag1.log
-rw-r----- 1 db2inst1 db2grp1 5242044 Dec 31 09:35 db2eventlog.000
-rw-r----- 1 db2inst1 db2grp1 5242044 Apr 16 07:03 db2eventlog.000.c
-rw-rw-rw- 1 db2inst1 db2grp1 38309113 Jun 14 18:13 db2inst1.nfy
-rw-rw-rw- 1 db2inst1 db2grp1 0 May 11 14:39 g133628.000
-rw-rw-rw- 1 db2inst1 db2grp1 0 May 11 14:36 g143942.000
Some of the filenames starting with name "db2*.*" are taking lot of
space. What is the significance of these files?

The db2diag log holds information that can be interesting for problem
determination.
The event log contains information of interest for administration.
I'm not familiar with the nfy (Notify?) log.
Either way many customers arhcive tese files away.
For eaxmple they run a cron job which simple renames each of the files
(it apears someone did this with some of your files already) every 24
hours by adding a timestamp.
Then the file can archived away and eventually just be wiped
(maybe after a week or so, whichever you feel comfortable with).
DB2 will automagically recreate new files after the rename.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab