ADSM-L

Re: TDP MS SQL client errors

2001-09-04 10:10:50
Subject: Re: TDP MS SQL client errors
From: Thomas Denier <Thomas.Denier AT MAIL.TJU DOT EDU>
Date: Tue, 4 Sep 2001 10:12:03 -0400
Quoting Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>:

> I am seeing the following errors in my dsmerror.log after a scheduled
> CMD:
>
> 09/03/2001 19:26:19
> Executing Operating System command or script:
>    D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd
> 09/03/2001 19:26:20 Finished command.  Return code is:
>    1
> 09/03/2001 19:26:20 ANS1512E Scheduled event 'BACKUP.ACADNT3.SQL'
> failed.
> Return code = 1.
> 09/03/2001 19:26:20 Sending results for scheduled event
> 'BACKUP.ACADNT3.SQL'.
> 09/03/2001 19:26:21 Results sent to server for scheduled event
> 'BACKUP.ACADNT3.SQL'.
>
> How do I figure out what is happening ?
>
> I can execute the sqlfull.cmd file manually, and it works just fine.
>
> I don't see anything in the tdpsql backup logs or error files ????

I suspect that you have a problem with nesting of quotation marks.
Because of the embedded blank in "Program Files", the command sent
to the client has to enclosed in double quotes:

"D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd"

The objects operand of the 'define schedule' or 'define clientaction'
command has to use single quotes to protect the double quotes from
being removed by TSM itself:

objects='"D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd"'
<Prev in Thread] Current Thread [Next in Thread>