IBM Support

IC66316: DB2 EXPORT CREATES EXCESSIVE LOCKING ON CATALOG TABLES.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Multiple locks on SYSDEPENDECIES and SYSSEQUENCES for rows that
    are not related to the table that is being exported. The problem
    occurs only when the select part of the statement uses the wild
    
    card *:
    
    db2 export to <FILE> of ixf messages <MSG FILE> select * from
    <source schema>.<source_table>
    
    The query that is executed againtst the catalog tables with the
    isolation level that the package has been bound. In this case
    RS.
    
    The problem can be avoided if it is exported to DEL or ASC. Also
    if the list of columns is provided in the export statament.
    

Local fix

  • 1. Use export to DEL or ASC
    2. List the name of the columns for export. Avoid using *.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * db2 export causes excessive locking. Other                   *
    * applicationswilltimeout generally waiting for SYSDEPENCIES   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Migrate to v95fp6Avoid using 'select *" in the               *
    * exportcommand. Provide listof columns instead.               *
    ****************************************************************
    

Problem conclusion

  • fixed in v95fp6
    

Temporary fix

Comments

  • FIN
    

APAR Information

  • APAR number

    IC66316

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-15

  • Closed date

    2010-06-22

  • Last modified date

    2010-06-22

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

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

    IC66531 IC66532

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 June 2010