IBM Support

PI54060: [369434] IN DNG THE QUERY PERFORMANCE BECOMES SLOW WHEN USING SQL SERVER FOR A DB.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When there are a large number of VVCMODEL.VERSION records,
    queries may be slow.
    
    When using SQL Server and you find that the performance in IBM
    Rational Doors Next Generation is becoming slow and you start
    getting regular time-out messages, you can confirm if you are
    hit by this problem by letting your SQL Server DBA checking if
    one or both of the following 2 queries are running many times
    per minute:
    
    select distinct t1.CONCEPT from VVCMODEL.VERSION t1 where
    (t1.STORAGE=@P0)
    
    and / or
    
    select distinct
    t1.CONFIGURATION_ITEM_ID,t1.STORAGE,t1.VERSION,t1.CURRENT_COL.t1
    .CREATION_TIME,t1.INTERNAL,t1.CREATION_TIME from
    VVCMODEL.VERSION t1 where (t1.CONCEPT=@P0) order by t1.Creation
    
    For more details, please refer to the following workitem on
    jazz.net:
    https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.Wo
    rkItem/369434
    

Local fix

  • It's recommended to have the DBA run the following commands
    against the database:
    ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(450)
    NOT NULL
    ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(450)
    NULL
    
    followed by:
    CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)
    CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 369434: VVCMODEL.VERSION table CONCEPT and STORAGE columns   *
    * are not indexed                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * 369434: VVCMODEL.VERSION table CONCEPT and STORAGE columns   *
    * are not indexed                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • 369434: VVCMODEL.VERSION table CONCEPT and STORAGE columns are
    not indexed
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI54060

  • Reported component name

    RATL JAZZ TEAM

  • Reported component ID

    5724V04JZ

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-12-14

  • Closed date

    2016-12-22

  • Last modified date

    2016-12-22

  • 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

    RATL JAZZ TEAM

  • Fixed component ID

    5724V04JZ

Applicable component levels

  • R601 PSY

       UP

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSCP65","label":"Rational Team Concert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
22 December 2016