AWSJDB802E error accessing DB2 using composer after SAN problem
After SAN issues, no client can connect to DB2 using composer.
composer dis cpu=@
AWSBIA299I Looking for Workstation objects.
AWSJDB802E An internal error has occurred while connecting to the database. The database connection is not available.
SystemOut.log
[MM/DD/YY 17:07:10:340 CET] 0000001c ConnectionPoo E [ibm][db2][jcc]
[t4][2010][11246] Connection authorization failure occurred. Reason:
Local security service non-retryable error.DSRA0010E: SQL State = null,
Error Code = -4,214
[MM/DD/YY 17:07:10:347 CET] 0000001c ExceptionMapp E AWSJDB802E An
internal error has occurred while connecting to the database. The
database connection is not available.
[MM/DD/YY 17:07:10:350 CET] 0000001c ConnException E AWSJDB802E An
internal error has occurred while connecting to the database. The
database connection is not available.
[MM/DD/YY 17:07:10:357 CET] 0000001c PropertiesLoa E AWSJDB802E An
internal error has occurred while connecting to the database. The
database connection is not available.
[MM/DD/YY 17:07:10:364 CET] 0000001c ExceptionHelp E AWSJCL054E The
command "extract" has failed, for the following reason: "AWSJDB802E An
internal error has occurred while connecting to the database. The
database connection is not available.".
/DB2DIR/sqllib/db2dump/db2diag.log:
2011-11-02-23.53.57.192505+060 I427386A273 LEVEL: Warning
PID : 1007808 TID : 1
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage,
probe:20
DATA #1 : String, 67 bytes
Password validation for user db2inst1 failed with rc = -2146500315
But able to connect as db2inst1:
[/home/db2inst1:] db2 connect to twsdb
Database Connection Information
Database server = DB2/AIX64 9.1.7
SQL authorization ID = DB2INST1
Local database alias = TWSDB
Owner permission has been changed inside the DB2 sqllib/security directory.
Check this technote: Configure DB2 authorization encryption algorithm
Check if the db2ckpw and db2chpw files have correct permissions under /DB2DIR/sqllib/security. See the following result:
-r-s--x--x 1 db2inst1 db2adm1 31261 Nov 3 05:42 db2ckpw
-r-s--x--x 1 db2inst1 db2adm1 28170 Nov 3 05:42 db2chpw
These files are owned by db2inst1 not root. The group should be the same as the other files under the /DB2DIR/sqllib/security directory, however, the owner must be root.
To resolve this issue:
Perform the following steps:
db2stop
login as root (not su root)
Backup the original files using "cp -p" option and change the file ownership:
-r-s--x--x 1 root db2adm1 31261 Nov 3 05:42 db2ckpw
-r-s--x--x 1 root db2adm1 28170 Nov 3 05:42 db2chpw
Run [/opt/IBM/db2//instance:] ./db2iupdt db2inst1
db2start
Check the file permissions again to make sure they are correct.
Try composer commands to see if the issue is resolved.
If there is any error when running DB2 commands or if the issue is still not resolved after performing these steps, contact DB2 support for further assistance.