It's all about the answers!

Ask a question

What is the VVCMODEL.VERSION table used for?


Stephane Couillaud (15632344) | asked May 02 '16, 7:59 p.m.
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?

Accepted answer


permanent link
Michael Afshar (7014) | answered May 02 '16, 11:00 p.m.
JAZZ DEVELOPER
 These are related to RDNG and DM databases.
Stephane Couillaud selected this answer as the correct answer

Comments
Stephane Couillaud commented May 03 '16, 1:52 p.m.

So these commands should be run on the database server against the RDNG database (RM in our case), is that correct?

One other answer



permanent link
Stephane Couillaud (15632344) | answered May 03 '16, 2:10 p.m.
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 

Your answer


Register or to post your answer.