IBM Support

IC80746: DB2SUPPORT IS CALLING DB2DART /DDEL EVEN IF SOMEONE IS CONNECTING DATABASE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    

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
    

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

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80746

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-10

  • Closed date

    2012-06-05

  • Last modified date

    2012-12-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80746

Modified date: 03 December 2012