home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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

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 FixList