The restore of the 'flat' file to the server is TSM, the restore of the flat 
file to MS-SQL is MS-SQL. Which is it that is slow?

>>> BRIAN_NICK AT PHL DOT COM 11/08/00 08:56AM >>>
Hello everyone,

 I was just contacted by one of our DBA's and I have a questions about SQL
restore. We are running TSM 3.7.3 on OS/390 2.9 and TSM client version
3.7.2. Please note that we are not using TDP for SQL. As explained to me by
our DBA there is a dump of the SQL data base taken every night and TSM
backs up the dump. By the way this is SQL 6.5 SP5a. The questions is
performance, we are currently attempting to restore the dump which is a
small file only 230mb. At the current rate it looks like the restore will
take about 2.5 hours to run. The dump file is being restored to its
original location.

 I realize that this question might be vague but it is all the information
that I have to offer at this time. Any help on improving the performance of
this SQL restore would be appreciated.

 Thanks,
    Brian


Brian L. Nick
Systems Technician - Storage Solutions
Phoenix Home Life Mutual Ins.
100 Bright Meadow Blvd
Enfield CT. 06082-1900

E-MAIL:  Brian_Nick AT PHL DOT COM 
PHONE:   (860)403-2281