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.
-
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) NULLCREATE 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
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.