开发者

How to start with db2 after installation

开发者 https://www.devze.com 2023-03-11 16:01 出处:网络
I am new to db2. I have installed db2 and need to run the queries through terminal. I have LINUX machine.

I am new to db2. I have installed db2 and need to run the queries through terminal. I have LINUX machine.

After installed run the below query or any queries like create database, it will display the error

db2 => start database manager
SQL1092N  "ROOT" does not have the authority to perform the requested command 
or operation.开发者_运维问答


The root user does not have automatic access to DB2 server resources, and arguably shouldn't. The user you should be logged in as to start working with DB2 is the instance owner (this is a different user than the DAS owner). If you're not sure which user owns the DB2 instance, or if an instance exists yet, use the db2ilist command to show a list of all instances installed on the local server.

As the db2 instance owner you can run db2start, db2stop, and db2sampl to start working with a database right away. Eventually you will want to create other users who will interact with DB2 with fewer permissions than the instance owner has. As soon as you have a database up and running, you can use GRANT statements to allow other users to connect to the database, work with tables, and execute routines (user-defined functions and stored procedures).


This link can help you. (http://community.jboss.org/wiki/InstallDB2OnFedora)

Log in as dasusr. Use the db2admin command to control the administration server.

[dasusr]$ db2admin start [dasusr]$ db2admin stop


Log in as a DB2ADMIN. Then add a user and give previllige for him.

How to start with db2 after installation

0

精彩评论

暂无评论...
验证码 换一张
取 消