Step back.we have a winner.
This is the command that worked:
Objects: sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh
No quotes, but needed the 'sh'.
No permission changes.
And the ./nzbackup worked as well
Thank you all very much!
-Original Message-
From: ADSM: Dist Stor Ma
7-12
> 16:48:07:
>
>> From: Jeanne Bruno
>> To: ADSM-L@VM.MARIST.EDU
>> Date: 2016-07-12 16:49
>> Subject: Re: need help with TSM for nz backup
>> Sent by: "ADSM: Dist Stor Manager"
>>
>> Hello. yes, the first line of the .sh file is #!/b
ote on 2016-07-12
16:48:07:
> From: Jeanne Bruno
> To: ADSM-L@VM.MARIST.EDU
> Date: 2016-07-12 16:49
> Subject: Re: need help with TSM for nz backup
> Sent by: "ADSM: Dist Stor Manager"
>
> Hello. yes, the first line of the .sh file is #!/bin/sh
>
> I will try
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
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@VM.MARIST.EDU] On Behalf Of Stef
Coene
Sent: Tuesday, July 12, 2016 4:40 PM
To: ADSM-L@VM.MARIST.EDU
Subj
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
Failed, but different RC:
Executing Operating System command or script:
"sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh"
07/12/2016 16:30:08 Finished command. Return code is: 127
07/12/2016 16:30:08 ANS1909E The scheduled command failed.
07/12/2016 16:30:08 ANS1512E Scheduled event 'NETEZZA_WKD' failed
Hello. I will try that
I read on one of the ibm tsm sites to use the single quotes.
Let me try double
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew
Raibeck
Sent: Tuesday, July 12, 2016 4:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject:
Hi Jeanne,
What are the backtick (`) and single quote (') doing that surround the
OBJECTS field? Were you using quotes?
What if you updated the schedule like this, using just regular double
quotation marks to surround the command?
upd sch netezza netezza_wkd
objects="sh /nz/kit.7.2.1.1-P1/bin
