Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: How to change db2admin password ?

    Friends,

    I need to change the password for db2admin user.

    If I change it, then db2 service does not start. I guess I might have installed the software as db2admin.

    How can I work around it. I am not sure how to but if I manage to change the password for db2 service, will there be anything else to do for successful start and run ?

    Please advise, thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You use the OS to change the password.

    Andy

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by ARWinner View Post
    You use the OS to change the password.

    Andy
    Very simple !!

    Then DB2 service does not start. Any way to work around this ?

    Thanks

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is your OS and DB2 version?

    Andy

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    win2k3 db2v9.7.3a

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    I don't use Windows a lot so not really sure, but did you try changing the password during connect to the db (connect to ... using <pwd> new <new pwd>...)

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Well, I think I should try to say it in different words!

    When we install DB2 on windows OS then few services are created. For example one is DB2 - DB2COPY1 - DB2

    If I change password at system level then on next db2start this service cannot log on to windows. DB2 won't run.

    So if I need to change password of db2 adminstrator (db2admin user) then I must go through list of services that need new password to log on to system so that whole db2 system starts seamlessly.


    My question was to some one who had done it already; to help me with list of such things to do.

    For an example we have DB2 administration commands for Administration server as
    >db2admin stop

    >db2admin setid db2admin mynewsecret

    >db2admin setschedid db2admin mynewsecret

    > db2admin start
    What are other commands for other db2 services ??

    Regards
    Last edited by DBFinder; 01-14-11 at 23:45.

Posting Permissions

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