IDS Forum

RE: Configure IDS 11.50 to avoid sorts going d....

Posted By: Paul Watson
Date: Wednesday, 9 May 2012, at 8:28 a.m.

In Response To: Re: Configure IDS 11.50 to avoid sorts going d.... (Fernando Nunes)

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.

Messages In This Thread

• Configure IDS 11.50 to avoid sorts going disk or t
  Jonathan Smaby -- Thursday, 3 May 2012, at 5:55 p.m.
  • Re: Configure IDS 11.50 to avoid sorts going disk
    Art Kagel -- Thursday, 3 May 2012, at 6:01 p.m.
    • Re: Configure IDS 11.50 to avoid sorts going d....
      FRANK -- Tuesday, 8 May 2012, at 5:27 p.m.
      • Re: Configure IDS 11.50 to avoid sorts going d....
        Fernando Nunes -- Tuesday, 8 May 2012, at 5:35 p.m.
      • Re: Configure IDS 11.50 to avoid sorts going d....
        George_Palmer@aotx.uscourts.gov -- Tuesday, 8 May 2012, at 5:40 p.m.
      • Re: Configure IDS 11.50 to avoid sorts going d....
        Art Kagel -- Tuesday, 8 May 2012, at 5:46 p.m.
        • Re: Configure IDS 11.50 to avoid sorts going d....
          Fernando Nunes -- Tuesday, 8 May 2012, at 6:01 p.m.
          • Re: Configure IDS 11.50 to avoid sorts going d....
            FRANK -- Tuesday, 8 May 2012, at 6:32 p.m.
            • Re: Configure IDS 11.50 to avoid sorts going d....
              Art Kagel -- Tuesday, 8 May 2012, at 6:50 p.m.
          • Re: Configure IDS 11.50 to avoid sorts going d....
            Art Kagel -- Tuesday, 8 May 2012, at 6:45 p.m.
          • RE: Configure IDS 11.50 to avoid sorts going d....
            Paul Watson -- Wednesday, 9 May 2012, at 8:28 a.m.
          • Re: Configure IDS 11.50 to avoid sorts going d....
            FRANK -- Wednesday, 9 May 2012, at 1:45 p.m.
            • Re: Configure IDS 11.50 to avoid sorts going d....
              Art Kagel -- Wednesday, 9 May 2012, at 2:06 p.m.
            • Re: Configure IDS 11.50 to avoid sorts going d....
              Jonathan Leffler -- Wednesday, 9 May 2012, at 2:13 p.m.
              • Re: Configure IDS 11.50 to avoid sorts going d....
                FRANK -- Wednesday, 9 May 2012, at 2:41 p.m.
                • Re: Configure IDS 11.50 to avoid sorts going d....
                  Art Kagel -- Wednesday, 9 May 2012, at 3:04 p.m.
                  • Re: Configure IDS 11.50 to avoid sorts going d....
                    FRANK -- Wednesday, 9 May 2012, at 3:27 p.m.
                • Re: Configure IDS 11.50 to avoid sorts going d....
                  wanderlei.barboza -- Wednesday, 9 May 2012, at 3:35 p.m.
                  • Re: Configure IDS 11.50 to avoid sorts going d....
                    Art Kagel -- Wednesday, 9 May 2012, at 3:58 p.m.
  • Re: Configure IDS 11.50 to avoid sorts going disk
    John Miller iii -- Thursday, 3 May 2012, at 6:07 p.m.
    • RE: Configure IDS 11.50 to avoid sorts going d....
      Jonathan Smaby -- Thursday, 3 May 2012, at 6:13 p.m.
      • Re: Configure IDS 11.50 to avoid sorts going d....
        Art Kagel -- Thursday, 3 May 2012, at 7:02 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.