Results 1 to 2 of 2
-
07-25-2011, 03:36 AM #1Newcomer
- Join Date
- Jun 2007
- Posts
- 4
- Thanks
- 0
- Thanked 0 Times in 0 Posts
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?
-
07-25-2011, 05:40 AM #2
Similar Threads
-
SELECT on few tables fails on TSM 6.1 from db2 client
By rad6321 in forum TSM Reporting & MonitoringReplies: 3Last Post: 08-04-2011, 05:26 AM -
Admin Center Fails to install
By cwilloug in forum ISC -Integrated Solution ConsoleReplies: 2Last Post: 05-28-2009, 09:58 AM -
Select to find which admin schedules were defined or altered by a specific admin
By shanafin in forum ScriptingReplies: 9Last Post: 04-12-2007, 02:53 PM -
Admin Center installation fails
By dhaehnel in forum TSM ServerReplies: 1Last Post: 06-08-2006, 12:56 PM -
Select or Query
By dehansen in forum ScriptingReplies: 4Last Post: 10-29-2004, 06:44 AM


Reply With Quote
