I don't know whether this is a O/S question or a DB2 question but how can I stop/start db2 from a shell script ? The script has to run under the 'root' account ?

Thanks.

You need to invoke the profile of the instance owner (which will invoke the DB2 profile to point to a particular instance) and then just do a db2stop.

How do I "invoke the profile" ?. Add

". /home/db2inst1/sqllib/db2profile" in the shell script ??

Thanks.

I do not directly execute the DB2 profile. I execute the .profile that is in the home directory of the instance owner. The .profile will then execute the DB2 profile for you. But it may work OK if you execute the DB2 profile directly.

I think you have correct syntax in your example.