bash - how to run two commands in sudo?

Question

Is there any way how I can run two Db2 commands from a command line? (They will be called from a PHP exec command.)

1. db2 connect to ttt (note that we need to have the connection live for the second command
2. db2 UPDATE CONTACT SET EMAIL_ADDRESS = 'mytestaccount@gmail.com'

I tried this:

sudo -su db2inst1 db2 connect to ttt; db2 UPDATE CONTACT SET EMAIL_ADDRESS = 'mytestaccount@gmail.com'

The first command finishes correctly but the second one fails with the error message SQL1024N A database connection does not exist. SQLSTATE=08003

Note that I need to run this as php user. The command sudo -u db2inst1 id as php user gives me correct output.

Answer 1

For your command you also could refer to the following example:

sudo sh -c 'whoami; whoami'