Results 1 to 2 of 2
  1. #1
    Newcomer
    Join Date
    Jun 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Select query fails in my admin client.

    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, 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, 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. #2
    Senior Member domino's Avatar
    Join Date
    Nov 2005
    Location
    Germany
    Posts
    689
    Thanks
    1
    Thanked 23 Times in 21 Posts

    Default

    Quote Originally Posted by vvenkateshgupta View Post
    ...
    ANS1017E Session rejected: TCP/IP connection failure
    ANS8001I Return code -50.
    ...
    check your network settings
    If Microsoft is the answer, I want my problem back!

Similar Threads

  1. SELECT on few tables fails on TSM 6.1 from db2 client
    By rad6321 in forum TSM Reporting & Monitoring
    Replies: 3
    Last Post: 08-04-2011, 05:26 AM
  2. Admin Center Fails to install
    By cwilloug in forum ISC -Integrated Solution Console
    Replies: 2
    Last Post: 05-28-2009, 09:58 AM
  3. Replies: 9
    Last Post: 04-12-2007, 02:53 PM
  4. Admin Center installation fails
    By dhaehnel in forum TSM Server
    Replies: 1
    Last Post: 06-08-2006, 12:56 PM
  5. Select or Query
    By dehansen in forum Scripting
    Replies: 4
    Last Post: 10-29-2004, 06:44 AM

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
  •