Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2004
    Posts
    9

    Red face Unanswered: DB2 Installation Failed on AIX by GUI db2setup

    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
    Last edited by domenico.vinci; 12-01-04 at 10:07.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    db2 install

    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
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Nov 2004
    Posts
    9

    Red face db2 on aix

    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.

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Try This

    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.
    HTH

    Nitin

    Ask the experienced rather than the learned

  5. #5
    Join Date
    Nov 2004
    Posts
    9

    Question db2 on aix

    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 .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •