Where does RTC keep index table for work Items?

ryosuke oka (179●8●45●48) | asked Oct 22 '13, 12:55 a.m.
edited Oct 26 '13, 7:25 p.m. by Geoffrey Clemm (30.1k●2●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

permanent link

Aradhya K (1.4k●4●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?

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.

It's all about the answers!

Related questions

Where does RTC keep index table for work Items?

Accepted answer

Your answer