1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Select query fails in my admin client.

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

  1. vvenkateshgupta

    vvenkateshgupta New Member

    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 Senior Member

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

Share This Page