Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57

    Unanswered: Unable to attach to the remote instance

    Hi,

    I am getting below error while attaching to the remote instance.

    Code:
    D:\Backups>db2 attach to P6APP1_1 user db2inst1
    Enter current password for db2inst1:
    SQL30082N  Security processing failed with reason "24" ("USERNAME AND/OR
    PASSWORD INVALID").  SQLSTATE=08001
    
    D:\Backups>
    This command is failing in windows XP however i am able to catalog node using control center by search option and it is able to search the db2 instance running on AIX and databases runinng under this instance.

    The password and user name are correct and the same command (user/password) is working fine in AIX machine where my DB2 Server is running.

    Below is the dbm configuration on my DB server running on AIX
    Code:
     Database manager authentication        (AUTHENTICATION) = SERVER
     Alternate authentication           (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
     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
    Environment Details:
    SERVER OS : AIX 64 bit
    DB SERVER :9.7 with Fix Pack 1

    CLIENT OS : Windows XP
    CLIENT DB : 9.7 Fix Pack1
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    As the error states, either the username or password is incorrect.

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    There may be problems with passwords that are longer than 8 characters and/or contain punctuation characters. Try a password that's no longer than 8 alphanumeric characters.

  4. #4
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57
    i used password as db2inst1 only
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Can you connect to a database on the AIX server form windows?

    Andy

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    please post the result of
    Code:
    db2 list node directory

  7. #7
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57
    D:\>db2 list node directory

    Node Directory

    Number of entries in the directory = 1

    Node 1 entry:

    Node name = P6APP1_1
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = TESTDBSRV
    Service name = db2c_db2inst1


    D:\>
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

Posting Permissions

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