topic Re: SG Question in Operating System - HP-UX

SG Question

JIJ_1 — Wed, 04 Jul 2007 04:42:51 GMT

Hi Gents,

I am in the process of configuring a 2 nodes cluster. I have two servers named ETL and EDW. When i am running cmquerycl to create the ascii template file i am speciying the ETL node first and then EDW ,but template file is getting generated with EDW server information first. After the cluster creation cmviewcl output shows EDW node first and then the ETL node as given below,

etl:/tmp#cmviewcl

CLUSTER STATUS
etl-edw up

NODE STATUS STATE
--> edw up running
--> etl up running

I was under the impression that node order in the cmviewcl output is based on the order in which nodes details are specified in the ascii template file. I have tried changing the node detials order in the ascii file and reconfigured the cluster but still getting the same cmviewcl o/p.

Is there anyway to change the order in teh cmviewcl o/p ? or is it based on alphabatic order ?

Re: SG Question

Luk Vandenbussche — Wed, 04 Jul 2007 04:55:01 GMT

Hi,

It is based on alphabetic order.

Re: SG Question

Geoff Wild — Wed, 04 Jul 2007 12:25:57 GMT

Not really - you could script something - but why?

cmviewcl |sort -rn

Rgds...Geoff

Re: SG Question

Pavol Halcin — Wed, 04 Jul 2007 14:41:24 GMT

Hi,

it doesn't matter whick node is being listed first. what matters is which node is configured as primary/alternate for each of the packages that will run in the cluster.

Re: SG Question

JIJ_1 — Wed, 04 Jul 2007 14:52:14 GMT

Yes . It is is not a problem , ultimatlely the primary node and secondary node of a package is defined in the package config file. But i am wondering the behaviour of cmquerycl command , while executing cmqurycl i am specifying etl server first and then the edw server .But still the ascii file is getting created with edw server information first.

Re: SG Question

JIJ_1 — Wed, 04 Jul 2007 14:56:53 GMT

Please note that i am running the cmquerycl command from ETL server.

Re: SG Question

Geoff Wild — Wed, 04 Jul 2007 17:39:57 GMT

Manually edit your ascii file, and re-arrange the nodes, then run your cmapplyconf.

cmquerycl just pull the data out of the binary config file - it should be based on the order from teh ascii file that was used to create it.

Rgds...Geoff

Re: SG Question

JIJ_1 — Wed, 04 Jul 2007 19:08:12 GMT

As i mentioned in my first post , this manual modification in the ascii file was already tried.

Re: SG Question

skt_skt — Wed, 04 Jul 2007 19:34:43 GMT

did you try the cmapplyconf after the modification on the cluser ascii file?

you have not confirmed about the cmapplyconf?

Re: SG Question

Naveej.K.A — Wed, 04 Jul 2007 19:36:13 GMT

Hello,

I checked the clusters we have here and it definitely doesn't look like they are based on alphabetic order. As you have observed, by changing the order in the ASCII file doesn't make any difference either.

So I think - it may be - I am not sure here, that it is taking the node which has the lock VG activated at the time of cmapplyconf as its first node in the cmviewcl. I don't have a test enviro to check it out...

Please check and let us know if it makes any difference.

Regards,
Naveej

Re: SG Question

skt_skt — Wed, 04 Jul 2007 19:36:40 GMT

did you try the cmapplyconf after the modification on the cluser ascii file?

you have not confirmed about the cmapplyconf?verify the changes with cmgetconf or cmviewconf

Re: SG Question

JIJ_1 — Thu, 05 Jul 2007 01:27:33 GMT

yes, i have already tried all these options. I have changed the node order in the ascii file and reconfigured the cluster but result is same. Even i have tried creating the cluster from the other node also. Here the cmviewconfig command o/p is showing that node 1 is ETL and node 2 is EDW , but when it comes to the o/p of cmviewcl command it is just giving the reverse way.

Re: SG Question

JIJ_1 — Thu, 05 Jul 2007 01:44:22 GMT

Hi Naveej,

That was a good suggestion , but even that also didnt work here.

Re: SG Question

Srinivas Thokala_1 — Thu, 05 Jul 2007 10:49:26 GMT

You are at cluster creation stage and I assume when you complete the package creation, export and import mapfiles on to the EDW server, the primay node ETL takes the fist position, until then it may be following alpha order.

-Srinivas