What is the VVCMODEL.VERSION table used for?
We are upgrading RTC from 6.0.1 to 6.0.2 (includes also RRC, RQM & JRS). The interactive upgrade guide has the following step (i.e. step #14):
Create index files for the VVCMODEL.VERSION table
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.
a. 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 step is very vague and has no mention of which server this is to be done on. It only says "your server". Are we targeting a particular database(s)? There's also not much information of what this is all about. Any idea?
Create index files for the VVCMODEL.VERSION table
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.
a. 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 step is very vague and has no mention of which server this is to be done on. It only says "your server". Are we targeting a particular database(s)? There's also not much information of what this is all about. Any idea?
Accepted answer
One other answer
I have found the answer. It is documented here: http://www-01.ibm.com/support/docview.wss?uid=swg21975746 Just wished it had been more obvious. Thanks @Michael Afshar