DB2 9.7 LUW - How do I SET SESSION_USER when I am DBADM,SECADM?
Ok, I think I actually figured out how to handle this. I needed to grant the ability for my DBADM,SECADM to transfer to any ID through the group not the specific ID. In this way I get around the SECADM restrictions.

db2 grant setsessionuser on public to group DB2ADMNS


Since my ID db2admin is in this group, it can now switch to any ID (the public part). If I only wanted to be able to switch to that ID, I could have used:

db2 grant setsessionuser on user bobabob97 to group DB2ADMNS


So now I can perform

db2 set session_user=bobabob97


and it works.

To switch back I only need to run

db2 set session_user=system_user