Originally Posted by junaid377
I have a db2 9.5 running on a linux server. I have created a new user for my self and given it sysadm role.
The problem I am facing is that when I log into terminal I need to run the db2profile to get the db2 environment set.
The problem with this is when I execute a command the computer thinks the command is executed by db2inst1. for example when I take a backup the backup created has db2inst1 as its owner and only db2inst1 has the rights on it. Is there a way to enable the db2profile that any thing created by me has me as the owner.
When you say only instance owner has rights to it, exactly what kind of rights are you looking for?
You could set the primary group of your new id to the same primary group as the instance owner primary group (usually something like db2iadm), and that should give some authorities to the backup files, but not sure what you need.