Updating the dbpuserconf.ini file

1. Log in to the server as the user with the required permissions.

2. Navigate to the directory where you have downloaded the dbpuserconf.ini file.
   For example, /etc/protegrity/

3. To view the contents within the directory, run the following command:

   /etc/protegrity/ #  ls -ltr
   

4. Press ENTER.
   The list of available configurable files appears.

   total 4
   -rw-r----- 1 tdatuser tdtrusted 1058 Jan 28 01:27 dbpuserconf.ini
   

5. To open the dbpuserconf.ini file, run the following command:

   /etc/protegrity/ # vim dbpuserconf.ini
   

6. Press ENTER.
   The vim utility starts and the contents of the dbpuserconf.ini file appears.

   ###############################################################################
   # Config ini
   ###############################################################################
   [config_ini]
   # path points to database protector installation directory
   path = /opt/protegrity/databaseprotector/teradata/data/config.ini
   
   ###############################################################################
   # Protector Varchar Sizes (set by user during installation)
   ###############################################################################
   [varchar_sizes]
   UDF_VARCHAR_MAX = 500
   UDF_VARCHAR_OVERHEADMAX = 500
   VARCHAR_MAX_IN_BUF_LEN_TOKEN_LATIN = 500
   VARCHAR_MAX_OUT_BUF_LEN_TOKEN_LATIN = 676
   VARCHAR_MAX_IN_BUF_LEN_ENC_LATIN = 500
   VARCHAR_MAX_OUT_BUF_LEN_ENC_BYTES = 538
   VARCHAR_MAX_IN_BUF_LEN_TOKEN_UNICODE = 500
   VARCHAR_MAX_OUT_BUF_LEN_TOKEN_UNICODE = 1356
   VARCHAR_MAX_IN_BUF_LEN_ENC_UNICODE = 500
   VARCHAR_UNICODE_MAX_OUT_BUF_LEN_ENC_BYTES = 1038
   TdvmDev2:/etc/protegrity/ #
   

   Important: You must update the VARCHAR_MAX_OUT_BUF_LEN_TOKEN_UNICODE parameter with the required output buffer length.

7. To save the changes to the dbpuserconf.ini file, run the following command:

   # :wq