John,

Yes. I know what the problem is.
The answer can be found in the IBM Knowledge Base.Go here:


http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManagerforDatabases.html

and search for "ANS1017E".

It will come up with 1 hit..  reference# 1114216.

In a nutshell... you need to increase the COMMTIMEOUT value
on your TSM Server to allow the SQL Server time to preformat the database.

Thanks,

Del

----------------------------------------------------
> I am attempting to restore a 90 gig SQL database to a test server ( not
the original location).
> The Restore will start and I will have disk activity but then it will
stop and generate a TCPIP connection > failure,
>

> 09/25/2003 11:30:03
> 09/25/2003 12:46:22 ACO5436E A failure occurred on stripe number (0), rc
= 418
> 09/25/2003 12:46:22 ANS1017E (RC-50)  Session rejected: TCP/IP
connection failure
> 09/25/2003 12:46:23 Restore of PRO failed.
> 09/25/2003 12:46:23 ANS1017E (RC-50)  Session rejected: TCP/IP
connection failure
> 09/25/2003 12:46:23 Total database backups inspected:               1
> 09/25/2003 12:46:23 Total database backups requested for restore:   1
> 09/25/2003 12:46:23 Total database backups restored:                0
> 09/25/2003 12:46:23 Total database skipped:                         0
> 09/25/2003 12:46:23 Throughput rate:                                0.67
Kb/Sec
> 09/25/2003 12:46:23 Total bytes transferred: 3,145,728
> 09/25/2003 12:46:23 Elapsed processing time: 4,580.04 Secs
> 09/25/2003 12:46:23 ACO0151E Errors occurred while processing the
request.
>
> Does anyone have any ideas , what is causing this? I am using the latest
SQLTDP 5.1.5.15, I have upgraded > the B/A client to the latest 5.2
version, hope this is not causing the problem.
> I have increased the TSM server's commtimeout to 1800 ( 30 minutes) and
it does not change a thing.

Thanks for your help