I do have an SPJ that supports displaying and changing cqd values in the
“_MD_”.defaults table.
Roberta
*From:* Suresh Subbiah [mailto:[email protected]]
*Sent:* Tuesday, February 2, 2016 12:45 PM
*To:* [email protected]
*Subject:* Re: How to change default CQD?
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 <[email protected]> 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:[email protected]]
*Sent:* Tuesday, February 2, 2016 2:29 PM
*To:* [email protected]
*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 <[email protected]> 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:[email protected]]
*Sent:* Tuesday, February 2, 2016 12:29 PM
*To:* [email protected]
*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:[email protected]]
*Sent:* Tuesday, February 2, 2016 10:26 AM
*To:* [email protected]
*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
