Resetting the transaction database

An SI can reset the transaction database by truncating the tables that contain transaction data. Use the Reset Transaction DB process in the IBM® UrbanCode® Deploy Selfserv tool to truncate a transaction table or a group of transaction tables in the development, QA, and pre-production environments.

To reset the transaction database, complete the following steps:

1. Access the IBM UrbanCode Deploy Selfserve tool dashboard.
2. In the Applications tab, click the IBM Sterling Order Management System application. The Environments tab is displayed.
   This tab is the entry point to run processes for an application and displays all the environments that you can access.
3. Click for the environment where you want to run the process.
4. In the Run Process window, from the Process list, select Reset Transaction DB.
   
5. In the Group Name field, enter the table or group name that you want to truncate. If you want to truncate all the transaction tables, leave this field blank.
   • To truncate a table, enter TABLE.<table_name>. For example, TABLE.INTEROP_ERROR_DISPATCH
   • To truncate a group of tables, enter GROUP.<group_name>. Here, group_name is the name that is assigned to a logical group of tables. For example, GROUP.ASYNC_REQ
   • To truncate multiple tables or groups, or a combination of tables and groups, separate their names with commas. For example, if you want to truncate the INBOX and ASYNC_REQ groups, and the YFS_INVENTORY_SUPPLY_TEMP table together, enter the value as GROUP.ASYNC_REQ, GROUP.INBOX, TABLE.YFS_INVENTORY_SUPPLY_TEMP.

   For more information about the tables and groups that can be truncated, see Table reference.
6. Click Submit.