Select query fails in my admin client.

vvenkateshgupta

Active Newcomer
Joined
Jun 28, 2007
Messages
6
Reaction score
0
Points
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?
 
Back
Top