Hussein,

See answers embedded below.

---

> We have TSM 4.2 running in our shop, the host server is z/os the clients
>    are win2000 and WINNT , please can you help me in the following

>    questions:-

>

>    1- What is the way to backup SQL7/Data (lmf and mdf file types).

>       When the schedule runs to backup SQL7 data files, failed due to

>    busy/file in

>       use by another system.

>       What is the way to over come this problem by TSM?

You could use IBM Tivoli Storage Manager for Databases -
Data Protection for Microsoft SQL. It performs SQL Server
online backups to the TSM Server using the Microsoft and TSM APIs.
Data Protection for SQL is part of the IBM Tivoli Storage Manager
family of products and is purchased separately. This is the
recommended method as it provides the most functionality.
Alternatively, you could also run the backup of SQL server to a file
(using the internal tools available from SQL Server), then back up the
file to the TSM server using the standard BA client.

>

>    2- How we can code a folder name in the object field during schedule

>    definition?

>       if the name contains two or more words separated with spaces , I

>    tried to

>       enclose the name by single/double quotes but it doesn't work.

Use two sets of quotes, single quotes outside of double quotes.
For example:

    OBJECT='"C:\Program Files\Tivoli\TSM\baclient\filename.txt"'


>

>    3- Some tapes showing in query status is FULL , while it is showing
PCT
>       utilization less than 100% . Is this normal?


This is normal. It means that some of the objects on the tape have
"expired" from the TSM Server. This unused space will be "reclaimed" again
once the reclamation threshold you have set on the TSM Server
is reached and the reclamation process runs.
Please read the TSM Server Admin Guide for more details.


Del Hoobler
IBM Corporation