DB2U version 8.1.0 with fix pack 3 on AIX 5L

Operating system information: AIX 5.2
Product to install: DB2 Universal Database Enterprise Server Edition 8.1.1.24
Installation type: Typical

I am install DB2U on AIX operating system by db2setup GUI with default value in all wizard.
I have received a error to the end of installation.
The error is: 'ERRORQL22212N A DB2 Administration Server communication error has been detected'

what could be the error ?

from root, i have tray to stop the DAS with:
# ./db2admin stop
and i have received this message:
SQL4410W The DB2 Administration Server is not active.
Then the DAS is non running after installation end.
Is it normal ?

I can run 'db2admin start' only by root, and non by other user.
I can run 'db2admin stop' only by dasusr1, and non by other user.
It is normal ?

I have run the db2setup GUI wizard from root user.
To the end of installation, when wizard run the command
"/home/db2inst1/sqllib/bin/db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE",
it stop and restart the DAS. But it can not stop the DAS because only dasusr1 user can stop the DAS.
Can be this the problem ?
Can i solve that ?

This is the Installation summary:

Installation Summary
--------------------
Name Level Part Event Result
-------------------------------------------------------------------------------
db2_08_01.essg 8.1.1.24 USR APPLY SUCCESS

Installing DB2 file sets:.......Success
Registering DB2 licenses:.......Success
Setting default global profile registry variables:.......Success
Creating the DB2 Administration Server:.......Success
Initializing instance list:.......Success
Customizing DB2 instance configuration:.......Success
Command to be run: "/usr/opt/db2_08_01/instance/db2icrt -a SERVER -s ese -u db2fenc1 -w 32 -p db2c_db2inst1 db2inst1".
The instance "db2inst1" has been created successfully.

The value "AUTHENTICATION=SERVER" was set in the DBM CFG file for the
"db2inst1" instance.

The value "SVCENAME=db2c_db2inst1" was set in the DBM CFG file for the
"db2inst1" instance.

The value "DB2AUTOSTART=YES" was set in the Profile Registry for the "db2inst1"
instance.

Creating DB2 instances:.......Success
Building list of databases to create:.......Success
Registering DB2 licenses:.......Success
Creating DB2 databases:.......Success
Configuring the DB2 Administration Server:.......Success
Updating global profile registry:.......Success
ERRORQL22212N A DB2 Administration Server communication error has been detected.
Client system: "10.0.3.155". Server system "10.0.3.155".

ERROR:An error occurred while running the command
"/home/db2inst1/sqllib/bin/db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING
DATABASE TOOLSDB FORCE" to initialize and/or migrate the DB2 tools catalog
database. The return value is "4".

Creating DB2 tools catalog:.......Failure



This are the installation option:


New instances:
Instance name: db2inst1
Authentication: SERVER
Start instance on reboot: Yes
FCM port range: 60000-60003
TCP/IP configuration:
Service name: db2c_db2inst1
Port number: 50000
Instance user information:
User name: db2inst1
Group name: db2grp1
Home directory: /home/db2inst1
Fenced user information:
User name: db2fenc1
Group name: db2fgrp1
Home directory: /home/db2fenc1

DB2 Administration server:
Instance user information:
User name: dasusr1
Group name: dasadm1
Home directory: /home/dasusr1
SMTP server: ddmstest

DB2 tools catalog:
Name: TOOLSDB
Schema: SYSTOOLS
Instance: db2inst1
Location: Local


Enabling Asynchronous I/O:.......Success
Checking license agreement acceptance:.......Success
Command to be run: "/usr/sbin/installp -acgqX -d '/software/ese.sbcsaix1/db2/aix' 'db2_08_01.msg.en_US.iso88591'".
SUCCESSES

C:\dprop>db2 get admin cfg

Admin Server Configuration

Authentication Type DAS (AUTHENTICATION) = SERVER_ENCRYPT

DAS Administration Authority Group Name (DASADM_GROUP) = .........

specify a group name to start/stop db2admin server
you should not start/stop admin from root
always su to dasusr1 and execute db2admin start/stop
you can create the toolscat after installation from cli
db2 create toolscat......
db2set -all will indicate user for admin
Best Regards, Guy Przytula

Tanks for your interest.
This is my actual configuration:


from get dbm cfg:

---------------------------------------------------------------------
SYSADM group name (SYSADM_GROUP) = DB2GRP1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =

Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO

Default database path (DFTDBPATH) = /home/db2inst1
---------------------------------------------------------------------

from get admin cfg:
---------------------------------------------------------------------
Admin Server Configuration

Authentication Type DAS (AUTHENTICATION) = SERVER_ENCRYPT

DAS Administration Authority Group Name (DASADM_GROUP) = dasadm1

DAS Discovery Mode (DISCOVER) = SEARCH
Name of the DB2 Server System (DB2SYSTEM) = DDMSTEST
---------------------------------------------------------------------

following the installation problem, i have another big problem. I thing the origin is the same: DAS !!!!

I login in Unix as db2inst1.
db2inst1 > db2 connect to sample user db2inst1 using Db2admin
gives me
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

db2inst1 > db2 connect to sample user db2inst1
and then enter the password Db2admin
gives me
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

But
if I do
db2inst1 > db2 connect to sample
it work fine and i can work with sample database.

It is the same also if i use another unix/db2 userid:
userid = rbs
password = user1adm

I login in Unix as rbs.
rbs > db2 connect to sample user rbs using Rb2admin
gives me
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

rbs > db2 connect to sample user rbs
and then enter the password user1adm
gives me
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

But
if I do
rbs > db2 connect to sample
it work fine and i can work with sample database.

Also if i try with:
rbs > db2 connect to sample user db2inst1 using Db2admin
gives me
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

I have try also with double o single quotes ! but not work.

db2diag.log error:
------------------------------------------------------------
2004-11-28-18.09.23.362240 Instance:db2inst1 Node:000
PID:24366(db2ckpwd 0) TID:1 Appid:none
oper system services sqlo_validate_pwd Probe:115

loginfailed() failed
0x2FF2160C : 0x0000000D ....
------------------------------------------------------------

The passwords are correct. I can enter on userid db2inst1 or in userid rbs with that password, by telnet or by su - <userid>.
"sample" is the database name.


what could be the error ?


Best regards.

hi,

Please do a db2iupdt. This would update the instance and then you should not have an issue.

If it works great else..

Please also check the permissions on these files
-r-s--x--x 1 root db2admin 27057 Nov 23 10:06 db2ckpw
-r-s--x--x 1 root db2admin 24307 Nov 23 10:06 db2chpw

The should be in the /home/instance/sqllib/security directory.

We had an issue when the permissions on this file differed.

Let me know if that helps.

Hi, thanks.

this is the result of run:

# db2iupdt -e
db2inst1
DBI1070I Program db2iupdt completed successfully.
#

$ pwd
/home/db2inst1/sqllib/security
$ ls -al
total 193
drwxr-xr-x 2 db2inst1 db2grp1 512 Dec 02 11:56 .
drwxrwsr-t 15 db2inst1 db2grp1 1024 Dec 02 11:56 ..
-r-s--x--x 1 db2inst1 db2grp1 23448 Dec 02 11:56 db2aud
-rw-r--r-- 1 db2inst1 db2grp1 4096 Dec 01 15:27 db2audit.cfg
lrwxrwxrwx 1 root system 36 Dec 02 11:56 db2chkau -> /usr/opt/db2_08_01/security/db2chkau
-r-s--x--x 1 root db2grp1 17583 Dec 02 11:56 db2chpw
-r-s--x--x 1 root db2grp1 19589 Dec 02 11:56 db2ckpw
-r-x--s--x 1 db2inst1 db2grp1 31477 Dec 02 11:56 db2flacc


db2grp1 is the primary group of instance owner db2inst1.




THE PROBLEM IS THE SAME.
from the db2inst1 session login:

$ db2 connect to prova

Database Connection Information

Database server = DB2/6000 8.1.3
SQL authorization ID = DB2INST1
Local database alias = PROVA

$ db2 connect reset
DB20000I The SQL command completed successfully.
$ db2 connect to prova user db2inst1 using db2admin
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
$

Best regards .