Re: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Gunnar Tapper 
OK. Then, it'll not be covered in the upcoming admin guide.

On Tue, Mar 15, 2016 at 2:05 PM, Sean Broeder 
wrote:

> I think the concept of a warm start is a carryover from early SeaQuest
> days.  A warm start was proposed to maintain some monitor and TM states,
> but it never was fully implemented.
>
>
>
> Regards,
>
> Sean
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *Sent:* Tuesday, March 15, 2016 10:03 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* 答复: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The purpose I guess is to bypass time-consuming database recovery if it is
> a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
> restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
> start. But I think this is just the concept. May not support yet? We
> studied the two gomon scripts, seems identical except some minor difference.
>
>
>
> And Narendra is correct, I misunderstand the startup code. It is possible.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com
> ]
> *发送时间:* 2016年3月16日 0:36
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
> wrote:
>
> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dum

RE: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Sean Broeder 
I think the concept of a warm start is a carryover from early SeaQuest
days.  A warm start was proposed to maintain some monitor and TM states,
but it never was fully implemented.



Regards,

Sean



*From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
*Sent:* Tuesday, March 15, 2016 10:03 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* 答复: 答复: Anyway to start Trafodion without sqstart



The purpose I guess is to bypass time-consuming database recovery if it is
a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
start. But I think this is just the concept. May not support yet? We
studied the two gomon scripts, seems identical except some minor difference.



And Narendra is correct, I misunderstand the startup code. It is possible.



Thanks,

Ming



*发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com
]
*发送时间:* 2016年3月16日 0:36
*收件人:* user@trafodion.incubator.apache.org
*主题:* Re: 答复: Anyway to start Trafodion without sqstart



BTW, in what cases should gomon.warm or the sqstart warm argument be used?



Thanks,



Gunnar



On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
wrote:

Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
Selva mentioned)) to startup without sqstart.



As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
some other checks (like checks for orphan processes), and cleans up IPC
constructs (semaphores, queues, shared memory) via sqipcrm.



Thanks,

-Narendra



*From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
*Sent:* Tuesday, March 15, 2016 8:10 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: 答复: Anyway to start Trafodion without sqstart



The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.



I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.



DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.



Gunnar



On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming)  wrote:

>From my understanding, it is invalid to start trafodion on node by node
mode. Monitor simulate a single image of operating system from a bunch of
nodes. One process can be configured to be a pair: active and standby. So
when start a trafodion process, it will start two processes on two nodes.
It is hard to start a single node.

Is there any use case to do so?



Thanks,

Ming



*发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
*发送时间**:* 2016年3月15日 22:27
*收件人**:* user@trafodion.incubator.apache.org
*主**题**:* RE: Anyway to start Trafodion without sqstart



Yes.  The sqgen command takes in the configuration file for the trafodion
cluster and generates gomon.cold, gomon.warm and other relevant scripts.
These generated scripts are copied to all nodes in the cluster. These
scripts are nothing but the commands to sqshell. sqstart uses either
gomon.cold or gomon.warm to start the Trafodion instance.



Selva



*From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
*Sent:* Monday, March 14, 2016 10:03 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Anyway to start Trafodion without sqstart



DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.



I think the rest is a matter of using sqshell:



[centos@trafodion incubator-trafodion]$ sqshell

Processing cluster.conf on local host trafodion.novalocal

[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)

[SHELL] %help

[SHELL] usage: shell {[-a|-i] []} | {-c }

[SHELL] - commands:

[SHELL] -- Command line environment variable replacement: ${}

[SHELL] -- ! comment statement

[SHELL] -- cd 

[SHELL] -- delay 

[SHELL] -- down  [, ]

[SHELL] -- dump [{path }]  | 

[SHELL] -- echo []

[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
event-data] ]

[SHELL] -- exec [{[debug][nowait][pri ][name ]

[SHELL]   [nid ][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]

[SHELL] --[in |#default][out |#default]}] path
[[]...]

[SHELL] -- exit [!]

[SHELL] -- help

[SHELL] -- kill [{abort}]  | 

[SHELL] -- ldpath [[,]...]

[SHELL] -- ls [{[detail]}] []

[SHELL] -- measure | measure_cpu

[SHELL] -- monstats

[SHELL] -- node [info []]

[SHELL] -- path [[,]...]

[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]

[SHELL] -- pwd

[SHELL] -- quit

[SHELL] -- scanbufs

[SHELL] -- set [{[nid ]|[process ]}] key=

[SHELL] -- show [{[nid ]|[process ]}] [key]

[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]

[SHELL] -- startup [trace] []

[SHELL] -- suspend []

[SHELL] -- time 

[SHELL] -- trace 

[SHELL] -- up 

[SHELL] -- wait [ | ]

[SHELL] -- warmstart [trace] []

[SHELL]

Re: 答复: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Gunnar Tapper 
>From what I understand, this will not work. What you need to do is to do
what gomon.cold does; that is, interact with sqshell telling it what you
want done.

On Tue, Mar 15, 2016 at 11:31 AM, Amanda Moran 
wrote:

> Hi there All-
>
> So this is what is suggested to be able to start Trafodion on each node
> individually:
>
> Run sqgen on each node.
>
> Create a new script that would be ran on each node (probably just a
> wrapper) that calls gomon.cold.
>
> How will this work for processes that are one per cluster, like the
> monitor?
>
> Thanks!
>
> On Tue, Mar 15, 2016 at 10:02 AM, Liu, Ming (Ming) 
> wrote:
>
>> The purpose I guess is to bypass time-consuming database recovery if it
>> is a warm start. Say, if you have a clean shutdown of Trafodion, you can
>> warm restart it. If one use ‘ckillall’, or simply loss power, one needs a
>> cold start. But I think this is just the concept. May not support yet? We
>> studied the two gomon scripts, seems identical except some minor difference.
>>
>>
>>
>> And Narendra is correct, I misunderstand the startup code. It is possible.
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *发送时间:* 2016年3月16日 0:36
>> *收件人:* user@trafodion.incubator.apache.org
>> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>>
>>
>>
>> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <
>> narendra.go...@esgyn.com> wrote:
>>
>> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
>> Selva mentioned)) to startup without sqstart.
>>
>>
>>
>> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
>> some other checks (like checks for orphan processes), and cleans up IPC
>> constructs (semaphores, queues, shared memory) via sqipcrm.
>>
>>
>>
>> Thanks,
>>
>> -Narendra
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *Sent:* Tuesday, March 15, 2016 8:10 AM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>>
>>
>>
>> The use case is how Apache Ambari works: it assume node-by-node
>> management of services. This is how you achieve rolling upgrades, stopping
>> all services on a node, etc.
>>
>>
>>
>> I wonder if it's possible to first start the monitor (using the startup
>> command) and then start/stop other components per node. Kind of a hybrid
>> model.
>>
>>
>>
>> DCS/REST should already support this use case since it's based on the
>> HBase model where the scripts start daemons on each configured node.
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
>> wrote:
>>
>> From my understanding, it is invalid to start trafodion on node by node
>> mode. Monitor simulate a single image of operating system from a bunch of
>> nodes. One process can be configured to be a pair: active and standby. So
>> when start a trafodion process, it will start two processes on two nodes.
>> It is hard to start a single node.
>>
>> Is there any use case to do so?
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
>> *发送时间**:* 2016年3月15日 22:27
>> *收件人**:* user@trafodion.incubator.apache.org
>> *主**题**:* RE: Anyway to start Trafodion without sqstart
>>
>>
>>
>> Yes.  The sqgen command takes in the configuration file for the trafodion
>> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
>> These generated scripts are copied to all nodes in the cluster. These
>> scripts are nothing but the commands to sqshell. sqstart uses either
>> gomon.cold or gomon.warm to start the Trafodion instance.
>>
>>
>>
>> Selva
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *Sent:* Monday, March 14, 2016 10:03 PM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: Anyway to start Trafodion without sqstart
>>
>>
>>
>> DCS and REST follow the HBase model so that should be a simple matter of
>> invoking the *-daemon.sh scripts.
>>
>>
>>

Re: 答复: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Amanda Moran 
Hi there All-

So this is what is suggested to be able to start Trafodion on each node
individually:

Run sqgen on each node.

Create a new script that would be ran on each node (probably just a
wrapper) that calls gomon.cold.

How will this work for processes that are one per cluster, like the
monitor?

Thanks!

On Tue, Mar 15, 2016 at 10:02 AM, Liu, Ming (Ming) 
wrote:

> The purpose I guess is to bypass time-consuming database recovery if it is
> a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
> restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
> start. But I think this is just the concept. May not support yet? We
> studied the two gomon scripts, seems identical except some minor difference.
>
>
>
> And Narendra is correct, I misunderstand the startup code. It is possible.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间:* 2016年3月16日 0:36
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
> wrote:
>
> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dump [{path }]  | 
>
> [SHELL] -- echo []
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri ][name ]
>
> [SHELL]   [nid ][type
> {AMP|A

答复: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Liu, Ming (Ming) 
The purpose I guess is to bypass time-consuming database recovery if it is a 
warm start. Say, if you have a clean shutdown of Trafodion, you can warm 
restart it. If one use ‘ckillall’, or simply loss power, one needs a cold 
start. But I think this is just the concept. May not support yet? We studied 
the two gomon scripts, seems identical except some minor difference.

And Narendra is correct, I misunderstand the startup code. It is possible.

Thanks,
Ming

发件人: Gunnar Tapper [mailto:tapper.gun...@gmail.com]
发送时间: 2016年3月16日 0:36
收件人: user@trafodion.incubator.apache.org
主题: Re: 答复: Anyway to start Trafodion without sqstart

BTW, in what cases should gomon.warm or the sqstart warm argument be used?

Thanks,

Gunnar

On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
mailto:narendra.go...@esgyn.com>> wrote:
Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what Selva 
mentioned)) to startup without sqstart.

As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does some 
other checks (like checks for orphan processes), and cleans up IPC constructs 
(semaphores, queues, shared memory) via sqipcrm.

Thanks,
-Narendra

From: Gunnar Tapper 
[mailto:tapper.gun...@gmail.com<mailto:tapper.gun...@gmail.com>]
Sent: Tuesday, March 15, 2016 8:10 AM
To: 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: Re: 答复: Anyway to start Trafodion without sqstart

The use case is how Apache Ambari works: it assume node-by-node management of 
services. This is how you achieve rolling upgrades, stopping all services on a 
node, etc.

I wonder if it's possible to first start the monitor (using the startup 
command) and then start/stop other components per node. Kind of a hybrid model.

DCS/REST should already support this use case since it's based on the HBase 
model where the scripts start daemons on each configured node.

Gunnar

On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
mailto:ming@esgyn.cn>> wrote:
From my understanding, it is invalid to start trafodion on node by node mode. 
Monitor simulate a single image of operating system from a bunch of nodes. One 
process can be configured to be a pair: active and standby. So when start a 
trafodion process, it will start two processes on two nodes. It is hard to 
start a single node.
Is there any use case to do so?

Thanks,
Ming

发件人: Selva Govindarajan 
[mailto:selva.govindara...@esgyn.com<mailto:selva.govindara...@esgyn.com>]
发送时间: 2016年3月15日 22:27
收件人: 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
主题: RE: Anyway to start Trafodion without sqstart

Yes.  The sqgen command takes in the configuration file for the trafodion 
cluster and generates gomon.cold, gomon.warm and other relevant scripts. These 
generated scripts are copied to all nodes in the cluster. These scripts are 
nothing but the commands to sqshell. sqstart uses either gomon.cold or 
gomon.warm to start the Trafodion instance.

Selva

From: Gunnar Tapper 
[mailto:tapper.gun...@gmail.com<mailto:tapper.gun...@gmail.com>]
Sent: Monday, March 14, 2016 10:03 PM
To: 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: Re: Anyway to start Trafodion without sqstart

DCS and REST follow the HBase model so that should be a simple matter of 
invoking the *-daemon.sh scripts.

I think the rest is a matter of using sqshell:

[centos@trafodion incubator-trafodion]$ sqshell
Processing cluster.conf on local host trafodion.novalocal
[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build debug 
[centos], date 11Mar16)
[SHELL] %help
[SHELL] usage: shell {[-a|-i] []} | {-c }
[SHELL] - commands:
[SHELL] -- Command line environment variable replacement: ${}
[SHELL] -- ! comment statement
[SHELL] -- cd 
[SHELL] -- delay 
[SHELL] -- down  [, ]
[SHELL] -- dump [{path }]  | 
[SHELL] -- echo []
[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [ 
event-data] ]
[SHELL] -- exec [{[debug][nowait][pri ][name ]
[SHELL]   [nid ][type 
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
[SHELL] --[in |#default][out |#default]}] path [[]...]
[SHELL] -- exit [!]
[SHELL] -- help
[SHELL] -- kill [{abort}]  | 
[SHELL] -- ldpath [[,]...]
[SHELL] -- ls [{[detail]}] []
[SHELL] -- measure | measure_cpu
[SHELL] -- monstats
[SHELL] -- node [info []]
[SHELL] -- path [[,]...]
[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
[SHELL] -- pwd
[SHELL] -- quit
[SHELL] -- scanbufs
[SHELL] -- set [{[nid ]|[process ]}] key=
[SHELL] -- show [{[nid ]|[process ]}] [key]
[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
[SHELL] -- startup [trace] []
[SHELL] -- suspend []
[SHELL] -- time 
[SHELL] -- trace 
[SHELL] -- up 
[SHELL] -- wait [ | ]
[SHELL] -- warmstart [trace] []
[SHELL] -- zone [nid |zid ]
[

Obviously, you can up/down nodes but I don't know how that works in 
relationship to the startup command.

On Mon, Mar 14, 2016 at 11:52 AM

Re: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Gunnar Tapper 
BTW, in what cases should gomon.warm or the sqstart warm argument be used?

Thanks,

Gunnar

On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
wrote:

> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dump [{path }]  | 
>
> [SHELL] -- echo []
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri ][name ]
>
> [SHELL]   [nid ][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --[in |#default][out |#default]}] path
> [[]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}]  | 
>
> [SHELL] -- ldpath [[,]...]
>
> [SHELL] -- ls [{[detail]}] []
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info []]
>
> [SHELL] -- path [[,]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid ]|[process ]}] key=
>
> [SHELL] -- show [{[nid ]|[process ]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] []
>
> [SHELL] -- suspend []
>
> [SHELL] -- time 
>
> [SHELL] -- trace 
>
> [SHELL] -- up 
>
> [SHELL] -- wait [ | ]
>
> [SHELL] -- warmstart [trace] []
>
> [SHELL] -- zone [nid |zid ]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

RE: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Narendra Goyal 
Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
Selva mentioned)) to startup without sqstart.



As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
some other checks (like checks for orphan processes), and cleans up IPC
constructs (semaphores, queues, shared memory) via sqipcrm.



Thanks,

-Narendra



*From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
*Sent:* Tuesday, March 15, 2016 8:10 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: 答复: Anyway to start Trafodion without sqstart



The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.



I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.



DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.



Gunnar



On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming)  wrote:

>From my understanding, it is invalid to start trafodion on node by node
mode. Monitor simulate a single image of operating system from a bunch of
nodes. One process can be configured to be a pair: active and standby. So
when start a trafodion process, it will start two processes on two nodes.
It is hard to start a single node.

Is there any use case to do so?



Thanks,

Ming



*发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
*发送时间**:* 2016年3月15日 22:27
*收件人**:* user@trafodion.incubator.apache.org
*主**题**:* RE: Anyway to start Trafodion without sqstart



Yes.  The sqgen command takes in the configuration file for the trafodion
cluster and generates gomon.cold, gomon.warm and other relevant scripts.
These generated scripts are copied to all nodes in the cluster. These
scripts are nothing but the commands to sqshell. sqstart uses either
gomon.cold or gomon.warm to start the Trafodion instance.



Selva



*From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
*Sent:* Monday, March 14, 2016 10:03 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Anyway to start Trafodion without sqstart



DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.



I think the rest is a matter of using sqshell:



[centos@trafodion incubator-trafodion]$ sqshell

Processing cluster.conf on local host trafodion.novalocal

[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)

[SHELL] %help

[SHELL] usage: shell {[-a|-i] []} | {-c }

[SHELL] - commands:

[SHELL] -- Command line environment variable replacement: ${}

[SHELL] -- ! comment statement

[SHELL] -- cd 

[SHELL] -- delay 

[SHELL] -- down  [, ]

[SHELL] -- dump [{path }]  | 

[SHELL] -- echo []

[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
event-data] ]

[SHELL] -- exec [{[debug][nowait][pri ][name ]

[SHELL]   [nid ][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]

[SHELL] --[in |#default][out |#default]}] path
[[]...]

[SHELL] -- exit [!]

[SHELL] -- help

[SHELL] -- kill [{abort}]  | 

[SHELL] -- ldpath [[,]...]

[SHELL] -- ls [{[detail]}] []

[SHELL] -- measure | measure_cpu

[SHELL] -- monstats

[SHELL] -- node [info []]

[SHELL] -- path [[,]...]

[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]

[SHELL] -- pwd

[SHELL] -- quit

[SHELL] -- scanbufs

[SHELL] -- set [{[nid ]|[process ]}] key=

[SHELL] -- show [{[nid ]|[process ]}] [key]

[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]

[SHELL] -- startup [trace] []

[SHELL] -- suspend []

[SHELL] -- time 

[SHELL] -- trace 

[SHELL] -- up 

[SHELL] -- wait [ | ]

[SHELL] -- warmstart [trace] []

[SHELL] -- zone [nid |zid ]

[



Obviously, you can up/down nodes but I don't know how that works in
relationship to the startup command.



On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
wrote:

Hi there-



Is there a way to start up Trafodion not by using sqstart...? I would like
to be able to start up/stop each node individually.



Thanks!



-- 

Thanks,



Amanda Moran





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*

Re: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Gunnar Tapper 
The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.

I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.

DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.

Gunnar

On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming)  wrote:

> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间:* 2016年3月15日 22:27
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dump [{path }]  | 
>
> [SHELL] -- echo []
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri ][name ]
>
> [SHELL]   [nid ][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --[in |#default][out |#default]}] path
> [[]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}]  | 
>
> [SHELL] -- ldpath [[,]...]
>
> [SHELL] -- ls [{[detail]}] []
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info []]
>
> [SHELL] -- path [[,]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid ]|[process ]}] key=
>
> [SHELL] -- show [{[nid ]|[process ]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] []
>
> [SHELL] -- suspend []
>
> [SHELL] -- time 
>
> [SHELL] -- trace 
>
> [SHELL] -- up 
>
> [SHELL] -- wait [ | ]
>
> [SHELL] -- warmstart [trace] []
>
> [SHELL] -- zone [nid |zid ]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Liu, Ming (Ming) 
From my understanding, it is invalid to start trafodion on node by node mode. 
Monitor simulate a single image of operating system from a bunch of nodes. One 
process can be configured to be a pair: active and standby. So when start a 
trafodion process, it will start two processes on two nodes. It is hard to 
start a single node.
Is there any use case to do so?

Thanks,
Ming

发件人: Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
发送时间: 2016年3月15日 22:27
收件人: user@trafodion.incubator.apache.org
主题: RE: Anyway to start Trafodion without sqstart

Yes.  The sqgen command takes in the configuration file for the trafodion 
cluster and generates gomon.cold, gomon.warm and other relevant scripts. These 
generated scripts are copied to all nodes in the cluster. These scripts are 
nothing but the commands to sqshell. sqstart uses either gomon.cold or 
gomon.warm to start the Trafodion instance.

Selva

From: Gunnar Tapper 
[mailto:tapper.gun...@gmail.com]
Sent: Monday, March 14, 2016 10:03 PM
To: 
user@trafodion.incubator.apache.org
Subject: Re: Anyway to start Trafodion without sqstart

DCS and REST follow the HBase model so that should be a simple matter of 
invoking the *-daemon.sh scripts.

I think the rest is a matter of using sqshell:

[centos@trafodion incubator-trafodion]$ sqshell
Processing cluster.conf on local host trafodion.novalocal
[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build debug 
[centos], date 11Mar16)
[SHELL] %help
[SHELL] usage: shell {[-a|-i] []} | {-c }
[SHELL] - commands:
[SHELL] -- Command line environment variable replacement: ${}
[SHELL] -- ! comment statement
[SHELL] -- cd 
[SHELL] -- delay 
[SHELL] -- down  [, ]
[SHELL] -- dump [{path }]  | 
[SHELL] -- echo []
[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [ 
event-data] ]
[SHELL] -- exec [{[debug][nowait][pri ][name ]
[SHELL]   [nid ][type 
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
[SHELL] --[in |#default][out |#default]}] path [[]...]
[SHELL] -- exit [!]
[SHELL] -- help
[SHELL] -- kill [{abort}]  | 
[SHELL] -- ldpath [[,]...]
[SHELL] -- ls [{[detail]}] []
[SHELL] -- measure | measure_cpu
[SHELL] -- monstats
[SHELL] -- node [info []]
[SHELL] -- path [[,]...]
[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
[SHELL] -- pwd
[SHELL] -- quit
[SHELL] -- scanbufs
[SHELL] -- set [{[nid ]|[process ]}] key=
[SHELL] -- show [{[nid ]|[process ]}] [key]
[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
[SHELL] -- startup [trace] []
[SHELL] -- suspend []
[SHELL] -- time 
[SHELL] -- trace 
[SHELL] -- up 
[SHELL] -- wait [ | ]
[SHELL] -- warmstart [trace] []
[SHELL] -- zone [nid |zid ]
[

Obviously, you can up/down nodes but I don't know how that works in 
relationship to the startup command.

On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
mailto:amanda.mo...@esgyn.com>> wrote:
Hi there-

Is there a way to start up Trafodion not by using sqstart...? I would like to 
be able to start up/stop each node individually.

Thanks!

--
Thanks,

Amanda Moran



--
Thanks,

Gunnar
If you think you can you can, if you think you can't you're right.