Db2 – How to create DB2 objects with Linux SUDOer authority

db2db2-zoslinuxredhat

All,

I am relatively new to Red hat linux and I have SUDOer authority but unable to create DB2 database or other objects. How can I accomplish this task? Please give examples.

Also, is there any known freeware or trial tool for converting mainframe databases and associated objects to DB2 LUW specifically on linux box?

Thank you

Thanks in advance for your response.

Best Answer

Your OS authorities don't matter to DB2, which has its own authorization mechanism, although it is based on the OS authentication. In other words, you must have a login ID in the OS, which, if you are successfully authenticated, will be used to determine what authorizations you have from the DB2 point of view. You can read more about the model here: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.admin.sec.doc/doc/c0021804.html

At a minimum after installing DB2 and creating an instance you will have the instance owner user that has sufficient authority to create a database. The creator of the database, in this case the instance owner, automatically gets the SECADM (security administrator) and DBADM (database administrator) authorities over that database, which allow that user to create objects in the database and grant various privileges to other users.

With your sudoer rights in the OS you can su -l to the instance owner user (might be db2inst1 as this is the default) and perform whatever job you need.

As for the database migration tools, consider the IBM Database Conversion Workbench, which is a freely available plugin for IBM Data Studio that is also free.

Related Question