|
Problem IC80746
|
Status: Closed |
DB2SUPPORT IS CALLING DB2DART /DDEL EVEN IF SOMEONE IS CONNECTING DATABASE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If someone connected database, db2support takes long time due to
db2dart.
db2sampl
connect to sample
db2support . -d sample
db2support takes a long time in db2dart.
2011-12-21-2.35.41.950490 [db2supdbinfo.C:13102] START:
Collecting "DB2DART DDEL reports"
2011-12-21-2.35.41.953151 [db2supdbinfo.C:7999] START:
Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSTABLES)"
2011-12-21-2.39.33.971436 [db2supdbinfo.C:8188] STOP:
Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSTABLES)"
2011-12-21-2.39.33.972573 [db2supdbinfo.C:7999] START:
Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSINDEXES)"
2011-12-21-2.43.25.978843 [db2supdbinfo.C:8188] STOP:
Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSINDEXES)"
2011-12-21-2.43.25.979776 [db2supdbinfo.C:7999] START:
Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSDATAPARTITIONS)"
2011-12-21-2.47.18.111304 [db2supdbinfo.C:8188] STOP:
Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSDATAPARTITIONS)"
2011-12-21-2.47.18.111497 [db2supdbinfo.C:13261] STOP:
Collecting "DB2DART DDEL reports"
And db2diag.log was recorded as below.
2011-12-21-02.37.38.358751-300 E2279A1027 LEVEL: Error
(OS)
PID : 2228460 TID : 1 PROC : db2dart
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing
violation."
DIA8519C A file sharing violation has occurred,
filename was "".
CALLED : OS, -, open
OSERR : ETXTBSY (26) "Text file busy"
DATA #1 : Codepath, 8 bytes
4:11:15:16:22:36:37:63
DATA #2 : File name, 52 bytes
/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGCTL.LFH.1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* If someone connected database, db2support takes long time *
* due to *
* db2dart. *
* *
* db2sampl *
* connect to sample *
* db2support . -d sample *
* *
* db2support takes a long time in db2dart. *
* 2011-12-21-2.35.41.950490 [db2supdbinfo.C:13102] *
* START: *
* Collecting "DB2DART DDEL reports" *
* *
* 2011-12-21-2.35.41.953151 [db2supdbinfo.C:7999] *
* START: *
* Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSTABLES)" *
* 2011-12-21-2.39.33.971436 [db2supdbinfo.C:8188] *
* STOP: *
* Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSTABLES)" *
* *
* 2011-12-21-2.39.33.972573 [db2supdbinfo.C:7999] *
* START: *
* Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSINDEXES)" *
* 2011-12-21-2.43.25.978843 [db2supdbinfo.C:8188] *
* STOP: *
* Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSINDEXES)" *
* *
* 2011-12-21-2.43.25.979776 [db2supdbinfo.C:7999] *
* START: *
* Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSDATAPARTITIONS)" *
* 2011-12-21-2.47.18.111304 [db2supdbinfo.C:8188] *
* STOP: *
* Collecting "db2dart SAMPLE /DDEL (SYSIBM.SYSDATAPARTITIONS)" *
* 2011-12-21-2.47.18.111497 [db2supdbinfo.C:13261] *
* STOP: *
* Collecting "DB2DART DDEL reports" *
* *
* And db2diag.log was recorded as below. *
* 2011-12-21-02.37.38.358751-300 E2279A1027 LEVEL: *
* Error *
* (OS) *
* PID : 2228460 TID : 1 PROC : *
* db2dart *
* INSTANCE: db2inst1 NODE : 000 *
* EDUID : 1 *
* FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 *
* MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing *
* violation." *
* DIA8519C A file sharing violation has occurred, *
* filename was "". *
* CALLED : OS, -, open *
* OSERR : ETXTBSY (26) "Text file busy" *
* DATA #1 : Codepath, 8 bytes *
* 4:11:15:16:22:36:37:63 *
* DATA #2 : File name, 52 bytes *
* /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGCTL.LFH.1 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB version 9.7 fixpack 6. *
**************************************************************** |
| Local Fix: |
Deactivate database before execute db2support
or
Run db2support . -d <dbname> -st "values 1" -g -c
Then it exports catalog tables to ixf files, instead of running
db2dart /DDEL
You need to specify -F or -full option in db2support command
when you like to collect the other files except db2diag.log in
DIAGPATH directory along with optimizer collections like below.
db2support -d <dbname> -st "values 1" -F |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.01.2012
05.06.2012
03.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
