John,

 Thanks for the info. and I'll look into the client sched log and the
server activity log. As far as your question regarding unload and reload
our DB is 21gb but we also question the performance of this function. We
were waiting for someone else to be brave enough to attempt this.

 Sorry I couldn't be more help and thanks again for your insight on my SQL
question.

 Thanks,
    Brian

Brian L. Nick
System Programmer - 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




                    John Naylor
                    <John.Naylor@SCOTTISH-SOUTH        To:     ADSM-L AT 
VM.MARIST DOT EDU
                    ERN.CO.UK>                         cc:
                    Sent by: "ADSM: Dist Stor          Subject:     Re: SQL 
restore question
                    Manager"
                    <ADSM-L AT VM.MARIST DOT EDU>


                    11/08/2000 10:44 AM
                    Please respond to "ADSM:
                    Dist Stor Manager"






Brian,
Have you got a perform trace set on the client.
If you have,  the Final Detailed Instrumentation statistics will give you a
breakdown
of where the time is being spent.
If not then the session stats either from the client schedule log or from a
query active on the
os390 server will give some info.
The data transfer time is basically the time not spent on the client, ie.
in the
network and on the
host tsm accessing the database and reading the data from the tape or disk.
The rest of the elapsed time is going to be time spent on the client mainly
in
writing out the data
This should at least give you a better idea where you need to look to
improve
the performance
 By the way I see you are an OS390  TSM 3.7.2 shop.
Any thoughts on my unload/reload question
John





Brian Nick <BRIAN_NICK AT PHL DOT COM> on 11/08/2000 02:46:01 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  Re: SQL restore question



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






**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**********************************************************************