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

CLM Upgrade 6.0.2 - Create index files for VVCMODEL.VERSION table in which databases?

In the roadmap that I am following,

step 8: Create index files for VVCMODEL.VERSION

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)

does not specify which database should I do it.

I noticed that the table exists in the database JTS, CCM, QM and RM.

This step should be applied at all then?

I'm upgrading from 5.0.2 to 6.0.2 CLM

0 votes



One answer

Permanent link
 Hi

I raised a PMR against this too. The response I received was "I discussed this further with Development and this step is to be
removed in our next release as it was only a temporary measure."

Hope this helps

Regards
David

0 votes

Comments

Thank you David, 

in doubt I did in all databases, but left a script ready to reverse the action if necessary.

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
× 2,357
× 267

Question asked: Jul 02 '16, 4:05 p.m.

Question was seen: 2,449 times

Last updated: Jul 02 '16, 4:35 p.m.

Confirmation Cancel Confirm