Installing and configuring the Optim data privacy user-defined functions for DB2 for z/OS
Use these instructions to install and configure the Optim™ user-defined functions (UDFs) for DB2® for z/OS®. After the UDFs are installed, you can use them to dynamically mask DB2 for z/OS data.
If you need a license, contact your IBM representative for information about how to obtain a license key that includes data privacy. Your license key identifies the Optim features you are entitled to use, such as the data privacy UDFs. For more information, see Licensing requirements for the Optim data privacy components.
Before you install the UDFs, consult your DB2 for z/OS DBA because prior experience with UDFs can help ensure a smooth installation.
- Definition of the UDF names for DB2 for z/OS.
- Installation of the provided external function
IOQYMASK
.
Regular UDF name | Specific UDF name | Input data type | Return data type |
---|---|---|---|
OptimMaskStr | OptimMaskStr | VARCHAR(32704) | VARCHAR(2048) |
OptimMaskStrEBCDIC | OptimMaskStrEBCDIC | VARCHAR(32704) | VARCHAR(2048) |
OptimMaskInt64 | OptimMaskInt64 | BIGINT | BIGINT |
OptimMaskInt64HashChar | VARCHAR(32704) | BIGINT | |
OptimMaskInt64HashDate | DATE | BIGINT | |
OptimMaskInt64HashTime | TIME | BIGINT | |
OptimMaskInt64HashTs | TIMESTAMP | BIGINT | |
OptimMaskInt64HashNum18S0 | NUMERIC(18,0) | BIGINT | |
OptimMaskInt64HashDouble | DOUBLE | BIGINT | |
OptimMaskNum | OptimMaskNum18S0 | NUMERIC(18,0) | NUMERIC(18,0) |
OptimMaskNum18S2 | OptimMaskNum18S2 | NUMERIC(18,2) | NUMERIC(18,2) |
OptimMaskNum18S4 | OptimMaskNum18S4 | NUMERIC(18,4) | NUMERIC(18,4) |
OptimMaskNum18S6 | OptimMaskNum18S6 | NUMERIC(18,6) | NUMERIC(18,6) |
OptimMaskDouble | OptimMaskDouble | DOUBLE | DOUBLE |
OptimMaskDate | OptimMaskDate | DATE | DATE |
OptimMaskTime | OptimMaskTime | TIME | TIME |
OptimMaskTimestamp | OptimMaskTimestamp | TIMESTAMP | TIMESTAMP |
OptimMask | OptimMasKOInt | BIGINT | BIGINT |
OptimMaskONum18S0 | NUMERIC(18,0) | NUMERIC(18,0) | |
OptimMaskOStr | VARCHAR(32704) | VARCHAR(2048) |
Do the following steps to install the Optim UDFs and the data privacy providers used by the UDFs to mask data.