Meaning of DS_NONPDQ_QUERY_MEM
Dear All.... http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp I refered to this document of IDS 11.1 , and found the following statements: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is a available for a query that is not a Parallel Database Query (PDQ). and You can use the DS_NONPDQ_QUERY_MEM configuration parameter to configure sort memory for all queries except those queries that have a PDQ priority of 0 (zero). My english is poor , but I think these 2 statements means that DS_NONPDQ_QUERY_MEM is for NONPDQ queries total amount of memory usage , also , DS_NONPDQ_QUERY_MEM is for PDQ queries sorting memory usage !! Am I correct ?!....these 2 statements confuse me , that means DS_NONPDQ_QUERY_MEM is used in both PDQ and NONPDQ in different way ?!
No. DS_NONPDQ_QUERY_MEM is only used for non PDQ queries. It essentially defines the memory for sorting for non PDQ queries. A non PDQ query will not have PDQPRIORITY set or will have it set to zero. Regards. On Wed, Sep 10, 2008 at 10:34 AM, MARS CHEN <mars@jsun.com> wrote: > Dear All.... > > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp > I refered to this document of IDS 11.1 , and found the following > statements: > > Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount > of > memory that is a available for a query that is not a Parallel Database > Query > (PDQ). > > and > > You can use the DS_NONPDQ_QUERY_MEM configuration parameter to configure > sort > memory for all queries except those queries that have a PDQ priority of 0 > (zero). > > My english is poor , but I think these 2 statements means that > DS_NONPDQ_QUERY_MEM is for NONPDQ queries total amount of memory usage , > also > , DS_NONPDQ_QUERY_MEM is for PDQ queries sorting memory usage !! > > Am I correct ?!....these 2 statements confuse me , that means > DS_NONPDQ_QUERY_MEM is used in both PDQ and NONPDQ in different way ?! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
The second statement is a documentation bug. In the 11.50xC1 Administrator's manual it states: *"You can only use this parameter if PDQ priority is set to zero."* The second quote should read: *You can use the DS_NONPDQ_QUERY_MEM configuration parameter to configure sort memory for all queries except PDQ queries.* Which is what it does say in the Performance Guide for IDS 11.50xC1 where they have corrected the documentation error. Art On Wed, Sep 10, 2008 at 5:34 AM, MARS CHEN <mars@jsun.com> wrote: > Dear All.... > > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp > I refered to this document of IDS 11.1 , and found the following > statements: > > Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount > of > memory that is a available for a query that is not a Parallel Database > Query > (PDQ). > > and > > You can use the DS_NONPDQ_QUERY_MEM configuration parameter to configure > sort > memory for all queries except those queries that have a PDQ priority of 0 > (zero). > > My english is poor , but I think these 2 statements means that > DS_NONPDQ_QUERY_MEM is for NONPDQ queries total amount of memory usage , > also > , DS_NONPDQ_QUERY_MEM is for PDQ queries sorting memory usage !! > > Am I correct ?!....these 2 statements confuse me , that means > DS_NONPDQ_QUERY_MEM is used in both PDQ and NONPDQ in different way ?! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Thank you guys .... And then I know it is an error for this statement ~~~