Hi everyone,

I'm new to DB2. I just installed DB2 V9.0 on Linux. Now i need to create a database for ClearQuest and need to create user ids for ClearQuest. I'm not sure how and where to do this. Any help would be much appreciated. Newbie so please bare with me. A couple of newbie questions what is an instance? Instance owner? What is a fence owner? and What is a Admin server user? I need to create an Admin user id and a regular user id. Thanks again.

Check the ClearQuest manual on how to create the database.

You need to read the manuals:
http://publib.boulder.ibm.com/infoce...w/v9/index.jsp

Instance=Database Manager (DBM) - i.e the database engine
Instance Owner = OS user who ultimately controls the instance
Fenced User= OS user that is used to run "fenced" processes in. Helps protect the DBM. See manual for further info on fenced processes.
Admin Server User= OS user who control the DAS

User IDs are created through the OS.

Andy

Thanks Andy. If i need to create an admin user id which group would it go under? Admin server user? or database manager? What about a regular user? which group would they go under? Thanks again.

The admin server user should have been created when you installed DB2. It usually is "dasusr1" in linux.

The other users are up to you and should be based on you security needs.

Andy