a problem using rsh to get db2 information on the remote server

newhu114 · #1 (**permalink**) 08-03-04, 03:06

I am developping a program to watch the remote DB2 Servers. I use the rsh command to access the DB2 servers. I use the "db2inst2" user to rsh to remote server's information.
When I use following command in the local ,
rsh dbsvr1 "db2 get instance"
it shows following errors:
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".
However, I can use "rsh dbsvr1 df -k" correctly. I have search the reason,maybe the user's profiles in the local and remote server are different,but I can not reset the local user's profile as the same as remote server's.
Who can tell me how to do?

n_i · #2 (**permalink**) 08-03-04, 21:22

Quote:

Originally Posted by newhu114

I am developping a program to watch the remote DB2 Servers. I use the rsh command to access the DB2 servers. I use the "db2inst2" user to rsh to remote server's information.
When I use following command in the local ,
rsh dbsvr1 "db2 get instance"
it shows following errors:
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".

I suspect you will need to execute db2 profile before invoking CLP. Try this:

Code:

rsh dbsvr1 ". /home/dbsvr1/db2profile;db2 get instance"

I'm not sure about the profile script name - check if it's correct.

newhu114 · #3 (**permalink**) 08-04-04, 04:33

you are right,it's done!
thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech