Where does RTC keep index table for work Items?
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.
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
For Q1
For Q2There 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.
On Oracle the table names starting with Model_ are the work item tables.
Comments
Thank you, Aradhay.
Your information will be very helpful !
one more question.
Do you know which table keep attachments of work Items?
Thank you.
Is it Attachment table for MODEL schema?
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.
1 vote