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 | 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-07
08:18:58:
> From: Jeanne Bruno <JBruno AT CENHUD DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 2016-09-07 08:20
> Subject: Re: TDP for Netezza - nzrestore
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On
> Behalf Of Andrew Raibeck
> Sent: Tuesday, September 06, 2016 5:08 PM
> To: ADSM-L AT VM.MARIST DOT 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 | storman AT us.ibm DOT 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 AT VM.MARIST DOT EDU> wrote on 2016-09-06
> 16:53:02:
>
> > From: Andrew Raibeck/Hartford/IBM@IBMUS
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Date: 2016-09-06 16:54
> > Subject: Re: TDP for Netezza - nzrestore Sent by: "ADSM: Dist Stor
> > Manager" <ADSM-L AT VM.MARIST DOT 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 | storman AT us.ibm DOT 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 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
> > >
> >
>
|
