Larry,

 We are talking about the restore of the flat file from the TSM server to
the SQL server.

 - 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




                    Lawrence Clark
                    <Larry_Clark AT THRUWAY DOT ST        To:     ADSM-L AT 
VM.MARIST DOT EDU
                    ATE.NY.US>                     cc:
                    Sent by: "ADSM: Dist           Subject:     Re: SQL restore 
question
                    Stor Manager"
                    <ADSM-L AT VM.MARIST DOT EDU>


                    11/08/2000 09:23 AM
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"






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