It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,880
×7,474
×4,715
×4,320

question asked: Oct 22 '13, 12:55 a.m.
question was seen: 5,588 times
last updated: Oct 26 '13, 7:25 p.m.

Related questions

Where does RTC keep index table for work Items?

0
ryosuke oka (179●9●46●48) | asked Oct 22 '13, 12:55 a.m.
edited Oct 26 '13, 7:25 p.m. by Geoffrey Clemm (30.1k●3●30●35)
One of our client is looking for detailed information of Oracle tables for RTC database.
They would like to know where (table space) RTC create index table.

Q1.
I thought index table on CCM table space but I can not see index table on it.
Is it on JTS table space?

Q2.
What table actually have work Item data?
 
Setting up an Oracle database
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html&scope=null

If anyone know these, let me know.

Accepted answer

3
permanent link
Aradhya K (1.4k●5●43●45) | answered Oct 22 '13, 5:32 a.m.
JAZZ DEVELOPER
 For Q1
There are 2 indexes with respect to the work items, the first one is the index for the full text search. This is stored in the file system of the App server. The path to this is there as part of the teamServer.properties. The other index is database index. these are the indices to the work item table itself.

For Q2
On Oracle the table names starting with Model_ are the work item tables.
ryosuke oka selected this answer as the correct answer
Comments
ryosuke oka commented Oct 24 '13, 2:35 a.m.

Thank you, Aradhay.
Your information will be very helpful !

ryosuke oka commented Oct 24 '13, 2:47 a.m.

one more question.
Do you know which table keep attachments of work Items?

Thank you.

ryosuke oka commented Oct 24 '13, 2:55 a.m.

Is it Attachment table for MODEL schema?

1
Aradhya K commented Oct 24 '13, 4:07 a.m.
JAZZ DEVELOPER

MODEL_ATTACHMENT is the table name for attachment table,

I would not recommend you firing queries on any of the tables before talking to the development. 

Your answer

Register or 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.