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
|