I have a Linux box running oracle and using rman/TSM for Oracle for backup and restores.
TDPO is 5.5.1.0. The TSM client API is 6.3.0.0. The TSM Server, running on AIX, is 6.2.4.0. Backups times are acceptable, approximated 250GB in an hour using two rman channels. This drives the TSM server 1G Ethernet link at about 80MB/sec. Restores are so slow I do not have a time yet for restoring the 250GB. The linux server has no load; top shows: top - 14:54:09 up 4:39, 8 users, load average: 0.03, 0.02, 0.00 Tasks: 274 total, 1 running, 273 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.1%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16463088k total, 16368212k used, 94876k free, 305156k buffers Swap: 8388600k total, 0k used, 8388600k free, 15201560k cached TSM "q sess f=d" commands against the two TDPO sessions issued every 15 seconds shows each thread in a SendW state that lasts about 3.5 minutes, then the client receives a chunk of data, then goes into another 3.5 minute SendW. This repeats: IBM Tivoli Storage Manager Command Line Administrative Interface - Version 6, Release 2, Level 2.0 (c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved. Session established with server ULTSM: AIX Server Version 6, Release 2, Level 4.0 Server date/time: 10/19/12 14:53:02 Last access: 10/19/12 14:43:04 ANS8000I Server command: 'q sess 2508358 f=d' Sess Number: 2,508,358 Comm. Method: Tcp/Ip Sess State: SendW Wait Time: 3.6 M Bytes Sent: 477.4 M Bytes Recvd: 693 Sess Type: Node Platform: TDPO LinuxAMD64 Client Name: DBULSD4T Media Access Status: Current input volumes: VR0742L3,(2615 Seconds) User Name: Date/Time First Data Sent: Proxy By Storage Agent: Actions: ObjRtrv ANS8002I Highest return code was 0. IBM Tivoli Storage Manager Command Line Administrative Interface - Version 6, Release 2, Level 2.0 (c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved. Session established with server ULTSM: AIX Server Version 6, Release 2, Level 4.0 Server date/time: 10/19/12 14:53:02 Last access: 10/19/12 14:43:04 ANS8000I Server command: 'q sess 2508359 f=d' Sess Number: 2,508,359 Comm. Method: Tcp/Ip Sess State: SendW Wait Time: 3.6 M Bytes Sent: 546.1 M Bytes Recvd: 693 Sess Type: Node Platform: TDPO LinuxAMD64 Client Name: DBULSD4T Media Access Status: Current input volumes: VR0746L3,(2615 Seconds) User Name: Date/Time First Data Sent: Proxy By Storage Agent: Actions: ObjRtrv ANS8002I Highest return code was 0. IBM Tivoli Storage Manager Command Line Administrative Interface - Version 6, Release 2, Level 2.0 (c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved. Session established with server ULTSM: AIX Server Version 6, Release 2, Level 4.0 Server date/time: 10/19/12 14:53:17 Last access: 10/19/12 14:43:04 ANS8000I Server command: 'q sess 2508358 f=d' Sess Number: 2,508,358 Comm. Method: Tcp/Ip Sess State: SendW Wait Time: 9 S Bytes Sent: 517.4 M Bytes Recvd: 693 Sess Type: Node Platform: TDPO LinuxAMD64 Client Name: DBULSD4T Media Access Status: Current input volumes: VR0742L3,(2630 Seconds) User Name: Date/Time First Data Sent: Proxy By Storage Agent: Actions: ObjRtrv ANS8002I Highest return code was 0. IBM Tivoli Storage Manager Command Line Administrative Interface - Version 6, Release 2, Level 2.0 (c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved. Session established with server ULTSM: AIX Server Version 6, Release 2, Level 4.0 Server date/time: 10/19/12 14:53:17 Last access: 10/19/12 14:53:17 ANS8000I Server command: 'q sess 2508359 f=d' Sess Number: 2,508,359 Comm. Method: Tcp/Ip Sess State: SendW Wait Time: 9 S Bytes Sent: 591.8 M Bytes Recvd: 693 Sess Type: Node Platform: TDPO LinuxAMD64 Client Name: DBULSD4T Media Access Status: Current input volumes: VR0746L3,(2631 Seconds) User Name: Date/Time First Data Sent: Proxy By Storage Agent: Actions: ObjRtrv ANS8002I Highest return code was 0 So what is rman/oracle doing in the 3.5 minutes between its contacts with TSM? Any ideas for to fix this or at least how to troubleshoot it? David Ehresman University of Louisville