Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Post Installation task of DB2

    I have installed db2 8.1 on linux machine. The current db2 users are instance user(db2inst1), fenced user(db2fenc1) and db2as(administration server). To start using the database do I have to create additional users or use the database as the instance owner itself.

    1) How do I create db2 users and test a connection from a db2 user.

    2) If I have to create a new user , to which group do I have to make him belong. I have three groups (db2iadm1 which has db2inst1, db2fadm1 which has db2fenc1 and db2asgrp which contains db2as)

    Please clarify. thanks.

  2. #2
    Join Date
    May 2003
    You create users using the Linux OS facilitates to create users. They do not have to belong to any of the defined groups. You give authority to the user with the GRANT SQL command (see the SQL Reference for details) or use the GUI on the Control Center for some grants.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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