Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: Praveen Devarao
RE: Error: ROOT CAPABILITY REQUIRED [ reply ]  
2009-02-23 05:03
Hi Vinod,

You will need to start the DB2 server with Root privileges. Given that DB2 uses OS authentication, it is necessary that you start the server with root privileges else you will see the "ROOT CAPABILITY REQUIRED" error.

Few links for your reference.

http://www.tek-tips.com/viewthread.cfm?qid=1432300&page=3

http://blog.springenwerk.com/2009/01/ibm-db2-on-mac-with-ruby-rails-and.html

Let me know if you require more info.

Thanks

Praveen

By: vinod jain
RE: Error: ROOT CAPABILITY REQUIRED [ reply ]  
2009-02-23 04:59
I could solve this by:

To resolve the issue:
- stop db2
- run db2iupdt against the db2 instance
- restart db2
- restart TEPS


refer: http://www-01.ibm.com/support/docview.wss?rs=650&context=SSTFXA&dc=DB560&dc=DB520&uid=swg21375842&loc=en_US&cs=UTF-8&lang=en&rss=ct650tivoli

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0002060.htm

A

By: vinod jain
Error: ROOT CAPABILITY REQUIRED [ reply ]  
2009-02-22 23:07
I have installed ibm_db driver on ubuntu. then
1. started the irb: irb -rubygems.
2. irb-> require 'ibm_db' returns true. works fine.
3. irb-> conn = IBM_DB.connect("sample","db2inst1","mypassword")
fails. I get following error:
IBM_DB.conn_errormsg
=> "[IBM][CLI Driver] SQL30082N Security processing failed with reason \"42\" (\"ROOT CAPABILITY REQUIRED\"). SQLSTATE=08001 SQLCODE=-30082"

Thanks in advance for the help