Data Maker parallelism

Document ID : KB000099945
Last Modified Date : 20/06/2018
Show Technical Document Details
Issue:
Below is the DDL created by CTAS statement  and we don't have any errors at this point. Since 300 million row column is taking about 3 day to mask, we need to add parallelism in the DDL of the function which is under scramble schema,  as per the DBA suggestion.  Kindly let me know if you have any concerns or questions. 
 
Environment:
TDM 4.5
Cause:
Enhancement
Resolution:
The ORACLE_MASKING08JUNE2018.zip resolves this issue. 

The steps to apply as follows 
1. Unzip the file to a local directory on the database server where your scramble components are installed. 
2. Load the latest java masking library using the Oracle loadjava utility (for more info on required privileges see https://docs.oracle.com/en/database/oracle/oracle-database/18/jjdev/loadjava-tool.html#GUID-033299E6-07E2-4C2C-9E26-A2FE25118F1C
open a command prompt in the directory you unzipped the files to. 
User-added image
In JAVA_ORACLE_SCRAMBLING.TXT the first commands are to drop and reload the masking java class file, you will need to edit the commands for your scramble login. 
This command is not run in SQL Plus. 
3. Login to SQL Plus as your scramble user, then run the create functions SQL commands in JAVA_ORACLE_SCRAMBLING.TXT 
4. Install the PL/SQL packages f_scramble2.plb, f_scramblen2.plb and f_scrambled2.plb 
User-added image
5. Test your version is now up to data, run the command in GET_VERSION.SQL
User-added image
Additional Information:

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html