开发者

How to start with db2 after installation

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜