Solved: SQL30082N Security processing failed with reason ...

Former Member · ‎10-15-2007

Hi all.

I'm managing the following error during a system copy:

<b>SQL30082N Security processing failed with reason "15" ("PROCESSING FAILURE").

SQLSTATE=08001</b>

Inside the db2diag.log, i have the following message:

<b>2007-10-15-16.44.56.793439+120 I718413554A270 LEVEL: Warning

PID : 483450 TID : 1

FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20

DATA #1 : String, 64 bytes

Password validation for user sapr3 failed with rc = -2146500315</b>

Can anyone help?

Thanks and regards,

Marco.

Frank-Martin · ‎10-15-2007

Hi,

check if the files

$INSTHOME/sqllib/security/db2c?pw

have the correct permissions. They need a SUID bit to root.

If the SUID bit is not set, you can do a

<db2_install_dir>/instance/db2iupdt db2<dbname>

as user root to update your DB2 instance. This will set the permissions correctly.

Regards

Frank

SQL30082N Security processing failed with reason "15" (PROCESSING FAILURE)