Results 1 to 15 of 15
  1. #1
    Join Date
    May 2015
    Posts
    14

    Question Answered: Create New Users

    Hello,

    I must create more 2 users(DBA) in my main instance. Actually I access my databases with a single instance user. How can I add more users with DBA profile to access the instance.

    SO AIX 6.1
    DB2 V9.7

    Regards.

  2. Best Answer
    Posted by przytula_guy

    "google is good for you : I am not an aix expert either, but using google you will learn a lot, just if you want to (because I am in a good day, I provide you the links..)
    look for create user (adduser) change group for user..... on below links.....
    http://www.ibm.com/developerworks/ai...-aixuseradmin/
    http://www.unix.com/aix/149787-how-c...add-group.html"


  3. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Access the instance? Do you mean have sysadm authority? Users are created by the sys admin and if they are to have sysadm auth then they must be added to the sysadm group
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  4. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    or you could have sysadmin set up sudo access to the instance id for the new users. or both.
    have you read this https://www-01.ibm.com/support/knowl...gentopic6.html
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  5. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #5
    Join Date
    May 2015
    Posts
    14
    I'm a root user...My server is for a test.

  7. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I'm a root user...My server is for a test. : is this a question or a statement
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  8. #7
    Join Date
    May 2015
    Posts
    14
    Actually I have root user privileges. My server is an enviroment test. I need to add more 2 users to access the instance(db2inst1).

  9. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated before - first create the users with regular os commans and later go to the instance and grant these user the needed db-authority
    or in the os, join these users to a specific group if sysadmin is needed for this group, that is defined in db2 in the dbm cfg with sysadmin group
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  10. #9
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    And read the manual as I indicated. access the instance? That really means nothing. I presume you want sysadm auth or to assume the identity of the instance user? I'm concerned that you want to do a test involving DB2 and have no idea of how it works.
    Clarify your requirements
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  11. #10
    Join Date
    May 2015
    Posts
    14
    Tks for your help. So I have these configuration:

    - Filesystem
    db2inst1
    - Instance Name
    db2inst1

    I connect to this instance by this command:
    su - db2inst1
    pass: ******

    db2inst1 is an instance user of sysadm privileges. I must create more 2 instances users as the same profile of db2isnt1(sysadm). I need this because I have more 2 dbas to access the db2.

    It's more clear now??

    Regards

  12. #11
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Not really. An instance is 'owned' by a unique userid. If there are to be multiple instances of DB2 then you would need multiple instance userids. Otherwise if the dbas (and they should be giving you specific instructions regarding this - that's part of their role) require 'instance level' authority on the db2inst1 instance then they should be added to the primary o/s group of the db2inst1 userid
    e.g. if the the db2inst1 userid has a primary group of db2iadm2 then add the other userids to that group
    which is what I said earlier
    or allow them to use sudo to access the db2inst1 userid
    and I also said that earlier
    ** And as the instance would belong to the DB2 DBAs then why can't they just su to db2inst1 as they should own the password for that userid
    Your DB2 DBAs should be providing all this info - if they can't then I suggest you consider getting them trained or replaced because this is basic DB2 DBA knowledge
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  13. #12
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated before
    try reading this and beyond
    http://www-01.ibm.com/support/knowle.../c0005479.html
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  14. #13
    Join Date
    May 2015
    Posts
    14
    Tafste

    My problem isn't with DB2. I've never worked with AIX. It's the first time for me. The person responsable for AIX is out of my company and I must to do everything alone. Databases steps wasn't a problem. I've never need to open a call or something else with IBM. My company has the Premium Contract, where We have hight priority in any question about IBM.

    As you said my problem is in AIX. You said "require 'instance level' authority on the db2inst1 instance then they should be added to the primary o/s group of the db2inst1 userid". I have no idea how can I do this...Can you explain me with more detalis???



    Przytula_guy.
    Thanks for your tip...I think this link is related with Tafste said to us...

  15. #14
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    google is good for you : I am not an aix expert either, but using google you will learn a lot, just if you want to (because I am in a good day, I provide you the links..)
    look for create user (adduser) change group for user..... on below links.....
    http://www.ibm.com/developerworks/ai...-aixuseradmin/
    http://www.unix.com/aix/149787-how-c...add-group.html
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  16. #15
    Join Date
    May 2015
    Posts
    14
    I've already search in Google about this subject but I wanted to make sure the correct way.

    Thanks for your help and links again.

    I like to post here(dbforuns) to generate more discussions about my doubt and DB2, by the way I think that my doubt can be the other persons.

Tags for this Thread

Posting Permissions

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