Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: error in connect to database

    good afternoon,
    I have a DB2 8.1 fixpack 11, S.O. AIX.
    If I connect to the database db2 connect to xxxx with no fails, but if I do it this way gives me error.

    db2 connect to user username using password xxxx

    SQL30082N Attempt to Establish connection failed with security reason "24"
    ("USERNAME AND / OR PASSWORD INVALID"). SQLSTATE = 08001

    if I run su - username and password does not password error.

    Can anyone tell me the reason for the error?

    Thank you very much and greetings.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by georgipa View Post

    db2 connect to user username using password xxxx
    If my database name is sample, user is foo, and the password is "bar", the correct command would be:
    Code:
    db2 connect to sample user foo using bar
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    Please use to check db2 "? error_code"
    e.g for your error :
    db2 "? SQL30082N"

Posting Permissions

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