Shell Programming and Scripting

Ive got a portion of a script here:

su - db2inst1 "-c db2 connect to mydb; db2 list tablespaces "

when i run that on its own I get "A database connection does not exist"

but when i manually input (from root)
su - db2inst1
db2 connect to mydb; db2 list tablespaces

it works fine!

Ive no clue what the problem is...please help!

Ok NEW DEVELOPMENT on this. Ive found the problem...and it is so screwy....I have another script that works perfectly fine...the simular section looks like this:

/usr/opt/db2_08_01/instance/db2ilist | while read inst; do

j=1

su - $inst "-c db2 list db directory"|grep -i "Database alias" | sed -e "s/Datab
ase alias//g" |sed -e "s/=//g" | while read dbs; do

database[j]=$dbs


su - $inst "-c db2 connect to ${database[$j]}; cd /apps/db2utils/miscscripts/; db2 -tvf reorgtable > reorgtable.out; sed '1,4d' reorgtable.out > tmpfile; mv tmpfile reorgtable.out; db2 -tvf reorgtable.out; db2 -tvf runstats > runstats.out; sed '1,4d' runstats.out > tmpfile; mv tmpfile runstats.out; db2 -tvf runstats.out; rm reorgtable.out; rm runstats.out" >> maintenance.log
j=$(( $j + 1 ))

done

done

The problem is that if the last command in the string involves anything that needs to be preceeded with db2(basically requires a connection to the database) its execution will fail because for some reason the connection to the database breaks before the command is executed. The reason why this script did not fail is because my last command is rm runstats.out, whereas my other script the last command is a db2 command which requires a database connection. So can anyone explain why when su'ing the db connection breaks before the final command executes????

I don't know that db2 command you are using, so I really cannot comment on what is happening. But if your analysis is correct, then this should work:

su - db2inst1 "-c db2 connect to mydb; db2 list tablespaces ; sleep 2"

My gut feeling is that something like:
su - db2inst1 "-c db2 connect to mydb; sleep 2; db2 list tablespaces "
might make more sense. But neither one really seems plausible.

Yea, ill use that sleep command, right now I put an echo at the end but I believe the sleep command will work as well and be a bit cleaner