Anonymize Personally Identifable Information (PII) Job Performance

Products

• Clarity PPM On Premise

Issue/Introduction

The job takes too long to complete for around 60,000 resources.
Is there a way to make the job run faster?

 

Environment

Release : 15.8.1

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

The job performance depends on the number of resources needed to obfuscate/mask data in the Clarity and DWH database.

What parameters are selected with the job?
The job can run for resources that are inactive.

Obtain the performance report for the duration of the job and have review the tuning recommendations with the DBA team.

In one reported case with the Oracle database, the AWR reported tuning the query related to the CMN_AUDITS table