IBM BPM, V8.0.1, All platforms > Administer applications and processes in the runtime environment > Manage relationships > Remove relationship instance data from the repository

RelationshipDatabaseSchemaDrop script

Use the RelationshipDatabaseSchemaDrop.py script to remove all relationship database artifacts that are associated with a relationship, including all database artifacts and instance data that are associated with the roles defined for that relationship.

The RelationshipDatabaseSchemaDrop.py script is located in the WPS_HOME/util/RelService directory.

Make sure that wsadmin is connected to the server (in a stand-alone environment) or to the dmgr (in a Network Deployment environment).

The RelationshipDatabaseSchemaDrop.py script causes all the relationship database artifacts that are associated with the relationship to be forcibly removed, even if other applications are using the relationship. The system does not detect shared relationships.

Do not uninstall the application that contains the relationship whose database artifacts you plan to drop before you run the RelationshipDatabaseSchemaDrop.py script. Uninstall the application after you run the script.


Required parameter

relationshipFullName

The full name of the relationship, which has the following format: relationship target namespace plus " /" plus relationship short name.

For example, with relationship target namespace http://RelationshipSample and relationship short name CountryRelationship, the full name would be http://RelationshipSample/CountryRelationship.


Example

This example removes all the relationship database artifacts that are associated with relationship full name http://RelationshipSample/CountryRelationship.

wsadmin -f ${WPS_HOME}/util/RelService/RelServicRelationshipDatabaseSchemaDrop.py http://RelationshipSample/
CountryRelationship

Remove relationship instance data from the repository