home‎ > ‎monitoring‎ > ‎

infx rlist

List a one line summary of each instance on remote hosts.

usage

infx rlist [ util remote_hosts ]
     list instances on remote hosts
       optional:
         util - template to use for output format
         remote_hosts - list of remote host names
  • by default, infx determines the list of remote hosts based on the host names found in the SQLHOSTS file.
  • alternatively define the variable REMOTE_HOSTS in config to specify a list
  • pass remote_hosts= on the command line to provide a specific list to execute against

example

demo1b@bobii:/home/informix>infx rlist remote_hosts=awsvpn01+awsvpn02

host: awsvpn01
num  inst    status  type  version
0    demo1   Up      IDS   11.70.FC4IE  IBM Informix Dynamic Server Version 11.70.FC4
2    demo1b  Up      IDS   11.70.FC4TL  IBM Informix Dynamic Server Version 11.70.FC4

host: awsvpn02
num  inst       status  type  version
0    demo1bhdr  Up      IDS   11.70.FC4TL  IBM Informix Dynamic Server Version 11.70.FC4
1    test1      Up      IDS   11.70.FC4IE  IBM Informix Dynamic Server Version 11.70.FC4

notes

  • output format defined in /infx/template/infx-cli/infx-cli-qlist.htmlt, copy to /infx/local/etc and change there
  • all hosts must have the infx software installed
  • for ssh access without a password use infx keysend