Re: [ADSM-L] TDP SQL backup fails but is reported as a success ??
2017-01-19 11:03:54
> The only thing we have after the backup command is some echo statements. I
> would think that they would not affect the errorlevel?
Yes they do! But only the last echo.
The last command is an "echo". I have never seen an echo fail. It will always
return 0. The return code of the script will the return code of the last
command.
/Anders Räntilä
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
RÄNKAB - Räntilä Konsult AB
Klippingvägen 23
SE-196 32 Kungsängen
Sweden
Email: Anders AT Rantila DOT com
Phone: +46 701 489 431
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Tom Alverson
Sent: den 19 januari 2017 16:55
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDP SQL backup fails but is reported as a success ??
The only thing we have after the backup command is some echo statements. I
would think that they would not affect the errorlevel?
@ECHO OFF
set sql_install="C:\Program Files\Tivoli\TSM\TDPSql"
set sql_virtual="C:\TSM\TDP"
echo %date% %time% >> %sql_virtual%\SQL_FullLog.txt
echo
****************************************************************************************
>> %sql_virtual%\SQL_RunLog.txt
echo %date% %time% >> %sql_virtual%\SQL_RunLog.txt
echo
****************************************************************************************
>> %sql_virtual%\SQL_RunLog.txt
%sql_install%\tdpsqlc backup * full /BACKUPMETHod=legacy
/SQLSERVER=servername /tsmoptfile=%sql_virtual%\dsm_sql.opt
/logfile=%sql_virtual%\SQL_FullLog.txt >> %sql_virtual%\SQL_RunLog.txt
echo
****************************************************************************************
>> %sql_virtual%\SQL_RunLog.txt
echo %date% %time% >> %sql_virtual%\SQL_RunLog.txt
echo
****************************************************************************************
>> %sql_virtual%\SQL_RunLog.txt
On Thu, Jan 19, 2017 at 7:41 AM, Del Hoobler <hoobler AT us.ibm DOT com> wrote:
> Tom,
>
> Does the script capture the RC and then exit the script with that RC?
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21605132
>
>
> Thank you,
>
> Del
>
> ----------------------------------------------------
>
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/18/2017
> 05:52:05 PM:
>
> > From: Tom Alverson <tom.alverson AT GMAIL DOT COM>
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Date: 01/18/2017 05:52 PM
> > Subject: TDP SQL backup fails but is reported as a success ??
> > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> >
> > I periodically have an SQL backup fail but the scheduler reports that it
> > was a success so I never get a failure ticket (the database admin
> complains
> > about the lack of a backup). Here you can see I get the ACO5436E error
> > with RC=-50 which there is almost no hit for on an internet search. Here
> > you can see the error and the fact that only 6 of the 11 databases were
> > successful yet the scheduler has a return code of 0. This issue happens
> > intermittently on many of our SQL backups.
> >
> > Backup Log:
> > 01/17/2017 01:10:28 ANS1017E (RC-50) Session rejected: TCP/IP
> connection
> > failure.
> >
> > 01/17/2017 01:10:28 ACO5436E A failure occurred on stripe number (0), rc
> =
> > -50
> >
> > 01/17/2017 01:10:28 ANS1017E (RC-50) Session rejected: TCP/IP
> connection
> > failure.
> >
> > 01/17/2017 01:10:28 Backup of VCM failed.
> >
> > 01/17/2017 01:10:28 ANS1017E (RC-50) Session rejected: TCP/IP
> connection
> > failure.
> >
> > 01/17/2017 01:10:28 Total SQL backups selected: 11
> >
> > 01/17/2017 01:10:28 Total SQL backups attempted: 11
> >
> > 01/17/2017 01:10:28 Total SQL backups completed: 6
> >
> > 01/17/2017 01:10:28 Total SQL backups excluded: 0
> >
> > 01/17/2017 01:10:28 Total SQL backups inactivated: 0
> >
> > 01/17/2017 01:10:28 Total SQL backups deduplicated: 0
> >
> >
> >
> >
> >
> > Schedule Log:
> >
> > 01/18/2017 01:20:34
> >
> > Executing scheduled command now.
> >
> > 01/18/2017 01:20:41 Node Name: servername_SQL
> >
> > 01/18/2017 01:20:41 Session established with server storageserver: AIX
> >
> > 01/18/2017 01:20:41 Server Version 6, Release 3, Level 5.100
> >
> > 01/18/2017 01:20:41 Data compression forced off by the server
> >
> > 01/18/2017 01:20:41 Server date/time: 01/18/2017 01:20:41 Last
> access:
> > 01/18/2017 01:10:33
> >
> > 01/18/2017 01:20:42
> >
> > Executing Operating System command or script:
> >
> > C:\TSM\TDP\SQLFULL.bat
> >
> > 01/18/2017 01:40:36 Finished command. Return code is: 0
> >
> > 01/18/2017 01:40:36 ANS1908I The scheduled command completed
> successfully.
> >
> > 01/18/2017 01:40:36 Scheduled event 'TDP_1AM' completed successfully.
> >
> > 01/18/2017 01:40:36 Sending results for scheduled event 'TDP_1AM'.
> >
> > 01/18/2017 01:40:37 Results sent to server for scheduled event
> 'TDP_1AM'.
> >
>
|
|
|