Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    17

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

    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?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.

  3. #3
    Join Date
    Jul 2004
    Posts
    17
    you are right,it's done!
    thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •