why does DS_NONPDQ_QUERY_MEM have the prefix "DS"

Posted in 2011

YE XIE — Mon, 20 Jun 2011 09:09:13 — source: IIUG Forums & Mailing Lists

In Informix Administrator's Reference, I see: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is available for a query that is not a Parallel Database Query (PDQ). My questions are: Now that DS_NONPDQ_QUERY_MEM is for NONPDQ, why does it have the prefix "DS" which means Decision Support and PDQ? Is "the memory pool specified by DS_NONPDQ_QUERY_MEM" a part of "the memory pool specified by DS_TOTAL_MEMORY"?

↪ replying to YE XIE

Art Kagel — Mon, 20 Jun 2011 12:11:18 — source: IIUG Forums & Mailing Lists

Yes. It comes out of DS_TOTAL_MEMORY. Art On Jun 20, 2011 5:09 AM, "YE XIE" <xieye@cn.ibm.com> wrote: > In Informix Administrator's Reference, I see: > Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of > memory that is available for a query that is not a Parallel Database Query > (PDQ). > > My questions are: > Now that DS_NONPDQ_QUERY_MEM is for NONPDQ, why does it have the prefix "DS" > which means Decision Support and PDQ? > Is "the memory pool specified by DS_NONPDQ_QUERY_MEM" a part of "the memory > pool specified by DS_TOTAL_MEMORY"? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --bcaec5016349bb731d04a623a1a2

↪ replying to YE XIE

Jonathan — Mon, 20 Jun 2011 15:02:53 — source: IIUG Forums & Mailing Lists

On Mon, Jun 20, 2011 at 02:09, YE XIE <xieye@cn.ibm.com> wrote: > In Informix Administrator's Reference, I see: > Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount > of > memory that is available for a query that is not a Parallel Database Query > (PDQ). > > My questions are: > Now that DS_NONPDQ_QUERY_MEM is for NONPDQ, why does it have the prefix > "DS" > which means Decision Support and PDQ? > Is "the memory pool specified by DS_NONPDQ_QUERY_MEM" a part of "the memory > pool specified by DS_TOTAL_MEMORY"? > DS was for 'Decision Support'. It was a name for some of the parallel query features. At one time, there was Informix Extended Parallel Server with Advanced Decision Support Option (XPS/ADSO), or thereabouts. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --00163692099059116b04a62607e6

↪ replying to Jonathan

YE XIE — Tue, 21 Jun 2011 03:10:15 — source: IIUG Forums & Mailing Lists

Jonathan, thank you for your explanation about "DS". Maybe I need to clarify my question. My question is: DS_NONPDQ_QUERY_MEM is for non-PDQ queries. But "DS" means PDQ. Why do "DS" and "NONPDQ" appear in "DS_NONPDQ_QUERY_MEM" at the same time?

↪ replying to Art Kagel

YE XIE — Thu, 23 Jun 2011 09:47:44 — source: IIUG Forums & Mailing Lists

Art, thank you for your reply!