Thanks Del, I'll set compression to no and see how it runs tonight.

Could the other error I am seeing in the sqlsched.log means the same thing
or be related?

This is it:
Executing Operating System command or script:
   C:\commands\SQL.cmd
02/10/2003 03:01:53 Finished command.  Return code is: 402
02/10/2003 03:01:53 ANS1909E The scheduled command failed.
02/10/2003 03:01:53 ANS1512E Scheduled event 'SQL_SCHED' failed.  Return
code = 402.

Where can I find the specific meaning for the return codes?

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154



> -----Original Message-----
> From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
> Sent: Monday, February 10, 2003 10:08 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TDP Sql Failures
>
>
> Geoff,
>
> ACO5436E A failure occurred on stripe number (0), rc = 115
>    (RC155) means "compress data grew".
>
> Put the following in your DSM.OPT file
> to make sure it continues backing up if it hits this problem.
>    COMPRESSAlways    YES
>
> ...or put the following in the DSM.OPT file to make sure
> the "insite" database isn't compressed during the backup.
>    EXCLUDE.COMPRESSION "\...\insite\...\*"
>
> ...or, turn compression completely off.
>    COMPRESSIon       NO
>
> As far as the restore....yes there is a point-in-time feature.
>
> Thanks,
>
> Del
>
> ----------------------------------------------------
>
> Del Hoobler
> IBM Corporation
> hoobler AT us.ibm DOT com
>
> - Remember that the best job security is
> doing a job well and doing it cheerfully.
> =================================================================
> > 02/07/2003 03:08:46
> > 02/07/2003 03:09:21 ACO5436E A failure occurred on stripe
> number (0),
> > rc
> = 115
> > 02/07/2003 03:09:21 (RC155)
> > 02/07/2003 03:09:21 Backup of insite failed.
>