There is an option in the 3.x repotools :
-deleteProjectAreaResources --Delete all archived resources
belonging to the specified context area URL.
--The connection
URL for the server.
--Admin user id to login to the Jazz
repository.
--Admin password to login to the
Jazz repository.
contextURL=<value> --The URL of the context area for which all
archived resources are to be deleted.
--Force all resources to be deleted for the specified
context, archived or not.
--Run the command without prompting for confirmation.
--The file containing
the admin user's login credentials.
--The file containing the admin
user's login certificiate.
--The alias to login using a smart card, or
? to list available aliases.
--Path
to the log file.

Not sure whether this will free resources on the DB though.



On 16/11/2010 2:53 PM, nz wrote:

We're rolling out RTC in a very large organisation.

I was wondering whether there was a way to archive and purge RTC
projects and other objects.

These could be projects/objects that are obsolete/retired and are past
their shelf life (a point where the company no longer cares about
them).

Given the size of the company and the number of projects that will be
using RTC, we don't want the DB growing indefinitely.

We are very interested in this also. Anyone know if it removes them from the DB????

There is an option in the 3.x repotools :
-deleteProjectAreaResources --Delete all archived resources
belonging to the specified context area URL.
--The connection
URL for the server.
--Admin user id to login to the Jazz
repository.
--Admin password to login to the
Jazz repository.
contextURL=<value> --The URL of the context area for which all
archived resources are to be deleted.
--Force all resources to be deleted for the specified
context, archived or not.
--Run the command without prompting for confirmation.
--The file containing
the admin user's login credentials.
--The file containing the admin
user's login certificiate.
--The alias to login using a smart card, or
? to list available aliases.
--Path
to the log file.

Not sure whether this will free resources on the DB though.



On 16/11/2010 2:53 PM, nz wrote:

We're rolling out RTC in a very large organisation.

I was wondering whether there was a way to archive and purge RTC
projects and other objects.

These could be projects/objects that are obsolete/retired and are past
their shelf life (a point where the company no longer cares about
them).

Given the size of the company and the number of projects that will be
using RTC, we don't want the DB growing indefinitely.

Hi,

I do not believe that this will remove the project and all related artifacts from the database. It is very complicated to determine which objects are related to a project and not used/referenced by any other project. There is a feature in the works that will allow users to move a project from one repository to another, and part of this process is properly deleting it from the old repository. This feature will not be included in the RTC 3.0 release, but here is a link to a wiki page where the status of the feature is detailed if you wish to learn more:

https://jazz.net/wiki/bin/view/Main/ProjectMove

Parker

-deleteProjectAreaResources will not delete all of the resources for project areas in RTC. The -deleteProjectAreaResources option gets rid of resources that are stored in the JTS storage, but not all RTC artifacts use this storage; many (most, maybe all) use an older type of storage. This option works for other applications, such as RRC.

Martha
Jazz Process Developer

There is an option in the 3.x repotools :
-deleteProjectAreaResources --Delete all archived resources
belonging to the specified context area URL.
--The connection
URL for the server.
--Admin user id to login to the Jazz
repository.
--Admin password to login to the
Jazz repository.
contextURL=<value> --The URL of the context area for which all
archived resources are to be deleted.
--Force all resources to be deleted for the specified
context, archived or not.
--Run the command without prompting for confirmation.
--The file containing
the admin user's login credentials.
--The file containing the admin
user's login certificiate.
--The alias to login using a smart card, or
? to list available aliases.
--Path
to the log file.

Not sure whether this will free resources on the DB though.



On 16/11/2010 2:53 PM, nz wrote:

We're rolling out RTC in a very large organisation.

I was wondering whether there was a way to archive and purge RTC
projects and other objects.

These could be projects/objects that are obsolete/retired and are past
their shelf life (a point where the company no longer cares about
them).

Given the size of the company and the number of projects that will be
using RTC, we don't want the DB growing indefinitely.