Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2012
    Posts
    6

    Unanswered: Changing DB2 password

    I'm trying to change password using:

    CONNECT TO db_name USER user_name USING old_pacc NEW new_pass CONFIRM new_pass

    I get
    SQL30083N Attempt to change password for user id "test" failed with security
    reason "2" ("NEW PASSWORD INVALID"). SQLSTATE=08001

    This on on Windows.

    I tried different new passwords and cannot get it to work. Why?

    Katarina

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    May be your Windows administrator set a policy that your password doesn't match. Or may be you are trying to use in the password some special characters that the DB2 client does not like.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2012
    Posts
    6
    If I try to change it in OS to the same password - it does work. That means my password does satisfy password policy.

    I do use special characters. it seems DB2 supports those characters- Help -

    Am I supposed to use escape characters or something when using special characters?

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Suggest you work with your site security admin. They should be able to explain the the problem you are seeing.

    That means my password does satisfy password policy.
    At least some of it . . . A few of the organizations i support have quite similar (but slightly different) password policies between their mainframes and the LUW systems.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by kgrolinger View Post
    If I try to change it in OS to the same password - it does work.
    Just to make sure -- you do that on the DB2 server? Or is it a domain ID that you're using?

    Quote Originally Posted by kgrolinger View Post
    I do use special characters. it seems DB2 supports those characters
    Why don't you try a password without special characters and see what happens.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Sep 2012
    Posts
    6
    At this time I'm doing tests on DB that is installed on my machine.
    I created user on my machine.

    I have to use special characters as that is in the os policy. (although I did try without it and same error)

  7. #7
    Join Date
    Oct 2016
    Posts
    1

    a bit late resolution.....

    I found the same problem....after a day of test.... I sorted out the problem!! you need to set status of the user to expired in Windows users managment panel!
    this will permit to reset the password with db2 command.

    I hope this save hours of research and test.....

    bye

    Max

Posting Permissions

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