Results 1 to 2 of 2
  1. #1
    Newcomer
    Join Date
    Sep 2008
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default why does select * from nodes returns empty tcp_address

    hello,

    Not sure if this is the correct sub forum, but does anyone know why an empty tcp_address would be returned on a select tcp_address from nodes i.e:

    tsm: x10>select node_name,tcp_address from nodes where tcp_address is NULL

    NODE_NAME TCP_ADDRESS
    ------------------ ------------------
    CYKPDBAGL01
    HUBBLE

    I have about 60 nodes that do not return IP addresses. Some are VMS, running ABC client, some are locked or not in use for a while, but some are active nodes that run everyday.
    TSM Server release is 5.5.6.102. Same happens on 6.3.1. Client versions and type vary
    Thanks

  2. #2
    Member
    Join Date
    Sep 2012
    Posts
    14
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    select node_name, tcp_address, tcp_name from nodes

    Run this command, this one you will get tcp_address for all nodes..

    More SQL queries

    http://www.tsmguide.co.cc/p/tsm-sql-commands.html

Similar Threads

  1. Replies: 1
    Last Post: 12-08-2011, 05:40 PM
  2. [HOWTO] Select for nodes..
    By cwilloug in forum TSM Operation
    Replies: 1
    Last Post: 01-15-2010, 03:35 PM
  3. Tcp_address tms client
    By michelangelo in forum Administrative Client
    Replies: 3
    Last Post: 07-01-2008, 10:29 AM
  4. Replies: 1
    Last Post: 06-16-2006, 10:45 AM
  5. SELECT 2 NODES
    By josh597 in forum Scripting
    Replies: 2
    Last Post: 11-12-2005, 09:09 PM

Tags for this Thread

Posting Permissions

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