Hi,
I am trying to connect to a database instance on a remote server over ssh connection.
-establishing the connection with a .bat script (local machine: winXP)-the file local_script.sh
But, I get the following:
If I establish a connection via ssh, then type into the ssh console the commands 'db2start' and 'db2 bla-bla..' - it is all working.
Not working with the script though.

Any Ideas?
Best Regards

Not sure if this works from Windows, but you might try running the db2profile at the top of your script. It is usually located in the <DB2_instance_home>/sqllib directory.

The command is:
. db2profile

Note that "dot" has a space after it.

thxs.
db2 is installed on ubuntu server 10 (remote machine)
db2start and db2 not working, cause I have to supply full paths to
db2start/stop and db2 into the local .sh script stored on xp

Btw, db2 works in the ubuntu box console,
and it seems to work over ssh if I set explicitly the path to db2 in linux profile (eventhough it finds it somehow from ubuntu's console)

Now I am trying to run remotely a python script.
It is the same situation with the python imports:

and

I supplied the path:
and it does not complain, but where to find ibm_db on linux ????

>>>import ibm_db # on linux goes without complaint, but the 'find' bash command does not find any 'ibm_db'

where to find ibm_db on ubuntu10.10 (it is the python db2 driver)

It could be the case that ssh in your script doesn't start a so-called "login shell", so the environment is not set up in the same way as a regular "ssh". You can verify this by dumping all environment variables using "export" or something similar in the different situations that work vs. do not work.

Just realized that I cannot refer back to sql scripts from the locally executed .sh or python scripts.
Once they get to the remote shell they would ask for scripts relative to the pwd over there, so I am gonna need them uploaded there.
So, this time not only paths will be confused, but the actuall script won't be there at all..
# Not very smart, shouldn't took me that long to find it out