SQL30082N error when you try to authorize a user after you update Data Virtualization

When you update Data Virtualization, you might see errors when you authorize or validate a user.

Symptoms

The Data Virtualization update succeeds, but when you run db2 connect to bigsql user admin using <your password>, you see the following error message.

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLST

Resolving the problem

  1. Change to the project where Data Virtualization pods are installed.
    oc project ${PROJECT_CPD_INST_OPERANDS}
  2. Log in to the Data Virtualization head pod.
    oc rsh c-db2u-dv-db2u-0 bash
  3. Switch to the Data Virtualization database instance owner db2inst1.
    su - db2inst1
  4. Run the following commands to update the db2profile.
    source /opt/dv/current/dv-common.sh
    export_pid1_env ZEN_SERVICE_INSTANCE_ID
    update_db2profile_for_security_plugin
    bigsql stop; bigsql start