DB2 - Problembeschreibung
Problem IC80746 | Status: Geschlossen |
DB2SUPPORT IS CALLING DB2DART /DDEL EVEN IF SOMEONE IS CONNECTING DATABASE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.01.2012 05.06.2012 03.12.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |