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
- Change to the project where Data
Virtualization pods are
installed.
oc project ${PROJECT_CPD_INST_OPERANDS} - Log in to the Data
Virtualization head pod.
oc rsh c-db2u-dv-db2u-0 bash - Switch to the Data
Virtualization database instance owner
db2inst1.su - db2inst1 - Run the following commands to update the
db2profile.source /opt/dv/current/dv-common.shexport_pid1_env ZEN_SERVICE_INSTANCE_IDupdate_db2profile_for_security_pluginbigsql stop; bigsql start