It's all about the answers!

Ask a question

vvcmodel tables during 602 upgrade?


Mahari Hill (47055161) | asked May 04 '16, 1:30 p.m.
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.


2 answers



permanent link
Carlton Knight (1612) | answered May 05 '16, 7:38 p.m.
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.

Comments
Mahari Hill commented May 11 '16, 10:47 a.m.

Hello,

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


permanent link
Carlton Knight (1612) | answered May 12 '16, 3:15 p.m.
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

Your answer


Register or to post your answer.