Next-generation platform

Resetting the transaction database

A user with the Developer role can reset the transaction database from Self Service by truncating the tables that contain the transaction data. A transaction table or a group of tables can be reset in the development, QA, master configuration, or preproduction environments.

Procedure

To reset the transaction database, complete the following steps:

  1. Access Self Service with your IBMid.
  2. From the Self Service menu, click Environments.
    This tab is the entry point to run processes for an application and displays all the environments that you can access.
  3. From the list of environments, select an environment.
  4. On the Processes tab, click Start process.
  5. From the Process list, select Reset Transaction DB.
  6. In the Group Name field, specify the names of the tables or of the groups of tables 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.
    • To truncate all custom transactions tables, enter EXTN.TABLES.TRAN in the Group Name field.
    • To truncate particular custom transaction table, enter EXTN.TABLE.<CUSTOM_TRANSACTION_TABLE> in the Group Name field.
    For more information about the tables and groups that can be truncated, see Table reference.
    Note: Many tables are not part of the lists or groups because of their complex relationships with other related tables. For example, order or shipment related tables. Therefore, a simple reset is not supported for such tables. You need to use appropriate purge agents to purge these tables.
  7. Click Submit.