You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by "Liu, Yuan (Yuan)" <yu...@esgyn.cn> on 2017/11/16 09:58:02 UTC
About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
RE: About sqgen
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
That's a good idea, thank you.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 11:31 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Yes, that's a possibility if you have an idea what you would like to test for. You might gain support to add an option to sqstart that automatically triggers sqgen.
If this is something you'd like to pursue, I'd suggest creating a JIRA so it can be discussed and tracked.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 7:27 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Thanks Sean.
Maybe we can add sqgen into sqstart with a judgment, For example, If [ ... ] then sqgen; fi
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 10:31 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
In a development environment, sqgen is frequently required when you pull new software that has some new feature set, but not always.
Running sqgen as part of sqstart would slow the start down and is probably unwanted in cases where a simple restart is wanted. I don't often run on a real cluster, so my experience there is limited, but I would think a simple way to achieve what you are suggesting without changing it for everyone is either executing the two commands with a semicolon separating them or to create an alias.
Others may have additional input.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 4:47 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Sean,
Thanks a lot for your answer. Now I know that we need to rerun sqgen when we change sqconfig, any other cases that we also need to rerun sqgen?
Also, is is possible that we make sqgen as part of sqstart? Because sometimes we might forget to rerun sqgen because it is a separate part for sqstart.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 7:24 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
答复: About sqgen
Posted by "Liu, Lei" <le...@esgyn.cn>.
+1
-----邮件原件-----
发件人: Sean Broeder [mailto:sean.broeder@esgyn.com]
发送时间: 2017年11月17日 11:31
收件人: dev@trafodion.incubator.apache.org
主题: RE: About sqgen
Yes, that's a possibility if you have an idea what you would like to test for. You might gain support to add an option to sqstart that automatically triggers sqgen.
If this is something you'd like to pursue, I'd suggest creating a JIRA so it can be discussed and tracked.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 7:27 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Thanks Sean.
Maybe we can add sqgen into sqstart with a judgment, For example, If [ ... ] then sqgen; fi
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 10:31 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
In a development environment, sqgen is frequently required when you pull new software that has some new feature set, but not always.
Running sqgen as part of sqstart would slow the start down and is probably unwanted in cases where a simple restart is wanted. I don't often run on a real cluster, so my experience there is limited, but I would think a simple way to achieve what you are suggesting without changing it for everyone is either executing the two commands with a semicolon separating them or to create an alias.
Others may have additional input.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 4:47 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Sean,
Thanks a lot for your answer. Now I know that we need to rerun sqgen when we change sqconfig, any other cases that we also need to rerun sqgen?
Also, is is possible that we make sqgen as part of sqstart? Because sometimes we might forget to rerun sqgen because it is a separate part for sqstart.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 7:24 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
RE: About sqgen
Posted by Sean Broeder <se...@esgyn.com>.
Yes, that's a possibility if you have an idea what you would like to test for. You might gain support to add an option to sqstart that automatically triggers sqgen.
If this is something you'd like to pursue, I'd suggest creating a JIRA so it can be discussed and tracked.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 7:27 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Thanks Sean.
Maybe we can add sqgen into sqstart with a judgment,
For example,
If [ ... ] then
sqgen;
fi
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 10:31 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
In a development environment, sqgen is frequently required when you pull new software that has some new feature set, but not always.
Running sqgen as part of sqstart would slow the start down and is probably unwanted in cases where a simple restart is wanted. I don't often run on a real cluster, so my experience there is limited, but I would think a simple way to achieve what you are suggesting without changing it for everyone is either executing the two commands with a semicolon separating them or to create an alias.
Others may have additional input.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 4:47 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Sean,
Thanks a lot for your answer. Now I know that we need to rerun sqgen when we change sqconfig, any other cases that we also need to rerun sqgen?
Also, is is possible that we make sqgen as part of sqstart? Because sometimes we might forget to rerun sqgen because it is a separate part for sqstart.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 7:24 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
RE: About sqgen
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
Thanks Sean.
Maybe we can add sqgen into sqstart with a judgment,
For example,
If [ ... ] then
sqgen;
fi
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 10:31 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
In a development environment, sqgen is frequently required when you pull new software that has some new feature set, but not always.
Running sqgen as part of sqstart would slow the start down and is probably unwanted in cases where a simple restart is wanted. I don't often run on a real cluster, so my experience there is limited, but I would think a simple way to achieve what you are suggesting without changing it for everyone is either executing the two commands with a semicolon separating them or to create an alias.
Others may have additional input.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 4:47 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Sean,
Thanks a lot for your answer. Now I know that we need to rerun sqgen when we change sqconfig, any other cases that we also need to rerun sqgen?
Also, is is possible that we make sqgen as part of sqstart? Because sometimes we might forget to rerun sqgen because it is a separate part for sqstart.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 7:24 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
RE: About sqgen
Posted by Sean Broeder <se...@esgyn.com>.
In a development environment, sqgen is frequently required when you pull new software that has some new feature set, but not always.
Running sqgen as part of sqstart would slow the start down and is probably unwanted in cases where a simple restart is wanted. I don't often run on a real cluster, so my experience there is limited, but I would think a simple way to achieve what you are suggesting without changing it for everyone is either executing the two commands with a semicolon separating them or to create an alias.
Others may have additional input.
Thanks,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 4:47 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Sean,
Thanks a lot for your answer. Now I know that we need to rerun sqgen when we change sqconfig, any other cases that we also need to rerun sqgen?
Also, is is possible that we make sqgen as part of sqstart? Because sometimes we might forget to rerun sqgen because it is a separate part for sqstart.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 7:24 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
RE: About sqgen
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
Hi Sean,
Thanks a lot for your answer. Now I know that we need to rerun sqgen when we change sqconfig, any other cases that we also need to rerun sqgen?
Also, is is possible that we make sqgen as part of sqstart? Because sometimes we might forget to rerun sqgen because it is a separate part for sqstart.
Best regards,
Yuan
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, November 17, 2017 7:24 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: About sqgen
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan
RE: About sqgen
Posted by Sean Broeder <se...@esgyn.com>.
Hi Yuan,
Sqgen is a script that takes a mixture of configuration and release specific parameters and creates or sets up a number of files that are used at startup and runtime.
For example, there is a file named sqconfig that describes the cluster (the number of nodes, the location of $TRAF_HOME, etc). Sqgen takes this file and other scripts to programmatically generate $TRAF_HOME/etc/ms.env, gomon.cold, etc. These are files that are created specifically and tailored to the installed cluster and release that it is running. In this way, when a user types 'sqstart' the scripts, directories, and files are all in place for the monitor and other processes to read and come up quickly and consistently.
If you later decide to alter the configuration of your cluster, for example it you change the number of nodes in sqconfig, you can stop Trafodion and rerun sqgen. When Trafodion is restarted it will reflect the new changes you've specified.
Regards,
Sean
-----Original Message-----
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, November 16, 2017 1:58 AM
To: dev@trafodion.incubator.apache.org
Subject: About sqgen
Hi Trafodioneers,
As we know, the first time when we install Trafodion, "sqgen" is required to run, can anyone give a brief introduction about sqgen? What does sqgen do?
Thanks ahead.
Best regards,
Yuan