Hi Jeannie,

As you've surmised, the RC 406 means that the options file cannot be found.
I do not know the Netezza code, so I do not know how to configure Netezza
for use with TSM.

You mentioned you are able to run a series of commands like "dsmc q fi" and
"dsmc q occ". Is this at your local site? Or at the DR site? If these
commands work at the DR site, then it would seem that fundamentally the TSM
client installation is sound.

Does Netezza have any special configuration requirements? For example, does
it require you to configure DSMI_DIR, DSMI_LOG and DSMI_LOG environment
variables, or is it supposed to handle that setup for you?

Best regards,

Andy

____________________________________________________________________________

Andrew Raibeck | IBM Spectrum Protect Level 3 | storman AT us.ibm DOT com

IBM Tivoli Storage Manager links:
Product support:
https://www.ibm.com/support/entry/portal/product/tivoli/tivoli_storage_manager

Online documentation:
http://www.ibm.com/support/knowledgecenter/SSGSG7/landing/welcome_ssgsg7.html

Product Wiki:
https://www.ibm.com/developerworks/community/wikis/home/wiki/Tivoli%20Storage%20Manager

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2016-09-06
16:02:56:

> From: Jeanne Bruno <JBruno AT CENHUD DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 2016-09-06 16:07
> Subject: TDP for Netezza  - nzrestore
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Hello.   Was wondering if anyone has seen this one.
>
> Back story:
> We have a Netezza server (linux OS) and we've been using TDP backup
> commands similar to this:
> ./nzbackup -u xxxxxxx -pw xxxxxxxx -db  TESTDB   -connector Tivoli -
> connectorArgs "TSM_PASSWD=XXXXXXXXXXX"
>
> We defined a proxy node and did the grant.....
>
> And this has been working great...the backups go directly to the
> storage pool we have designated for Netezza.
>
> We also replicate our TSM backups to our DR site via TCP and this
> works great too.
> I have a node of the same name registered on the TSM DR site server
> with a proxy node as well.
>
> When I do a 'q fi netezza' and 'q occ netezza' on both the source
> and target TSM servers....they match.
>
> Issue:
> Restore using the node in the DR site.
> I'm using Putty to get to the linux command line and trying to do a
> nzrestore command from the node of the same name <netezza> .
>
> I started out with this command because I just want to see what
> backup sets I have:
> ./nzrestore -connector Tivoli -connectorArgs "TSM_PASSWD=xxxxxxxxx"
> -sourcedb TESTDB -incrementlist -u XXXXXXXX -pw XXXXXXX
>
> I'm getting:
> Error:  connector init failed: 'ANS1035S (RC406) Options file "*'
> could not be found or it cannot be read.
>
> I've googled and looked for all the obvious; yes the dsm.opt &
> dsm.sys files are there.  And permissions are there for the files
> too.   But it seems to me with the message 'Connector init failed'
> it doesn't even know where to look for the .opt or .sys files.
> Could my proxy node be incorrect???
>
> Any info would be helpful.  Much appreciated.
>
>
> ____________________
> Jeannie Bruno
> Senior Systems Analyst
> jbruno AT cenhud DOT com<mailto:jbruno AT cenhud DOT com>
> Central Hudson Gas & Electric
> (845) 486-5780
>