Re: Configure IDS 11.50 to avoid sorts going d....
The original question was how to stop sorts and other temporary operations in IDS 11.50 from spilling to scratch files in $INFORMIXDIR/tmp and keep them in memory. Art Kagel pointed to the ONCONFIG parameter for non-PDQ query memory (settable from 128KB up to 25% of DS_TOTAL_MEMORY) plus the DBUPSPACE environment variable for in-memory sorting. A follow-up poster couldn't find it in the Info Center because the name had been mistyped; the correct spelling, DS_NONPDQ_QUERY_MEM, was confirmed from onconfig.std and the manuals. The rest of the thread is a side debate about Info Center search versus downloading the PDF documentation sets.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I searched both the following configuration parameters, and did not get any result in IDS11.50 info center, DS_NONPDQ_QUERYMEM DS_NON_PDQ_QUERY_MEM Any idea? Thanks, Frank On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote: > DS_NONPDQ_QUERYMEM > > Sets the amount of DSS memory to use for queries that do not have positive > PDQPRIORITY. It can be set to any value from 128K to 25% of > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE which > controls the amount of memory used for in-memory sorting for non-PDQ > queries. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby > <Jonathan.Smaby@pomona.edu>wrote: > > > Good afternoon, > > > > Is there a configuration setting in ONCONFIG file to prevent sorts and > > other > > temporary operations from using files? Several sorts are creating temp or > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in > memory > > instead of on disk? If so, how do you configure Informix 11.50 to use > > memory > > instead of disk? > > > > Thanks in advance. > > > > Jonathan B. Smaby > > Pomona College > > -- > > "If you are not willing to risk the unusual, you will have to settle for > > the > > ordinary." - Jim Rohn > > > > ------------------------------------------------------------- > > This message has been scanned by Postini anti-virus software. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --14dae9340d59534f3b04bf28f01f > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d040168eb3868eb04bf8d0dcf
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adref.doc/id s_adr_0064.htm Regards On Tue, May 8, 2012 at 10:27 PM, FRANK <yunyaoqu@gmail.com> wrote: > I searched both the following configuration parameters, and did not get > any result in IDS11.50 info center, > > DS_NONPDQ_QUERYMEM > > DS_NON_PDQ_QUERY_MEM > > Any idea? > > Thanks, > Frank > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > DS_NONPDQ_QUERYMEM > > > > Sets the amount of DSS memory to use for queries that do not have > positive > > PDQPRIORITY. It can be set to any value from 128K to 25% of > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE which > > controls the amount of memory used for in-memory sorting for non-PDQ > > queries. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby > > <Jonathan.Smaby@pomona.edu>wrote: > > > > > Good afternoon, > > > > > > Is there a configuration setting in ONCONFIG file to prevent sorts and > > > other > > > temporary operations from using files? Several sorts are creating temp > or > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in > > memory > > > instead of on disk? If so, how do you configure Informix 11.50 to use > > > memory > > > instead of disk? > > > > > > Thanks in advance. > > > > > > Jonathan B. Smaby > > > Pomona College > > > -- > > > "If you are not willing to risk the unusual, you will have to settle > for > > > the > > > ordinary." - Jim Rohn > > > > > > ------------------------------------------------------------- > > > This message has been scanned by Postini anti-virus software. > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --14dae9340d59534f3b04bf28f01f > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --f46d040168eb3868eb04bf8d0dcf > > > > ******************************************************************************* > 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... --20cf302ef74c9131b204bf8d2863
Search something smaller.
Like the onconifg.std that came with the 11.50 engine you have installed.
( they group items and also give definitions and other information in the
onconifg file itself )
You will find the proper spelling there I believe its something like one of
these below.:
more onconifg.std
###################################################################
# Parallel Database Query (PDQ) Configuration Parameters
###################################################################
# MAX_PDQPRIORITY - The maximum amount of resources, as a
# percentage, that PDQ can allocate to any
# one decision support query
# DS_MAX_QUERIES - The maximum number of concurrent decision
# support queries
# DS_TOTAL_MEMORY - The maximum amount, in KB, of decision
# support query memory
# DS_MAX_SCANS - The maximum number of concurrent decision
# support scans
# DS_NONPDQ_QUERY_MEM - The amount of non-PDQ query memory, in KB.
# Acceptable values are 128 to 25% of
# DS_TOTAL_MEMORY.
# DATASKIP - Specifies whether to skip dbspaces when
# processing a query. Acceptable values are:
# - ALL Skip all unavailable fragments
# - ON <dbspace1> <dbspace2>... Skip listed
# dbspaces
# - OFF Do not skip dbspaces (default)
###################################################################
MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 128
DATASKIP
I hope the colors come out on your screen.
George.
From: "FRANK" <yunyaoqu@gmail.com>
To: ids@iiug.org
Date: 05/08/2012 04:28 PM
Subject: Re: Configure IDS 11.50 to avoid sorts going d.... [27058]
Sent by: ids-bounces@iiug.org
I searched both the following configuration parameters, and did not get
any result in IDS11.50 info center,
DS_NONPDQ_QUERYMEM
DS_NON_PDQ_QUERY_MEM
Any idea?
Thanks,
Frank
On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote:
> DS_NONPDQ_QUERYMEM
>
> Sets the amount of DSS memory to use for queries that do not have
positive
> PDQPRIORITY. It can be set to any value from 128K to 25% of
> DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE which
> controls the amount of memory used for in-memory sorting for non-PDQ
> queries.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated
nor
> those of the entities themselves.
>
> On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby
> <Jonathan.Smaby@pomona.edu>wrote:
>
> > Good afternoon,
> >
> > Is there a configuration setting in ONCONFIG file to prevent sorts and
> > other
> > temporary operations from using files? Several sorts are creating temp
or
> > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in
> memory
> > instead of on disk? If so, how do you configure Informix 11.50 to use
> > memory
> > instead of disk?
> >
> > Thanks in advance.
> >
> > Jonathan B. Smaby
> > Pomona College
> > --
> > "If you are not willing to risk the unusual, you will have to settle
for
> > the
> > ordinary." - Jim Rohn
> >
> > -------------------------------------------------------------
> > This message has been scanned by Postini anti-virus software.
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae9340d59534f3b04bf28f01f
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f46d040168eb3868eb04bf8d0dcf
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
The info center is almost worthless. Download the PDF manuals from here. This is the documentation set home page for 11.50: http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets This is the direct link to the download page for the 11.50.xC9 PDF documentation set: http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC =SRX&PBL=SC11-7740-02 They recently made it even harder than it already was to find these doc sets <sigh> I'll bring that up with IBM later this week. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote: > I searched both the following configuration parameters, and did not get > any result in IDS11.50 info center, > > DS_NONPDQ_QUERYMEM > > DS_NON_PDQ_QUERY_MEM > > Any idea? > > Thanks, > Frank > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > DS_NONPDQ_QUERYMEM > > > > Sets the amount of DSS memory to use for queries that do not have > positive > > PDQPRIORITY. It can be set to any value from 128K to 25% of > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE which > > controls the amount of memory used for in-memory sorting for non-PDQ > > queries. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby > > <Jonathan.Smaby@pomona.edu>wrote: > > > > > Good afternoon, > > > > > > Is there a configuration setting in ONCONFIG file to prevent sorts and > > > other > > > temporary operations from using files? Several sorts are creating temp > or > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in > > memory > > > instead of on disk? If so, how do you configure Informix 11.50 to use > > > memory > > > instead of disk? > > > > > > Thanks in advance. > > > > > > Jonathan B. Smaby > > > Pomona College > > > -- > > > "If you are not willing to risk the unusual, you will have to settle > for > > > the > > > ordinary." - Jim Rohn > > > > > > ------------------------------------------------------------- > > > This message has been scanned by Postini anti-virus software. > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --14dae9340d59534f3b04bf28f01f > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --f46d040168eb3868eb04bf8d0dcf > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3ba959718be604bf8d51c8
I know I can be acuse of being subjective, but let me disagree with that: The search function in Information center works well and It's helpul in many situations. The OP was searching for a non existing parameter. If he had followed the advice from another poster he would have found it (just like I did). As for the PDF sets, I'm also a big fan and it's probably the second thing I put on any PC after the OS... In order to get them I need 3 clicks and this has been so for very long time: Click 1: access the InfoCenter for the version I'm looking for Click 2: access the link that says "Download PDF documentation" (send me to a new page) Click 3: Click on the right version Then yes... a couple more clicks to select HTTP download and to accept the terms.... so... 5 clicks! For thos of us who spend most of the time with the manuals open, the PDFs are great, because you'll end up knowing where to look for what you need (every parameter is in a list on Admin Ref, every SQL command is in a list on the SQL syntax guide etc... But sometimes I really need the search facility and for that I prefer the Infocenter. Having said that, If anyone wants to pick on IBM, I was recently asked why don't we provide the Redbooks (and why not the documentation sets) on Mobi (Kindle) and/or ePub formats? On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote: > The info center is almost worthless. Download the PDF manuals from here. > This is the documentation set home page for 11.50: > > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets > > This is the direct link to the download page for the 11.50.xC9 PDF > documentation set: > > > > http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC =SRX&PBL=SC11-7740-02 > > They recently made it even harder than it already was to find these doc > sets <sigh> I'll bring that up with IBM later this week. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote: > > > I searched both the following configuration parameters, and did not get > > any result in IDS11.50 info center, > > > > DS_NONPDQ_QUERYMEM > > > > DS_NON_PDQ_QUERY_MEM > > > > Any idea? > > > > Thanks, > > Frank > > > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > DS_NONPDQ_QUERYMEM > > > > > > Sets the amount of DSS memory to use for queries that do not have > > positive > > > PDQPRIORITY. It can be set to any value from 128K to 25% of > > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE which > > > controls the amount of memory used for in-memory sorting for non-PDQ > > > queries. > > > > > > Art > > > > > > Art S. Kagel > > > Advanced DataTools (www.advancedatatools.com) > > > Blog: http://informix-myview.blogspot.com/ > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor > any > > > other organization with which I am associated either explicitly, > > > implicitly, or by inference. Neither do those opinions reflect those of > > > other individuals affiliated with any entity with which I am affiliated > > nor > > > those of the entities themselves. > > > > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby > > > <Jonathan.Smaby@pomona.edu>wrote: > > > > > > > Good afternoon, > > > > > > > > Is there a configuration setting in ONCONFIG file to prevent sorts > and > > > > other > > > > temporary operations from using files? Several sorts are creating > temp > > or > > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in > > > memory > > > > instead of on disk? If so, how do you configure Informix 11.50 to use > > > > memory > > > > instead of disk? > > > > > > > > Thanks in advance. > > > > > > > > Jonathan B. Smaby > > > > Pomona College > > > > -- > > > > "If you are not willing to risk the unusual, you will have to settle > > for > > > > the > > > > ordinary." - Jim Rohn > > > > > > > > ------------------------------------------------------------- > > > > This message has been scanned by Postini anti-virus software. > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --14dae9340d59534f3b04bf28f01f > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --f46d040168eb3868eb04bf8d0dcf > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --e89a8f3ba959718be604bf8d51c8 > > > > ******************************************************************************* > 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... --00235452fd9c614c0504bf8d8727
Thanks Fernando and Art and George !
Declare: It was not my fault for the wrong spelling ( did a copy paste
:-( )
Must admit , not a easy thing to write the parameter name correctly :-)
DS_NONPDQ_QUERY_MEMNo matter how slow the IBM IDS Info-center will be, we really need it
quite frequently!
Frank
On Tue, May 8, 2012 at 6:01 PM, Fernando Nunes <domusonline@gmail.com>wrote:
> I know I can be acuse of being subjective, but let me disagree with that:
>
> The search function in Information center works well and It's helpul in
> many situations. The OP was searching for a non existing parameter. If he
> had followed the advice from another poster he would have found it (just
> like I did).
>
> As for the PDF sets, I'm also a big fan and it's probably the second thing
> I put on any PC after the OS... In order to get them I need 3 clicks and
> this has been so for very long time:
> Click 1: access the InfoCenter for the version I'm looking for
> Click 2: access the link that says "Download PDF documentation" (send me to
> a new page)
> Click 3: Click on the right version
>
> Then yes... a couple more clicks to select HTTP download and to accept the
> terms.... so... 5 clicks!
> For thos of us who spend most of the time with the manuals open, the PDFs
> are great, because you'll end up knowing where to look for what you need
> (every parameter is in a list on Admin Ref, every SQL command is in a list
> on the SQL syntax guide etc... But sometimes I really need the search
> facility and for that I prefer the Infocenter.
>
> Having said that, If anyone wants to pick on IBM, I was recently asked why
> don't we provide the Redbooks (and why not the documentation sets) on Mobi
> (Kindle) and/or ePub formats?
>
> On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > The info center is almost worthless. Download the PDF manuals from here.
> > This is the documentation set home page for 11.50:
> >
> > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets
> >
> > This is the direct link to the download page for the 11.50.xC9 PDF
> > documentation set:
> >
> >
> >
> >
>
>
http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC
=SRX&PBL=SC11-7740-02
> >
> > They recently made it even harder than it already was to find these doc
> > sets <sigh> I'll bring that up with IBM later this week.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect those of
> > other individuals affiliated with any entity with which I am affiliated
> nor
> > those of the entities themselves.
> >
> > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote:
> >
> > > I searched both the following configuration parameters, and did not get
> > > any result in IDS11.50 info center,
> > >
> > > DS_NONPDQ_QUERYMEM
> > >
> > > DS_NON_PDQ_QUERY_MEM
> > >
> > > Any idea?
> > >
> > > Thanks,
> > > Frank
> > >
> > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote:
> > >
> > > > DS_NONPDQ_QUERYMEM
> > > >
> > > > Sets the amount of DSS memory to use for queries that do not have
> > > positive
> > > > PDQPRIORITY. It can be set to any value from 128K to 25% of
> > > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE
> which
> > > > controls the amount of memory used for in-memory sorting for non-PDQ
> > > > queries.
> > > >
> > > > Art
> > > >
> > > > Art S. Kagel
> > > > Advanced DataTools (www.advancedatatools.com)
> > > > Blog: http://informix-myview.blogspot.com/
> > > >
> > > > Disclaimer: Please keep in mind that my own opinions are my own
> > opinions
> > > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor
> > any
> > > > other organization with which I am associated either explicitly,
> > > > implicitly, or by inference. Neither do those opinions reflect those
> of
> > > > other individuals affiliated with any entity with which I am
> affiliated
> > > nor
> > > > those of the entities themselves.
> > > >
> > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby
> > > > <Jonathan.Smaby@pomona.edu>wrote:
> > > >
> > > > > Good afternoon,
> > > > >
> > > > > Is there a configuration setting in ONCONFIG file to prevent sorts
> > and
> > > > > other
> > > > > temporary operations from using files? Several sorts are creating
> > temp
> > > or
> > > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in
> > > > memory
> > > > > instead of on disk? If so, how do you configure Informix 11.50 to
> use
> > > > > memory
> > > > > instead of disk?
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > > Jonathan B. Smaby
> > > > > Pomona College
> > > > > --
> > > > > "If you are not willing to risk the unusual, you will have to
> settle
> > > for
> > > > > the
> > > > > ordinary." - Jim Rohn
> > > > >
> > > > > -------------------------------------------------------------
> > > > > This message has been scanned by Postini anti-virus software.
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --14dae9340d59534f3b04bf28f01f
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --f46d040168eb3868eb04bf8d0dcf
> > >
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --e89a8f3ba959718be604bf8d51c8
> >
> >
> >
> >
>
>
*******************************************************************************
> > 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...
>
> --00235452fd9c614c0504bf8d8727
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f2345676ad30604bf8df4c6
I'm sorry Fernando, but I'm not the only one. I had this discussion in San Diego with the manager of the Documentation team and it was acknowledged that the complaints I have are common themes expressed to support and directly to them. I know they are working on this and hopefully it will improve. Meanwhile, today, searching the Info Center doesn't find what you need more than half of the time and when it does the information is spread across several pages with no <back>, <next> or <prev> buttons. The related topics buttons are also too often unrelated. Sometimes the list of related search items on the left side gets me what I want, but ultimately, I am always sorry that I didn't start with the PDFs which I have on both my laptops and on my Linux box (even have the Guide to SQL Syntax on my Android phone). If the OP had used the PDF manuals, he would have seen the not-exactly-spelled-the-way-he-expected onconfig parameter in the TOC listing at the left of the PDF or in the Index at the end. Instead he was lost. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 8, 2012 at 6:01 PM, Fernando Nunes <domusonline@gmail.com>wrote: > I know I can be acuse of being subjective, but let me disagree with that: > > The search function in Information center works well and It's helpul in > many situations. The OP was searching for a non existing parameter. If he > had followed the advice from another poster he would have found it (just > like I did). > > As for the PDF sets, I'm also a big fan and it's probably the second thing > I put on any PC after the OS... In order to get them I need 3 clicks and > this has been so for very long time: > Click 1: access the InfoCenter for the version I'm looking for > Click 2: access the link that says "Download PDF documentation" (send me to > a new page) > Click 3: Click on the right version > > Then yes... a couple more clicks to select HTTP download and to accept the > terms.... so... 5 clicks! > For thos of us who spend most of the time with the manuals open, the PDFs > are great, because you'll end up knowing where to look for what you need > (every parameter is in a list on Admin Ref, every SQL command is in a list > on the SQL syntax guide etc... But sometimes I really need the search > facility and for that I prefer the Infocenter. > > Having said that, If anyone wants to pick on IBM, I was recently asked why > don't we provide the Redbooks (and why not the documentation sets) on Mobi > (Kindle) and/or ePub formats? > > On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > The info center is almost worthless. Download the PDF manuals from here. > > This is the documentation set home page for 11.50: > > > > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets > > > > This is the direct link to the download page for the 11.50.xC9 PDF > > documentation set: > > > > > > > > > > http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC =SRX&PBL=SC11-7740-02 > > > > They recently made it even harder than it already was to find these doc > > sets <sigh> I'll bring that up with IBM later this week. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote: > > > > > I searched both the following configuration parameters, and did not get > > > any result in IDS11.50 info center, > > > > > > DS_NONPDQ_QUERYMEM > > > > > > DS_NON_PDQ_QUERY_MEM > > > > > > Any idea? > > > > > > Thanks, > > > Frank > > > > > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > > > DS_NONPDQ_QUERYMEM > > > > > > > > Sets the amount of DSS memory to use for queries that do not have > > > positive > > > > PDQPRIORITY. It can be set to any value from 128K to 25% of > > > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE > which > > > > controls the amount of memory used for in-memory sorting for non-PDQ > > > > queries. > > > > > > > > Art > > > > > > > > Art S. Kagel > > > > Advanced DataTools (www.advancedatatools.com) > > > > Blog: http://informix-myview.blogspot.com/ > > > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > > opinions > > > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor > > any > > > > other organization with which I am associated either explicitly, > > > > implicitly, or by inference. Neither do those opinions reflect those > of > > > > other individuals affiliated with any entity with which I am > affiliated > > > nor > > > > those of the entities themselves. > > > > > > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby > > > > <Jonathan.Smaby@pomona.edu>wrote: > > > > > > > > > Good afternoon, > > > > > > > > > > Is there a configuration setting in ONCONFIG file to prevent sorts > > and > > > > > other > > > > > temporary operations from using files? Several sorts are creating > > temp > > > or > > > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in > > > > memory > > > > > instead of on disk? If so, how do you configure Informix 11.50 to > use > > > > > memory > > > > > instead of disk? > > > > > > > > > > Thanks in advance. > > > > > > > > > > Jonathan B. Smaby > > > > > Pomona College > > > > > -- > > > > > "If you are not willing to risk the unusual, you will have to > settle > > > for > > > > > the > > > > > ordinary." - Jim Rohn > > > > > > > > > > ------------------------------------------------------------- > > > > > This message has been scanned by Postini anti-virus software. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > --14dae9340d59534f3b04bf28f01f > > > > > > > > > > > > > > > > > > > > > > > > > > >
I think I had posted one of the misspellings. <shamed hanging of the head>
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 8, 2012 at 6:32 PM, FRANK <yunyaoqu@gmail.com> wrote:
> Thanks Fernando and Art and George !
>
> Declare: It was not my fault for the wrong spelling ( did a copy paste
> :-( )
>
> Must admit , not a easy thing to write the parameter name correctly :-)
>
> DS_NONPDQ_QUERY_MEM> No matter how slow the IBM IDS Info-center will be, we really need it
> quite frequently!
>
> Frank
>
> On Tue, May 8, 2012 at 6:01 PM, Fernando Nunes <domusonline@gmail.com
> >wrote:
>
> > I know I can be acuse of being subjective, but let me disagree with that:
> >
> > The search function in Information center works well and It's helpul in
> > many situations. The OP was searching for a non existing parameter. If he
> > had followed the advice from another poster he would have found it (just
> > like I did).
> >
> > As for the PDF sets, I'm also a big fan and it's probably the second
> thing
> > I put on any PC after the OS... In order to get them I need 3 clicks and
> > this has been so for very long time:
> > Click 1: access the InfoCenter for the version I'm looking for
> > Click 2: access the link that says "Download PDF documentation" (send me
> to
> > a new page)
> > Click 3: Click on the right version
> >
> > Then yes... a couple more clicks to select HTTP download and to accept
> the
> > terms.... so... 5 clicks!
> > For thos of us who spend most of the time with the manuals open, the PDFs
> > are great, because you'll end up knowing where to look for what you need
> > (every parameter is in a list on Admin Ref, every SQL command is in a
> list
> > on the SQL syntax guide etc... But sometimes I really need the search
> > facility and for that I prefer the Infocenter.
> >
> > Having said that, If anyone wants to pick on IBM, I was recently asked
> why
> > don't we provide the Redbooks (and why not the documentation sets) on
> Mobi
> > (Kindle) and/or ePub formats?
> >
> > On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> > > The info center is almost worthless. Download the PDF manuals from
> here.
> > > This is the documentation set home page for 11.50:
> > >
> > > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets
> > >
> > > This is the direct link to the download page for the 11.50.xC9 PDF
> > > documentation set:
> > >
> > >
> > >
> > >
> >
> >
>
>
http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC
=SRX&PBL=SC11-7740-02
> > >
> > > They recently made it even harder than it already was to find these doc
> > > sets <sigh> I'll bring that up with IBM later this week.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.com)
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor
> any
> > > other organization with which I am associated either explicitly,
> > > implicitly, or by inference. Neither do those opinions reflect those of
> > > other individuals affiliated with any entity with which I am affiliated
> > nor
> > > those of the entities themselves.
> > >
> > > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote:
> > >
> > > > I searched both the following configuration parameters, and did not
> get
> > > > any result in IDS11.50 info center,
> > > >
> > > > DS_NONPDQ_QUERYMEM
> > > >
> > > > DS_NON_PDQ_QUERY_MEM
> > > >
> > > > Any idea?
> > > >
> > > > Thanks,
> > > > Frank
> > > >
> > > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com>
> wrote:
> > > >
> > > > > DS_NONPDQ_QUERYMEM
> > > > >
> > > > > Sets the amount of DSS memory to use for queries that do not have
> > > > positive
> > > > > PDQPRIORITY. It can be set to any value from 128K to 25% of
> > > > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE
> > which
> > > > > controls the amount of memory used for in-memory sorting for
> non-PDQ
> > > > > queries.
> > > > >
> > > > > Art
> > > > >
> > > > > Art S. Kagel
> > > > > Advanced DataTools (www.advancedatatools.com)
> > > > > Blog: http://informix-myview.blogspot.com/
> > > > >
> > > > > Disclaimer: Please keep in mind that my own opinions are my own
> > > opinions
> > > > > and do not reflect on my employer, Advanced DataTools, the IIUG,
> nor
> > > any
> > > > > other organization with which I am associated either explicitly,
> > > > > implicitly, or by inference. Neither do those opinions reflect
> those
> > of
> > > > > other individuals affiliated with any entity with which I am
> > affiliated
> > > > nor
> > > > > those of the entities themselves.
> > > > >
> > > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby
> > > > > <Jonathan.Smaby@pomona.edu>wrote:
> > > > >
> > > > > > Good afternoon,
> > > > > >
> > > > > > Is there a configuration setting in ONCONFIG file to prevent
> sorts
> > > and
> > > > > > other
> > > > > > temporary operations from using files? Several sorts are creating
> > > temp
> > > > or
> > > > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing
> in
> > > > > memory
> > > > > > instead of on disk? If so, how do you configure Informix 11.50 to
> > use
> > > > > > memory
> > > > > > instead of disk?
> > > > > >
> > > > > > Thanks in advance.
> > > > > >
> > > > > > Jonathan B. Smaby
> > > > > > Pomona College
> > > > > > --
> > > > > > "If you are not willing to risk the unusual, you will have to
> > settle
> > > > for
> > > > > > the
> > > > > > ordinary." - Jim Rohn
> > > > > >
> > > > > > -------------------------------------------------------------
> > > > > > This message has been scanned by Postini anti-virus software.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > > >
> > > > >
> > > > > --14dae9340d59534f3b04bf28f01f
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
********************************************************************
I would agree - the info center works well, unless you are in Chrome :-) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Fernando Nunes Sent: Tuesday, May 08, 2012 5:02 PM To: ids@iiug.org Subject: Re: Configure IDS 11.50 to avoid sorts going d.... [27063] I know I can be acuse of being subjective, but let me disagree with that: The search function in Information center works well and It's helpul in many situations. The OP was searching for a non existing parameter. If he had followed the advice from another poster he would have found it (just like I did). As for the PDF sets, I'm also a big fan and it's probably the second thing I put on any PC after the OS... In order to get them I need 3 clicks and this has been so for very long time: Click 1: access the InfoCenter for the version I'm looking for Click 2: access the link that says "Download PDF documentation" (send me to a new page) Click 3: Click on the right version Then yes... a couple more clicks to select HTTP download and to accept the terms.... so... 5 clicks! For thos of us who spend most of the time with the manuals open, the PDFs are great, because you'll end up knowing where to look for what you need (every parameter is in a list on Admin Ref, every SQL command is in a list on the SQL syntax guide etc... But sometimes I really need the search facility and for that I prefer the Infocenter. Having said that, If anyone wants to pick on IBM, I was recently asked why don't we provide the Redbooks (and why not the documentation sets) on Mobi (Kindle) and/or ePub formats? On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote: > The info center is almost worthless. Download the PDF manuals from here. > This is the documentation set home page for 11.50: > > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets > > This is the direct link to the download page for the 11.50.xC9 PDF > documentation set: > > > > http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US &FNC=SRX&PBL=SC11-7740-02 > > They recently made it even harder than it already was to find these doc > sets <sigh> I'll bring that up with IBM later this week. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote: > > > I searched both the following configuration parameters, and did not get > > any result in IDS11.50 info center, > > > > DS_NONPDQ_QUERYMEM > > > > DS_NON_PDQ_QUERY_MEM > > > > Any idea? > > > > Thanks, > > Frank > > > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > DS_NONPDQ_QUERYMEM > > > > > > Sets the amount of DSS memory to use for queries that do not have > > positive > > > PDQPRIORITY. It can be set to any value from 128K to 25% of > > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE which > > > controls the amount of memory used for in-memory sorting for non-PDQ > > > queries. > > > > > > Art > > > > > > Art S. Kagel > > > Advanced DataTools (www.advancedatatools.com) > > > Blog: http://informix-myview.blogspot.com/ > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor > any > > > other organization with which I am associated either explicitly, > > > implicitly, or by inference. Neither do those opinions reflect those of > > > other individuals affiliated with any entity with which I am affiliated > > nor > > > those of the entities themselves. > > > > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby > > > <Jonathan.Smaby@pomona.edu>wrote: > > > > > > > Good afternoon, > > > > > > > > Is there a configuration setting in ONCONFIG file to prevent sorts > and > > > > other > > > > temporary operations from using files? Several sorts are creating > temp > > or > > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing in > > > memory > > > > instead of on disk? If so, how do you configure Informix 11.50 to use > > > > memory > > > > instead of disk? > > > > > > > > Thanks in advance. > > > > > > > > Jonathan B. Smaby > > > > Pomona College > > > > -- > > > > "If you are not willing to risk the unusual, you will have to settle > > for > > > > the > > > > ordinary." - Jim Rohn > > > > > > > > ------------------------------------------------------------- > > > > This message has been scanned by Postini anti-virus software. > > > > > > > > > > > > > > > > > > > > > > > > > > > > **************************************************************************** *** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --14dae9340d59534f3b04bf28f01f > > > > > > > > > > > > > > > > > > **************************************************************************** *** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --f46d040168eb3868eb04bf8d0dcf > > > > > > > > > > **************************************************************************** *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --e89a8f3ba959718be604bf8d51c8 > > > > **************************************************************************** *** > 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... --00235452fd9c614c0504bf8d8727 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
Folks,
IDS11.50 FC8
I updated the configuration parameter as following,
#DS_NONPDQ_QUERY_MEM 128
DS_NONPDQ_QUERY_MEM 4096
When I bounced my instance, it showed,
[informix@franklin etc]$ oninit
DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to 4096Kb!
The next question.
I set the PDQPRIORITY TO 0, and run a SQL with a Order By ( 30 rows
output), it still needs a Temporary file created for the sorting, why?
See attached.
Thanks,
Frank
QUERY: (OPTIMIZATION TIMESTAMP: 05-09-2012 17:11:14)
------
select
status_id,processing_path,path_counter,item_id,queue_number,inactivity_count,(cy
cle_check_dt
- act_s
tart_dt),(CURRENT YEAR TO SECOND - act_start_dt) from activity_status where
activity_stage='READY' and proc
_cmd='PackageData' and act_item_descript='line_item' and path_counter>-1
order by item_id for read only
Estimated Cost: 19
Estimated # of Rows Returned: 1
Temporary Files Required For: Order By
1) informix.activity_status: INDEX PATH
Filters: ((informix.activity_status.act_item_descript = 'line_item'
AND informix.activity_status.pa
th_counter > -1 ) AND informix.activity_status.activity_stage = 'READY' )
(1) Index Name: informix.activity_status_idx5
Index Keys: proc_cmd (Serial, fragments: ALL)
Lower Index Filter: informix.activity_status.proc_cmd =
'PackageData'
Query statistics:
-----------------
Table map :
----------------------------
Internal name Table name
----------------------------
t1 activity_status
type table rows_prod est_rows rows_scan time est_cost
-------------------------------------------------------------------
scan t1 23 1 24 00:00.00 19
type rows_sort est_rows rows_cons time est_cost
------------------------------------------------------------
sort 23 1 23 00:00.00 0
On Tue, May 8, 2012 at 6:31 PM, FRANK <yunyaoqu@gmail.com> wrote:
> Thanks Fernando and Art and George !
>
> Declare: It was not my fault for the wrong spelling ( did a copy paste
> :-( )
>
> Must admit , not a easy thing to write the parameter name correctly
> :-)
>
> DS_NONPDQ_QUERY_MEM> No matter how slow the IBM IDS Info-center will be, we really need it
> quite frequently!
>
> Frank
>
>
>
>
> On Tue, May 8, 2012 at 6:01 PM, Fernando Nunes <domusonline@gmail.com>wrote:
>
>> I know I can be acuse of being subjective, but let me disagree with that:
>>
>> The search function in Information center works well and It's helpul in
>> many situations. The OP was searching for a non existing parameter. If he
>> had followed the advice from another poster he would have found it (just
>> like I did).
>>
>> As for the PDF sets, I'm also a big fan and it's probably the second thing
>> I put on any PC after the OS... In order to get them I need 3 clicks and
>> this has been so for very long time:
>> Click 1: access the InfoCenter for the version I'm looking for
>> Click 2: access the link that says "Download PDF documentation" (send me
>> to
>> a new page)
>> Click 3: Click on the right version
>>
>> Then yes... a couple more clicks to select HTTP download and to accept the
>> terms.... so... 5 clicks!
>> For thos of us who spend most of the time with the manuals open, the PDFs
>> are great, because you'll end up knowing where to look for what you need
>> (every parameter is in a list on Admin Ref, every SQL command is in a list
>> on the SQL syntax guide etc... But sometimes I really need the search
>> facility and for that I prefer the Infocenter.
>>
>> Having said that, If anyone wants to pick on IBM, I was recently asked why
>> don't we provide the Redbooks (and why not the documentation sets) on Mobi
>> (Kindle) and/or ePub formats?
>>
>> On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote:
>>
>> > The info center is almost worthless. Download the PDF manuals from here.
>> > This is the documentation set home page for 11.50:
>> >
>> > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets
>> >
>> > This is the direct link to the download page for the 11.50.xC9 PDF
>> > documentation set:
>> >
>> >
>> >
>> >
>>
>>
http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC
=SRX&PBL=SC11-7740-02
>> >
>> > They recently made it even harder than it already was to find these doc
>> > sets <sigh> I'll bring that up with IBM later this week.
>> >
>> > Art
>> >
>> > Art S. Kagel
>> > Advanced DataTools (www.advancedatatools.com)
>> > Blog: http://informix-myview.blogspot.com/
>> >
>> > Disclaimer: Please keep in mind that my own opinions are my own opinions
>> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
>> > other organization with which I am associated either explicitly,
>> > implicitly, or by inference. Neither do those opinions reflect those of
>> > other individuals affiliated with any entity with which I am affiliated
>> nor
>> > those of the entities themselves.
>> >
>> > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote:
>> >
>> > > I searched both the following configuration parameters, and did not
>> get
>> > > any result in IDS11.50 info center,
>> > >
>> > > DS_NONPDQ_QUERYMEM
>> > >
>> > > DS_NON_PDQ_QUERY_MEM
>> > >
>> > > Any idea?
>> > >
>> > > Thanks,
>> > > Frank
>> > >
>> > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com>
>> wrote:
>> > >
>> > > > DS_NONPDQ_QUERYMEM
>> > > >
>> > > > Sets the amount of DSS memory to use for queries that do not have
>> > > positive
>> > > > PDQPRIORITY. It can be set to any value from 128K to 25% of
>> > > > DS_TOTAL_MEMORY. Also look at the environment variable DBUPSPACE
>> which
>> > > > controls the amount of memory used for in-memory sorting for non-PDQ
>> > > > queries.
>> > > >
>> > > > Art
>> > > >
>> > > > Art S. Kagel
>> > > > Advanced DataTools (www.advancedatatools.com)
>> > > > Blog: http://informix-myview.blogspot.com/
>> > > >
>> > > > Disclaimer: Please keep in mind that my own opinions are my own
>> > opinions
>> > > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor
>> > any
>> > > > other organization with which I am associated either explicitly,
>> > > > implicitly, or by inference. Neither do those opinions reflect
>> those of
>> > > > other individuals affiliated with any entity with which I am
>> affiliated
>> > > nor
>> > > > those of the entities themselves.
>> > > >
>> > > > On Thu, May 3, 2012 at 5:55 PM, Jonathan Smaby
>> > > > <Jonathan.Smaby@pomona.edu>wrote:
>> > > >
>> > > > > Good afternoon,
>> > > > >
>> > > > > Is there a configuration setting in ONCONFIG file to prevent sorts
>> > and
>> > > > > other
>> > > > > temporary operations from using files? Several sorts are creating
>> > temp
>> > > or
>> > > > > scratch files in $INFORMIXDIR/tmp. Can those operations be doing
>> in
>> > > > memory
>> > > > > instead of on disk?
What is DS_TOTAL_MEMORY set to? DS_NONPDQ_QUERY_MEM is limited to 25% of
DS_TOTAL_MEMORY.
As to your sqexplain.out output, it will always say "Temporary Files
Required For: Order By" because the results of the sort will be a temp
table whether the sort-work files are written to disk are only to memory.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, May 9, 2012 at 1:45 PM, FRANK <yunyaoqu@gmail.com> wrote:
> Folks,
>
> IDS11.50 FC8
>
> I updated the configuration parameter as following,
>
> #DS_NONPDQ_QUERY_MEM 128
> DS_NONPDQ_QUERY_MEM 4096>
> When I bounced my instance, it showed,
>
> [informix@franklin etc]$ oninit
>
> DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
>
> Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to 4096Kb!
>
> The next question.
>
> I set the PDQPRIORITY TO 0, and run a SQL with a Order By ( 30 rows
> output), it still needs a Temporary file created for the sorting, why?
> See attached.
>
> Thanks,
> Frank
>
> QUERY: (OPTIMIZATION TIMESTAMP: 05-09-2012 17:11:14)
> ------
> select
>
>
>
status_id,processing_path,path_counter,item_id,queue_number,inactivity_count,(cy
cle_check_dt
> - act_s
> tart_dt),(CURRENT YEAR TO SECOND - act_start_dt) from activity_status where
> activity_stage='READY' and proc
> _cmd='PackageData' and act_item_descript='line_item' and path_counter>-1
> order by item_id for read only
>
> Estimated Cost: 19
> Estimated # of Rows Returned: 1
> Temporary Files Required For: Order By
> 1) informix.activity_status: INDEX PATH
>
> Filters: ((informix.activity_status.act_item_descript = 'line_item'
> AND informix.activity_status.pa
> th_counter > -1 ) AND informix.activity_status.activity_stage = 'READY' )
>
> (1) Index Name: informix.activity_status_idx5
>
> Index Keys: proc_cmd (Serial, fragments: ALL)
>
> Lower Index Filter: informix.activity_status.proc_cmd =
> 'PackageData'
>
> Query statistics:
> -----------------
> Table map :
> ----------------------------
> Internal name Table name
> ----------------------------
> t1 activity_status
> type table rows_prod est_rows rows_scan time est_cost
> -------------------------------------------------------------------
> scan t1 23 1 24 00:00.00 19
> type rows_sort est_rows rows_cons time est_cost
> ------------------------------------------------------------
> sort 23 1 23 00:00.00 0
>
> On Tue, May 8, 2012 at 6:31 PM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > Thanks Fernando and Art and George !
> >
> > Declare: It was not my fault for the wrong spelling ( did a copy paste
> > :-( )
> >
> > Must admit , not a easy thing to write the parameter name correctly
> > :-)
> >
> > DS_NONPDQ_QUERY_MEM> > No matter how slow the IBM IDS Info-center will be, we really need it
> > quite frequently!
> >
> > Frank
> >
> >
> >
> >
> > On Tue, May 8, 2012 at 6:01 PM, Fernando Nunes <domusonline@gmail.com
> >wrote:
> >
> >> I know I can be acuse of being subjective, but let me disagree with
> that:
> >>
> >> The search function in Information center works well and It's helpul in
> >> many situations. The OP was searching for a non existing parameter. If
> he
> >> had followed the advice from another poster he would have found it (just
> >> like I did).
> >>
> >> As for the PDF sets, I'm also a big fan and it's probably the second
> thing
> >> I put on any PC after the OS... In order to get them I need 3 clicks and
> >> this has been so for very long time:
> >> Click 1: access the InfoCenter for the version I'm looking for
> >> Click 2: access the link that says "Download PDF documentation" (send me
> >> to
> >> a new page)
> >> Click 3: Click on the right version
> >>
> >> Then yes... a couple more clicks to select HTTP download and to accept
> the
> >> terms.... so... 5 clicks!
> >> For thos of us who spend most of the time with the manuals open, the
> PDFs
> >> are great, because you'll end up knowing where to look for what you need
> >> (every parameter is in a list on Admin Ref, every SQL command is in a
> list
> >> on the SQL syntax guide etc... But sometimes I really need the search
> >> facility and for that I prefer the Infocenter.
> >>
> >> Having said that, If anyone wants to pick on IBM, I was recently asked
> why
> >> don't we provide the Redbooks (and why not the documentation sets) on
> Mobi
> >> (Kindle) and/or ePub formats?
> >>
> >> On Tue, May 8, 2012 at 10:46 PM, Art Kagel <art.kagel@gmail.com> wrote:
> >>
> >> > The info center is almost worthless. Download the PDF manuals from
> here.
> >> > This is the documentation set home page for 11.50:
> >> >
> >> > http://www-01.ibm.com/support/docview.wss?uid=swg27010058#DocSets
> >> >
> >> > This is the direct link to the download page for the 11.50.xC9 PDF
> >> > documentation set:
> >> >
> >> >
> >> >
> >> >
> >>
> >>
>
>
http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC
=SRX&PBL=SC11-7740-02
> >> >
> >> > They recently made it even harder than it already was to find these
> doc
> >> > sets <sigh> I'll bring that up with IBM later this week.
> >> >
> >> > Art
> >> >
> >> > Art S. Kagel
> >> > Advanced DataTools (www.advancedatatools.com)
> >> > Blog: http://informix-myview.blogspot.com/
> >> >
> >> > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> >> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor
> any
> >> > other organization with which I am associated either explicitly,
> >> > implicitly, or by inference. Neither do those opinions reflect those
> of
> >> > other individuals affiliated with any entity with which I am
> affiliated
> >> nor
> >> > those of the entities themselves.
> >> >
> >> > On Tue, May 8, 2012 at 5:27 PM, FRANK <yunyaoqu@gmail.com> wrote:
> >> >
> >> > > I searched both the following configuration parameters, and did not
> >> get
> >> > > any result in IDS11.50 info center,
> >> > >
> >> > > DS_NONPDQ_QUERYMEM
> >> > >
> >> > > DS_NON_PDQ_QUERY_MEM
> >> > >
> >> > > Any idea?
> >> > >
> >> > > Thanks,
> >> > > Frank
> >> > >
> >> > > On Thu, May 3, 2012 at 6:01 PM, Art Kagel <art.kagel@gmail.com>
> >> wrote:
> >> > >
> >> > > > DS_NONPDQ_QUERYMEM
> >> > > >
> >> > > > Sets the amount of DSS memory to use for queries that do not have
> >> > > positive
> >> > > > PDQPRIORITY. It can be set to any value from 128K to 25% of
> >> > > > DS_TOTAL_MEMORY. Al
On Wed, May 9, 2012 at 10:45 AM, FRANK <yunyaoqu@gmail.com> wrote:
> Folks,
>
> IDS11.50 FC8
>
> I updated the configuration parameter as following,
>
> #DS_NONPDQ_QUERY_MEM 128
> DS_NONPDQ_QUERY_MEM 4096>
> When I bounced my instance, it showed,
>
> [informix@franklin etc]$ oninit
>
> DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
>
> Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to 4096Kb!
>
The DS_NONPDQ_QUERY_MEM has to be less than 25% (or thereabouts) of the
total PDQ query memory - or something similar. I assume that the other
parameter was too small and therefore the server reset the value.
Look in the manual; it should be documented.
--
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."
--f46d04083989edf4a004bf9e7305
Thanks, Art and Jonathan!
After reset the DS_TOTAL_MEMORY to a bigger value, the confuse message is
gone.
But, The following still there,
Temporary Files Required For: Order By
How can we check and verify there is no temporary table created in disk
for the sorting ?
Thanks
Frank
On Wed, May 9, 2012 at 2:13 PM, Jonathan Leffler <jonathan.leffler@gmail.com
> wrote:
> On Wed, May 9, 2012 at 10:45 AM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > Folks,
> >
> > IDS11.50 FC8
> >
> > I updated the configuration parameter as following,
> >
> > #DS_NONPDQ_QUERY_MEM 128
> > DS_NONPDQ_QUERY_MEM 4096> >
> > When I bounced my instance, it showed,
> >
> > [informix@franklin etc]$ oninit
> >
> > DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
> >
> > Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to 4096Kb!
> >
>
> The DS_NONPDQ_QUERY_MEM has to be less than 25% (or thereabouts) of the
> total PDQ query memory - or something similar. I assume that the other
> parameter was too small and therefore the server reset the value.
>
> Look in the manual; it should be documented.
>
> --
> 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."
>
> --f46d04083989edf4a004bf9e7305
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec55401c644013804bf9ed82a
Keep the session open and look in the syssesprof table for the number of
disksorts versus totalsorts.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, May 9, 2012 at 2:41 PM, FRANK <yunyaoqu@gmail.com> wrote:
> Thanks, Art and Jonathan!
>
> After reset the DS_TOTAL_MEMORY to a bigger value, the confuse message is
> gone.
>
> But, The following still there,
>
> Temporary Files Required For: Order By
>
> How can we check and verify there is no temporary table created in disk
> for the sorting ?
>
> Thanks
> Frank
>
> On Wed, May 9, 2012 at 2:13 PM, Jonathan Leffler <
> jonathan.leffler@gmail.com
> > wrote:
>
> > On Wed, May 9, 2012 at 10:45 AM, FRANK <yunyaoqu@gmail.com> wrote:
> >
> > > Folks,
> > >
> > > IDS11.50 FC8
> > >
> > > I updated the configuration parameter as following,
> > >
> > > #DS_NONPDQ_QUERY_MEM 128
> > > DS_NONPDQ_QUERY_MEM 4096> > >
> > > When I bounced my instance, it showed,
> > >
> > > [informix@franklin etc]$ oninit
> > >
> > > DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
> > >
> > > Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to 4096Kb!
> > >
> >
> > The DS_NONPDQ_QUERY_MEM has to be less than 25% (or thereabouts) of the
> > total PDQ query memory - or something similar. I assume that the other
> > parameter was too small and therefore the server reset the value.
> >
> > Look in the manual; it should be documented.
> >
> > --
> > 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."
> >
> > --f46d04083989edf4a004bf9e7305
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --bcaec55401c644013804bf9ed82a
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340c013a409104bf9f2df0
Thanks Art!
On Wed, May 9, 2012 at 3:04 PM, Art Kagel <art.kagel@gmail.com> wrote:
> Keep the session open and look in the syssesprof table for the number of
> disksorts versus totalsorts.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated nor
> those of the entities themselves.
>
> On Wed, May 9, 2012 at 2:41 PM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > Thanks, Art and Jonathan!
> >
> > After reset the DS_TOTAL_MEMORY to a bigger value, the confuse message is
> > gone.
> >
> > But, The following still there,
> >
> > Temporary Files Required For: Order By
> >
> > How can we check and verify there is no temporary table created in disk
> > for the sorting ?
> >
> > Thanks
> > Frank
> >
> > On Wed, May 9, 2012 at 2:13 PM, Jonathan Leffler <
> > jonathan.leffler@gmail.com
> > > wrote:
> >
> > > On Wed, May 9, 2012 at 10:45 AM, FRANK <yunyaoqu@gmail.com> wrote:
> > >
> > > > Folks,
> > > >
> > > > IDS11.50 FC8
> > > >
> > > > I updated the configuration parameter as following,
> > > >
> > > > #DS_NONPDQ_QUERY_MEM 128
> > > > DS_NONPDQ_QUERY_MEM 4096> > > >
> > > > When I bounced my instance, it showed,
> > > >
> > > > [informix@franklin etc]$ oninit
> > > >
> > > > DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
> > > >
> > > > Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to
> 4096Kb!
> > > >
> > >
> > > The DS_NONPDQ_QUERY_MEM has to be less than 25% (or thereabouts) of the
> > > total PDQ query memory - or something similar. I assume that the other
> > > parameter was too small and therefore the server reset the value.
> > >
> > > Look in the manual; it should be documented.
> > >
> > > --
> > > 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."
> > >
> > > --f46d04083989edf4a004bf9e7305
> > >
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --bcaec55401c644013804bf9ed82a
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae9340c013a409104bf9f2df0
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e0cb4efe33f8eeb9e804bf9f7f05
Please
I do not whant to receive all mensages about ids list
Thanks
Wanderlei
-----Mensagem Original-----
From: "FRANK" yunyaoqu@gmail.com
Date: Wed, 09 May 2012 15:41:05 -0300
To: ids@iiug.org
Subject: Re: Configure IDS 11.50 to avoid sorts going d.... [27100]
> Thanks, Art and Jonathan!
>
> After reset the DS_TOTAL_MEMORY to a bigger value, the confuse message is
> gone.
>
> But, The following still there,
>
> Temporary Files Required For: Order By
>
> How can we check and verify there is no temporary table created in disk
> for the sorting ?
>
> Thanks
> Frank
>
> On Wed, May 9, 2012 at 2:13 PM, Jonathan Leffler <jonathan.leffler@gmail.com
> > wrote:
>
> > On Wed, May 9, 2012 at 10:45 AM, FRANK <yunyaoqu@gmail.com> wrote:
> >
> > > Folks,
> > >
> > > IDS11.50 FC8
> > >
> > > I updated the configuration parameter as following,
> > >
> > > #DS_NONPDQ_QUERY_MEM 128
> > > DS_NONPDQ_QUERY_MEM 4096> > >
> > > When I bounced my instance, it showed,
> > >
> > > [informix@franklin etc]$ oninit
> > >
> > > DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
> > >
> > > Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to 4096Kb!
> > >
> >
> > The DS_NONPDQ_QUERY_MEM has to be less than 25% (or thereabouts) of the
> > total PDQ query memory - or something similar. I assume that the other
> > parameter was too small and therefore the server reset the value.
> >
> > Look in the manual; it should be documented.
> >
> > --
> > 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."
> >
> > --f46d04083989edf4a004bf9e7305
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --bcaec55401c644013804bf9ed82a
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Go to the IIUG web site (www.iiug.org) log in with your userid or member
number. Then go to the members pages and select Forums and opt out of the
forum emails.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, May 9, 2012 at 3:35 PM, wanderlei.barboza <
wanderlei.barboza@interaconsultoria.com.br> wrote:
> Please
> I do not whant to receive all mensages about ids list
>
> Thanks
> Wanderlei
>
> -----Mensagem Original-----
> From: "FRANK" yunyaoqu@gmail.com
> Date: Wed, 09 May 2012 15:41:05 -0300
> To: ids@iiug.org
> Subject: Re: Configure IDS 11.50 to avoid sorts going d.... [27100]
>
> > Thanks, Art and Jonathan!
> >
> > After reset the DS_TOTAL_MEMORY to a bigger value, the confuse message is
> > gone.
> >
> > But, The following still there,
> >
> > Temporary Files Required For: Order By
> >
> > How can we check and verify there is no temporary table created in disk
> > for the sorting ?
> >
> > Thanks
> > Frank
> >
> > On Wed, May 9, 2012 at 2:13 PM, Jonathan Leffler <
> jonathan.leffler@gmail.com
> > > wrote:
> >
> > > On Wed, May 9, 2012 at 10:45 AM, FRANK <yunyaoqu@gmail.com> wrote:
> > >
> > > > Folks,
> > > >
> > > > IDS11.50 FC8
> > > >
> > > > I updated the configuration parameter as following,
> > > >
> > > > #DS_NONPDQ_QUERY_MEM 128
> > > > DS_NONPDQ_QUERY_MEM 4096> > > >
> > > > When I bounced my instance, it showed,
> > > >
> > > > [informix@franklin etc]$ oninit
> > > >
> > > > DS_NONPDQ_QUERY_MEM recalculated and changed from 4096Kb to 128Kb
> > > >
> > > > Why it said from 4096Kb to 128Kb ? It should say, from 128Kb to
> 4096Kb!
> > > >
> > >
> > > The DS_NONPDQ_QUERY_MEM has to be less than 25% (or thereabouts) of the
> > > total PDQ query memory - or something similar. I assume that the other
> > > parameter was too small and therefore the server reset the value.
> > >
> > > Look in the manual; it should be documented.
> > >
> > > --
> > > 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."
> > >
> > > --f46d04083989edf4a004bf9e7305
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --bcaec55401c644013804bf9ed82a
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba959b4427704bf9feb53