1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Select query fails in my admin client.

Discussion in 'Command Line Administrator Client' started by vvenkateshgupta, Jul 25, 2011.

  1. vvenkateshgupta

    vvenkateshgupta Active Newcomer

    Joined:
    Jun 28, 2007
    Messages:
    6
    Likes Received:
    0
    tsm: TSMTOL01>SELECT entity AS "Node name", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB xfer", SUBSTR (CAST(min (start_time) AS char(29)),1,10) AS "start date", SUBSTR (CAST(min (start_time) AS char(29)),12,8) AS "start time", SUBSTR (CAST(max (end_time) AS char(29)),1,10) AS "end date", SUBSTR (CAST(max (end_time) AS char(29)),12,8) AS "end time" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 48 hours and start_time<=current_timestamp - 24 hours GROUP BY entity
    ANS1017E Session rejected: TCP/IP connection failure
    ANS8001I Return code -50.
    ANS8064E Communication timeout. Reissue the command.
    Session established with server TSMTOL01: AIX
    Server Version 6, Release 2, Level 2.30
    Server date/time: 07/25/11 08:26:30 Last access: 07/25/11 08:22:24
    ANS8001I Return code -50.


    This select query fails in this particular admin client. It works in the other servers.
    Can someone tell me how to fix this?
     
  2.  
  3. domino

    domino ADSM.ORG Senior Member

    Joined:
    Nov 16, 2005
    Messages:
    720
    Likes Received:
    32
    Occupation:
    System Engineer
    Location:
    Germany
    check your network settings
     

Share This Page