TSM inherits the return code of the command and if it is not 0 the schedule is 
reported as failed. Your script is returning 2 which according to this is all 
queries failed: 
https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_nzsql_exit_codes.html

Try running the script and run "echo $?" You will see 2. Fix the script and 
verify it runs ok.


--howard

> On 12 Jul 2016, at 22:50, Jeanne Bruno <JBruno AT CENHUD DOT COM> wrote:
> 
> Hello.  yes, the first line of the .sh file is #!/bin/sh
> 
> I will try with no quotes and no 'sh'.
> 
> Will let you know....
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Stef Coene
> Sent: Tuesday, July 12, 2016 4:40 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] need help with TSM for nz backup
> 
> 
> ** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / 
> attachments. Never supply UserID/PASSWORD information.
> 
> 
>> On 07/12/2016 10:26 PM, Jeanne Bruno wrote:
>> Hello.  I will try that....
>> I read on one of the ibm tsm sites to use the single quotes.
>> Let me try double....
> Just remove all the quotes and 'sh'.
> Just specify the script, but the first line of the script should be #!/bin/sh
> 
> 
> Stef