Start a Conversation

Unsolved

This post is more than 5 years old

5129

April 27th, 2013 14:00

DB2 backup using NMDA 1.2

Hi All,


We would like to configure DB2 online backup using NMDA. We have 2 node SUSE linux cluster and on that we have the DB2 installed on cluster. My query is when we try to create a New Client Configuration, should the configuration be made using individual node name or the DB cluster host name.

When i try to configure the client using DB cluster name, the backup fails with the error message " Could not locate the NSR client resource" But when i try to configure the backup using the active node hostname, the backup is running.

Kindly suggest what should be the best practice since we have to start the production DB backup asap.

Thanks in Advance

Regards,

Pratik.

2 Intern

 • 

14.3K Posts

April 27th, 2013 15:00

Is it that you get this message when

a) you try to create NSR client with virtual name, or

b) when you try backup using virtual name

What you said seems to indicate a), but error seems to indicate b).  To make it more complicated, I believe SuSE cluster might not be supported which might require some manual work to make it work (eg. setting up lcmap file).  With lcmap file in place, NW will know which name (virtual name) is cluster and which paths belong to it.  With that in place, create client called in a way to reflect virtual host (do not forget to add physical nodes to remote access list) and off you go.

73 Posts

April 28th, 2013 02:00

Hi All,

Can anyone help me out with how the client configuration should be done for meeting the below requirement:

· Application & DB Cluster environment on SUSE Linux for SAP with the application on one node and the database on the other node….Both are capable of failover on to the other node if any node goes down..

· Weekly Full Backup (Sunday) and Daily Incremental Backup to be taken for the DB2 database which is in DB cluster.

· Virtual hostname 1 is used for application cluster and Virtual hostname 2 is used for database cluster.

When I try to configure the NSR client resource with the virtual hostname 2, the backup is failing with the error message:

“72580:nsrdasv: The NSR Client resource for the < > could not be located.”

But when I try to take backup using the active node hostname, the backup is completing successfully but even after selecting the schedule as Weekly Full & Daily Incremental, daily full backups are only happening.

Kindly suggest the best possible configuration to be done so as to meet the above mentioned requirements.

Please do the needful on priority.

Thanks in Advance….

Regards,

Pratik

From: Pratik Uttam Vengurlekar (WI01 - GIS)

Sent: Sunday, April 28, 2013 2:30 PM

To: 'jive-1906950154-4l6f-2-fm0n@emc-ecn.hosted.jivesoftware.com'

Subject: RE: New message: "DB2 backup using NMDA 1.2"

Hi,

I created the NSR client resource with the virtual name and the error message comes when the backup is fired. Also, I tried adding both the physical nodes hostname in the remote access list but still the backup fails with the below error message:

“72580:nsrdasv: The NSR Client resource for the < > could not be located.”

One more thing I wanted to ask his I have selected the backup schedule as Weekly Full & Daily Incremental….still the backup is happening FULL only daily even though showing the level as incr.

Kindly suggest on this at the earliest.

Regards,

Pratik

73 Posts

April 28th, 2013 02:00

Hi,

I created the NSR client resource with the virtual name and the error message comes when the backup is fired. Also, I tried adding both the physical nodes hostname in the remote access list but still the backup fails with the below error message:

“72580:nsrdasv: The NSR Client resource for the < > could not be located.”

One more thing I wanted to ask his I have selected the backup schedule as Weekly Full & Daily Incremental….still the backup is happening FULL only daily even though showing the level as incr.

Kindly suggest on this at the earliest.

Regards,

Pratik

2 Intern

 • 

14.3K Posts

April 28th, 2013 08:00

I think the cause here is that suse cluster is not officially supported (at least it was not in the past) so NW client is not cluster aware.  Long time ago, there was easy way out as you could just set lcmap file - you can see manual for lcmap for correct format. And for NW to check that file, you will need to instruct it that it is running in cluster (I believe on Linux you will need to touch /usr/sbin/NetWorker.clustersvr).  Once this is done, assuming your NSR client configuration is correct, it should work just fine.  I would suggest to test first client initiated backup before you move on to server initiated one.

73 Posts

April 28th, 2013 23:00

Hi Hrvoje,

Do you mean to say that the NW is not supported on SUSE Cluster Environment ?

Also, can you plz tell me where is this lcmap file located or how can that be created ?


2 Intern

 • 

14.3K Posts

April 29th, 2013 02:00

I'm quite sure it is supported, but not tested, but I could be wrong.  You should rely on official statements and those you can find in software compatibility guide.  lcmap is always in directory where NW binaries are (eg. /usr/sbin in your case I believe).

73 Posts

April 29th, 2013 02:00

Yes...there is a file in /usr/sbin by the name lcmap.ncs.

But unfortunately i am not able to understand any of the parameters under it..:(

So not understanding what parameters should be set for the cluster to work..

Also, as per the NW compatibility guide, the nmda is supporting db2 active passive cluster environment.

Could you please help me out with what parameters should be set in lcmap.ncs ? Attaching the lcmap.ncs file also FYR.

1 Attachment

2 Intern

 • 

14.3K Posts

April 29th, 2013 03:00

You should create lcmap file and inner structure should be the same as outlined in manual (see man lcmap).  Unless you are sure in what you are doing at this point, I would suggest to engage official support as you don't wish to end up with unsupported or wrongly configured environment.

73 Posts

April 29th, 2013 04:00

I have already logged a S2 severity call with EMC support but unfortunately none of them is updating on the same.

Regards,

Pratik Vengurlekar

2 Intern

 • 

14.3K Posts

April 29th, 2013 13:00

holyboy1989 wrote:

I have already logged a S2 severity call with EMC support but unfortunately none of them is updating on the same.

They are waiting for this thread to give solution

Well, if it is not on compatibility list (check clusters first), then you know this may not be supported, but it only mean that it is not tested 99% of the time.  I would say that quickly verifying this with lcmap file would do the trick - it' easy and inexpensive way of configuring things.  Usually, NW will use script based autodiscovery where it probe cluster software to see which cluster controlled volumes are there - this is helpful when you add new things to equation so you don't have to worry about those being manually added (think of save set All).  So, with manually set lcmap file you have to also manually maintain it.

Now, if we consider worst case scenario, that there is big and fat no from EMC for whatever reason, you can still do it in a what you did it before - via physical node.  And by setting NSR_CLIENT to whatever you want, you can rule out where index will be written (though this is not elegant and certainly not workable in certain conditions). 

Bottom line is - test it. If you can't do it, let support guy do webex and do it for you - it takes couple of minutes to set it up and do quick test on something small.  If you verify both backup and restore to work with lcmap as I suggested, do not forget to ask EMC qualifier - this will qualify solution at your site and make it officially supported by support (this is to avoid those 1st line support folks who check compatibility first and ask all sorts of logs on the system just to avoid real technical work).

No Events found!

Top