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
> >
>
|