ANS1512E Return code = 1

Good morning/aftrenoon/evening *SMers!

We've got a NT4 box running client 4.2.1.20 and TDP for SQL 2.2. It backs up
to an AIX 4.3.3 server run TSM server 4.2.0.0.

The scheduled logbackups fail every two hours

5-05-2002 09:57:04 Next operation scheduled:
15-05-2002 09:57:04
------------------------------------------------------------
15-05-2002 09:57:04 Schedule Name:         MERIDIO_SQLLOG_BKUP
15-05-2002 09:57:04 Schedule Name:         MERIDIO_SQLLOG_BKUP
15-05-2002 09:57:04 Action:                Command
15-05-2002 09:57:04 Objects:               d:\Meridio\Goodies\logbackup.bat
15-05-2002 09:57:04 Options:
15-05-2002 09:57:04 Server Window Start:   10:00:00 on 15-05-2002
15-05-2002 09:57:04
------------------------------------------------------------
15-05-2002 09:57:04
15-05-2002 09:57:04
Executing scheduled command now.
15-05-2002 09:57:04
Executing Operating System command or script:
   d:\Meridio\Goodies\logbackup.bat
15-05-2002 09:58:51 Finished command.  Return code is:
   1
15-05-2002 09:58:51 ANS1512E Scheduled event 'MERIDIO_SQLLOG_BKUP' failed.
Return code = 1.
15-05-2002 09:58:51 Sending results for scheduled event
'MERIDIO_SQLLOG_BKUP'.
15-05-2002 09:58:51 Results sent to server for scheduled event
'MERIDIO_SQLLOG_BKUP'.

Where the logbackup.bat script is:


rem script for MS sql log backup

echo off

rem change this hostname as appropriate
set host_name=SQLRSLTSBDC1043

set sql_dir=d:\progra~1\tivoli\tsm\tdpsql

rem tdp sql backups
%sql_dir%\tdpsqlc backup LTSBIntegration,LTSBAudit,model log /buffers=3
/buffersize=1024 /logfile=%sql_dir%\TDP_Backup.log /logprune=60
/sqlbuffers=0 /sqlbuffersize=1024 /stripes=2 /tsmoptfile=%sql_dir%\dsm.opt
set SEV=I
if %errorlevel% NEQ 0 set SEV=E
%ba_dir%\dsmadmc -id=query -pa=queryquery issue message %SEV% """ODIN
%host_name% LTSBIntegration LTSBAudit and model TDP log backup
RC=%errorlevel%"""

:final
%ba_dir%\dsmadmc -id=query -pa=queryquery issue message i """ODIN
%host_name% log backup completed"""
:

A 'sister' SQL box (DC1042) is set up the same - same client level, TDP etc
except for the addition of LANFree, and behaves fine, whereas this box
(DC1043) is reporting failed schedules all the time and failing to issue the
message back to the TSM server. However, the TDP_Backup.log suggests all is
okay...

 ========================================================================
05/15/2002 09:57:06
 ========================================================================
05/15/2002 09:57:06 Request                       : LOG BACKUP
05/15/2002 09:57:06 Database Input List           :
LTSBIntegration,LTSBAudit,model
05/15/2002 09:57:06 Group Input List              : -
05/15/2002 09:57:06 File Input List               : -
05/15/2002 09:57:06 Number of Buffers             : 3
05/15/2002 09:57:06 Buffer Size                   : 1024
05/15/2002 09:57:06 Number of SQL Buffers         : 0
05/15/2002 09:57:06 SQL Buffer Size               : 1024
05/15/2002 09:57:06 Number of Stripes specified   : 2
05/15/2002 09:57:06 Estimate                      : 0
05/15/2002 09:57:06 Truncate Log?                 : Yes
05/15/2002 09:57:06 Wait for Tape Mounts?         : Yes
05/15/2002 09:57:06 TSM Options File              :
d:\progra~1\tivoli\tsm\tdpsql\dsm.opt
05/15/2002 09:57:06 TSM Nodename Override         : -
05/15/2002 09:57:06 Sqlserver                     : SQLRSLTSBDC1043
05/15/2002 09:57:06
05/15/2002 09:58:51 Total SQL backups selected:               3
05/15/2002 09:58:51 Total SQL backups attempted:              3
05/15/2002 09:58:51 Total SQL backups completed:              3
05/15/2002 09:58:51 Total SQL backups excluded:               0
05/15/2002 09:58:51 Throughput rate:                          21.16 Kb/Sec
05/15/2002 09:58:51 Total bytes transferred:                  2,187,056
05/15/2002 09:58:51 Elapsed processing time:                  100.96 Secs

Is this just a bug in the client code or am I missing something in the setup
perhaps?

TIA
Matt

* internal.        7-430-3213
*   external.       020-7922-3213
* fax                020-7922-3302
* e-mail            Matthew.Thomas AT Lloydstsb.co DOT uk




-----------------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee.  It may contain
This e-mail is intended only for the above addressee.  It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it.  If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS.  Registered in
England, number 2065.  Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH.  Registered in Scotland, number 95237.  Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
Financial Services Authority and represent only the Scottish Widows
and Lloyds TSB Marketing Group for life assurance, pensions and
investment business.

Signatories to the Banking Codes.
-----------------------------------------------------------------------------------------------------------------------
=========================================================================