Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    7

    Cool Unanswered: how to create new user with SYSADM authority

    hi

    my os-windows2000
    db2 udb v8.1

    while installing db2 i used my domain username and
    password(which i use to login to my machine).
    recently i have changed my password.
    when i login and when i access db2 it gives the

    error:database manager is not started
    if i try !db2admin start at CLP
    error:invalid user

    can some one guide me
    1)how to change the password in db2 while iam changing the domain login password.
    2)how to create a new user/password with sysadmn authority
    so that in future i can use this newly created user with administrator priviledges and hence this wont get affected if i change the domain username/password.

    thanks and regards
    siva!

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: how to create new user with SYSADM authority

    1) If you are changing the password used for admin server, you will have to execute the command db2admin with setid option .... After doing this, if there is an error, go to Windows Services panel and change the password associated with admin server service ...

    2) db2 get dbm cfg command shows the SYSADM_GROUP of the instance. If it is set to some value, add the new user to that group ... If the value is blank, add the user to the administrator group ...

    BTW, db2 security on windows environment is a bit complex .... There is a profile variable DB2_GRP_LOOKUP_LOCAL which might help ... there used to be an appendix for windows security impl in admin guide for v7 ... Not sure about v8 ...

    HTH

    Cheers

    Sathyaram





    Originally posted by etlsiva
    hi

    my os-windows2000
    db2 udb v8.1

    while installing db2 i used my domain username and
    password(which i use to login to my machine).
    recently i have changed my password.
    when i login and when i access db2 it gives the

    error:database manager is not started
    if i try !db2admin start at CLP
    error:invalid user

    can some one guide me
    1)how to change the password in db2 while iam changing the domain login password.
    2)how to create a new user/password with sysadmn authority
    so that in future i can use this newly created user with administrator priviledges and hence this wont get affected if i change the domain username/password.

    thanks and regards
    siva!

Posting Permissions

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