RTC and the DB2 Question(Archival and Deleteion)
We have the setup of RTC 3.0 with DB2.
I have mainly 2 question as of now.
1). I wanted to archive my closed Work Items in the RTC DataBase, how to do that? Is it feasible to point RTC back to the archived DataBase when and if needed in future.
2). I wanted to delete the streams, workitems from RTC so that the memory could be freed up from the RTC connected DB2 but practically when any work-item/stream is being deleted from RTC its memory usage in DB doesn't get any impact.I guess it is just deleting the reference from RTC but not from the actual DB and even when we make changes in the DB entry in DB2 it doesn't get reflected in RTC(may be the tables that RTC create in DB is too complex to understand).
I have mainly 2 question as of now.
1). I wanted to archive my closed Work Items in the RTC DataBase, how to do that? Is it feasible to point RTC back to the archived DataBase when and if needed in future.
2). I wanted to delete the streams, workitems from RTC so that the memory could be freed up from the RTC connected DB2 but practically when any work-item/stream is being deleted from RTC its memory usage in DB doesn't get any impact.I guess it is just deleting the reference from RTC but not from the actual DB and even when we make changes in the DB entry in DB2 it doesn't get reflected in RTC(may be the tables that RTC create in DB is too complex to understand).
One answer
In general there is no mechanism to archive work items to some other database.
-
You could move them to a project area to get them out of the way. That would preserve the links to other work items too.
-
You could set the archived attribute, however, you will have to account for that filtering them out in queries.
- If you archive a project area there is no data that is freed up.
-
You can delete work items and free up the space, but you would never get them back, as far as I can tell.
- If you delete streams, you only delete a very small selector for the components and changes that show up. The changes themselves will not be deleted. In 4.x you can delete change sets and entire objects from the repository. If the they are gone they are gone forever. Be careful. This is something that might be useful to remove big binary files.
That is my current knowledge.
Comments
Nhi P Ta
Dec 13 '12, 7:22 p.m.Hi Dhruv,