Skip to main content

DB2 for LUW

  1. Login to the server as user root/admin at the database server.

  2. Run the following commands - substitute terms to suit your local environment <db name>.
    db2set DB2_ATS_ENABLE=yes 

    db2 set DB2_COMPATIBILITY_VECTOR=0F  

    db2 update db cfg for <db name> using SELF_TUNING_MEM on (optional, but recommended for best performance)  

    db2 stop force 

    db2 start

  3. While still running as root/admin, create a new user on the DB Server operating system. The recommended user id is “dguser”.

  4. On the PK Protect server, open a Db2 Command Window, and ensure your database is cataloged in the db2database directory for the Linux Db2 client.

    Run the dg_db2_pre_install.cmd script located at: opt/Dataguise/DgSecure/IDPs/DgMaskerIDP/expandedArchive/WEB-INF/classes/com/dataguise/Worker/Masker/PrerequisiteFiles/Scripts/DB2

    syntax:  dg_db2_pre_install.cmd  <DB_NAME> <SYSADM USERID> <SYSADM PASSWORD> <DG MASKER USER ID> <MASKER SCHEMA> <DB2 SERVER IP ADDRESS>  <DB2 SERVER PORT>

    1. <DB_NAME> The name of the db where masking will take place. 

    2. <SYSADM USERID> The name of the db2 sysadm user id (required for tablespace and bufferpool creation). Note:  SYSADM user id must also have DBADM on the database being masked.

    3. <SYSADM PASSWORD> The db2 sysadm password.

    4. <MASKER USER ID> The name of the user id that will be used in DgMasker to connect to the database for masking. Recommendation is ‘dguser’.

    5. <MASKER SCHEMA> The name of the DgMasker schema to be used for creating the DG tables. Recommendation is ‘DG’.

    6. <Db2 SERVER IP ADDRESS> IP Address of DB server.

    7. <Db2 SERVER PORT> Port Number where db2 instance is running.

    8. Check the output file for errors dg_db2_pre_install.log

      Example: dg_db2_pre_install.cmd DB1 db2 inst1 password dguser DG 192.168.5.22 60000

  5. Run a db2jdbcbind from PK Protect server to Db2 Db Server. Open a Db2 Command Window. Set size = 30 or greater.
    Example:
    db2jdbcbind -url "jdbc:db2://192.168.5.229:50000/SAMPLE" -user dguser  -password dguser -size 30

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.