I need to write shell script in linux server under any folder, that should issue SSH to another unix based DB server to execute some DB script. After all I need to cpoy those log trace(db execution) to my linux server under some folder. Could some one can help me on this.
This works best if you setup an SSH cert so that the command won't prompt for a password.
Note that I made the ssh invoke a server-side script. That's because you may have to issue multiple commands to get the job done. Also because it's easier to test if you can log in and run the script as a remote user instead of having to debug both the ssh connection and the commands at the same time.
An IDE is no substitute for an Intelligent Developer.