Yes, the same copy must be maintained on all nodes. This is similar to the ms.env file that is in the same directory. I too feel that the _MD_.default method is easier to manage. I mention it here only for the sake of completeness.
With both _MD_.default and the file method, if access is through a connectivity service, then a new instance of mxosrvr may be needed (as these attributes are read at process initialization time). Thanks Suresh On Tue, Feb 2, 2016 at 2:34 PM, Eric Owhadi <eric.owh...@esgyn.com> wrote: > Interesting, but how do we manage this on a cluster? Do we have to > maintain the same copy on each node? (just curious, I will use the > _*MD*_.default > method) > > > > Eric > > > > *From:* Suresh Subbiah [mailto:suresh.subbia...@gmail.com] > *Sent:* Tuesday, February 2, 2016 2:29 PM > *To:* user@trafodion.incubator.apache.org > *Subject:* Re: How to change default CQD? > > > > Hi, > > > > One can also create (or add to the file it already exists) a text file > called SQSystemDefaults.conf in the directory $MY_SQROOT/etc and add > attribute name and the value it should be set to in the file. > > I think each attribute should in a separate line and the attribute value > should NOT be surrounded by single quotes as we would do from sqlci/trafci. > > This file is also created by install_local_hadoop. if this script was > used, you may see an empty file with a few comments in your instance. > > > > Thanks > > Suresh > > > > > > On Tue, Feb 2, 2016 at 12:34 PM, Eric Owhadi <eric.owh...@esgyn.com> > wrote: > > Thanks Anoop, > > So I will use the following insert statement: > > insert into "_MD_".defaults values ('MY_CQD', 'value of CQD', 'comment why > it is inserted'); > > > > Eric > > > > > > > > *From:* Anoop Sharma [mailto:anoop.sha...@esgyn.com] > *Sent:* Tuesday, February 2, 2016 12:29 PM > *To:* user@trafodion.incubator.apache.org > *Subject:* RE: How to change default CQD? > > > > You can change it in code by modifying the defaults array in > sqlcomp/nadefaults.cpp > > or you can insert the default value in system defaults table > trafodion.“_MD_”.defaults. > > If you do the insert, you will need to restart dcs servers to pick up the > new value. > > > > anoop > > > > *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] > *Sent:* Tuesday, February 2, 2016 10:26 AM > *To:* user@trafodion.incubator.apache.org > *Subject:* How to change default CQD? > > > > Hello Trafodioneers, > > I have seen in the code that there is a way to globally change the default > Control Query Default values. But I can’t find it in the docs. > > Can someone help me on this? > > Regards, > Eric > > > > >
