Hi Matthew! Try capturing the output from the batchfile (fi >c:\temp\output.txt). Kindest regards, Eric van Loon KLM Royal Dutch Airlines
-----Original Message----- From: Thomas, Matthew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:56 To: [EMAIL PROTECTED] Subject: 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 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 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 [EMAIL PROTECTED] ---------------------------------------------------------------------------- ------------------------------------------- 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. ---------------------------------------------------------------------------- ------------------------------------------- ********************************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **********************************************************************
