Clean-up of the GTREP database - PG_<number>_<number> tables

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

In the TDM GTREP Repository, we see multiple tables with the name PG_<number>_<number>, for example PG_1234_567890. 

We would like to know how to clean-up these tables. Some are very old and probably no longer needed. However, we don't know the ramification of deleting these tables.  What are these tables used for, and what is the recommended method to cleaning up these tables?"

Environment

TDM 4.10 and 4.11 GTREP Repository

Resolution

The PG_<number>_<number> tables are used for duplicate row detection. It is safe to delete any of these tables that you don't think aren't needed anymore.