Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

vvcmodel tables during 602 upgrade?

CLM 601->602 upgrade:

Create index files for the VVCMODEL.VERSION table Back to top

The VVCMODEL.VERSION table is not indexed by the upgrade procedure. After you upgrade your server, you must run the following commands to create index files for the VVCMODEL.VERSION table.

  1. Open a sqlcmd command line tool and enter the following commands:

    ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(450) NOT NULL
    ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(450) NULL

    CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)
    CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)

This appeared in our interactive guide. We don't use Global Configuration, is this mandatory? This is not listed as Optional.


0 votes



2 answers

Permanent link
These steps are to address defect P154060. Query performance becomes slow when using SQL server

Also see IBM Technote

Any customer on RDNG 6.0 or higher and using MS SQL server will be affected by this.

1 vote

Comments

Hello,

Should these be done only for the RM database or all databases?


Permanent link
Just the RM database.  If you happen to be using Design Management its looks like the commands should be used for the DM database also.

http://www-01.ibm.com/support/docview.wss?uid=swg21975746

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,495
× 6,121

Question asked: May 04 '16, 1:30 p.m.

Question was seen: 3,960 times

Last updated: May 12 '16, 3:15 p.m.

Confirmation Cancel Confirm