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'.
>