BDS Global Data Cleanup

BDS cleanup generates SELECT and DELETE scripts.

BDS cleanup can be used from the command line as follows:

ant -Dapplication.name=[application.name] -Dmajor.version=[major.version] generate-bds-sql

This generates 2 scripts:
  • select_[db.type]_[application.name]_[major.version].sql

    This contains the SQL command to run to list all the Case Model versions deployed for the given major version. It also prints the required Case Model Drop Script. Check the output of the select script carefully before running the delete script.

  • delete_[db.type]_[application.name]_[major.version].sql

    This contains the SQL commands to run to purge the BPM database of the Case Model information. It starts by selecting the required Case Model Drop Script.

Important: You must run SELECT scripts and carefully check the output before running DELETE scripts.
Note: For DB2, if you have a large drop script and receive the error DB29320W Output has been truncated at the end of the combined_drop_script, then you can export it with the following command:

db2 export to output.txt of del LOBFILE combined_drop_script SELECT combined_drop_script FROM amxbpm.bds_casemodels where component_name = '[application.name]' AND major_version = '[major.version]'

Next topic: Attribute Alias Cleanup
Previous topic: Running the bpm-db-cleanup Utility