Hi we are using DB2 EEE v7.2 on AIX 4.3.3. We need to lockdown the instance owner id and password but still have someone to be able to administer the database. We only have a part time dba type person doing this(it should be full time but hey i can't change their minds) We need to create ids that will have dba authority or is there a way to use the OS ideas that are already created to do this by updating the dbm cfg SYSADMIN_GROUP? If so can someone tell me how to do either of these two ways of accomplishing the same thing?
Also we need to create id's with less authority, any idea of how to do this?
The person that installed DB2 did not install the control centre so this will all have to be done from the command line until the control centre is installed.