Hi Jeannie, The "export" commands are UNIX or Linux commands, not TSM commands. The DSMI_xxxxxx environment variables are specific to TSM.
Since my earlier suggestions are not ringing any bells and I am not a Netezza expert, I think your best bet is to engage Netezza support for further assistance. Otherwise I would be concerned that in trying to help further, it could make a mess of things. Note that there is no "TDP for Netezza" as such, in the same way that there is no "TDP for DB2". Rather, Netezza is a non-TSM product that integrates its backups with TSM through the use of the TSM API. As a consumer of the API, they would best know how to troubleshoot the interaction between the Netezza commands and the API. Best regards, Andy ____________________________________________________________________________ Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.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@VM.MARIST.EDU> wrote on 2016-09-07 08:18:58: > From: Jeanne Bruno <jbr...@cenhud.com> > To: ADSM-L@VM.MARIST.EDU > Date: 2016-09-07 08:20 > Subject: Re: TDP for Netezza - nzrestore > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > Hello. Thank Andy....i'm sorta new with TDP for Netezza... > > 1. To answer your first email: Yes, the q fi & q occ are same on > our local and DR site (I call it source and target because we > replicate) for the netezza node. > > For the DSMI_DIR, DSMI_LOG and DSMI_CONFIG environment > variables....I'm not sure if I need to configure. I didn't do any > configuration on the netezza box at our local site when I was > setting up the TDP for the ./nzbackup process. > > 2. In your 2nd email, you mention to configure the environment > variables. Where am I typing (or configuring) these assignments?: > At the dsmc command prompt?? > > export DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 > > export DSMI_LOG=/opt/tivoli/tsm/client/api/bin64 > > export DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm.opt > > > > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On > Behalf Of Andrew Raibeck > Sent: Tuesday, September 06, 2016 5:08 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] TDP for Netezza - nzrestore > > > ** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / > attachments. Never supply UserID/PASSWORD information. > > > Sorry, I mentioned DSMI_LOG twice, the last one should have been DSMI_CONFIG. > > One more thing: if your Linux system has a compiler on it, you can > build the sample API application, dapismp64: > > cd /opt/tivoli/tsm/client/api/bin64/sample > make -f makesmp64.linux86 > > (your makefile name might differ if this is not a Linux x86_64 > platform, but the name will start with "makesmp") > > Then run the resulting dapismp64 tool: > > ./dapismp64 > > Select option 0 (zero), then press <ENTER> on all the questions > until it asks you if all responses are correct. For that last > question, type 'y' (without the quotes, then press <ENTER>. It might > fail, but if you get the RC 406, then you have a pattern consistent > with Netezza. The sample program is a good "smoke test" to ensure > the API is functional. > > Next, configure the environment variables: > > export DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 > > export DSMI_LOG=/opt/tivoli/tsm/client/api/bin64 > > export DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm.opt > > DSMI_DIR needs to point to the directory where dsm.sys, dsmtca, and > the en_US directory reside. The ../client/ba/bin might also have these files. > See what your local system uses. > > DSMI_LOG can point to whatever directory you want the dsierror.log to go > > DSMI_CONFIG needs to point to your dsm.opt file > > Regards, > > Andy > > ____________________________________________________________________________ > > Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.com > > IBM Tivoli Storage Manager links: > Product support: > https://urldefense.proofpoint.com/v2/url? > u=https-3A__www.ibm.com_support_entry_portal_product_tivoli_tivoli-5Fstorage-5Fmanager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=oLVwtlwVKFBigUFDj3zqWRZfcCoJzO3PNed9vG- > pGjg&s=8uZIILVMXjRlhNK5nleGVOfVY5NrH1ZZCRYlHpfjYyM&e= > > Online documentation: > https://urldefense.proofpoint.com/v2/url? > u=http-3A__www.ibm.com_support_knowledgecenter_SSGSG7_landing_welcome-5Fssgsg7.html&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=oLVwtlwVKFBigUFDj3zqWRZfcCoJzO3PNed9vG- > pGjg&s=AAluLUMrhaBnpSQwBEyv46cmF2ny066EkY5RIZwA830&e= > > Product Wiki: > https://urldefense.proofpoint.com/v2/url? > u=https-3A__www.ibm.com_developerworks_community_wikis_home_wiki_Tivoli-2520Storage-2520Manager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=oLVwtlwVKFBigUFDj3zqWRZfcCoJzO3PNed9vG- > pGjg&s=6JSUHU6uftLBmMqloq4ba006x28swtgLih--wcUgc_I&e= > > "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 2016-09-06 > 16:53:02: > > > From: Andrew Raibeck/Hartford/IBM@IBMUS > > To: ADSM-L@VM.MARIST.EDU > > Date: 2016-09-06 16:54 > > Subject: Re: TDP for Netezza - nzrestore Sent by: "ADSM: Dist Stor > > Manager" <ADSM-L@VM.MARIST.EDU> > > > > 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 | stor...@us.ibm.com > > > > IBM Tivoli Storage Manager links: > > Product support: > > > https://urldefense.proofpoint.com/v2/url? > u=https-3A__www.ibm.com_support_entry_portal_product_tivoli_tivoli-5Fstorage-5Fmanager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=oLVwtlwVKFBigUFDj3zqWRZfcCoJzO3PNed9vG- > pGjg&s=8uZIILVMXjRlhNK5nleGVOfVY5NrH1ZZCRYlHpfjYyM&e= > > > > > Online documentation: > > > https://urldefense.proofpoint.com/v2/url? > u=http-3A__www.ibm.com_support_knowledgecenter_SSGSG7_landing_welcome-5Fssgsg7.html&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=oLVwtlwVKFBigUFDj3zqWRZfcCoJzO3PNed9vG- > pGjg&s=AAluLUMrhaBnpSQwBEyv46cmF2ny066EkY5RIZwA830&e= > > > > > Product Wiki: > > https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_devel > > operworks_community_wikis_home_wiki_Tivoli-25&d=CwIFAg&c=BY0WRPt8vrhqs > > _gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhA > > NDp1mE&m=oLVwtlwVKFBigUFDj3zqWRZfcCoJzO3PNed9vG-pGjg&s=_GikSxT7zYs5fSz > > nSzh-KjXTWADKjYP46kIHKDlujPM&e= > > 20Storage%20Manager > > > > "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 2016-09-06 > > 16:02:56: > > > > > From: Jeanne Bruno <jbr...@cenhud.com> > > > To: ADSM-L@VM.MARIST.EDU > > > Date: 2016-09-06 16:07 > > > Subject: TDP for Netezza - nzrestore Sent by: "ADSM: Dist Stor > > > Manager" <ADSM-L@VM.MARIST.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 > > > jbr...@cenhud.com<mailto:jbr...@cenhud.com> > > > Central Hudson Gas & Electric > > > (845) 486-5780 > > > > > >
