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

is there a document that outlines the database schema for CLM

Questions
Tags
Users
Badges
Karen Steele
(1.3k●5●141●152) Apr 13 '22, 8:36 a.m.

 as we can't upgrade our existing system (502) we are looking for documentation that gives the actual schema for 502 and also for 6061 - does such and item exist ... or at the very least a document that outlines the differences. 


We see from an upgrade perspective there appears to be a repotools-x -addTables command that always needs to be runs so it would be nice to know what is actually added during that routine.  

any help greatly appreciated

0 votes

1 answer
1,130 views
0 votes

Accepted answer

Permanent link
David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (1.8k●1●7) Apr 13 '22, 8:49 a.m.

In general, IBM does not publish the schema for ELM applications. They are considered implementation private, and subject to change without notice.

When repotools -addTables runs, it creates any new tables and columns required as part of EMF model evolution. I believe it logs what model changes it processes. Look in the log file created during upgrade.

Karen Steele selected this answer as the correct answer

0 votes

Comments
Karen Steele
Apr 13 '22, 9:02 a.m.

Thanks for confirming I suspected this may be the case as I couldn't find anything.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 13 '22, 10:38 a.m.

Karen, you also want to understand that the database tables are are generated to be able to store EMF data at least for a big part. The database tables are not designed to be consumed by human users as far as I was told.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 13 '22, 10:39 a.m.

Plus, why can't you upgrade your system? 

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.

Ask a question
Guidelines
FAQ
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,510
× 2,357
× 1,340
× 82
× 18

Question asked: Apr 13 '22, 8:36 a.m.

Question was seen: 1,130 times

Last updated: Apr 13 '22, 10:39 a.m.

Confirmation Cancel Confirm