IDS Forum

Re: v12.10.fc3

Posted By: Art Kagel
Date: Friday, 30 May 2014, at 3:16 p.m.

In Response To: v12.10.fc3 (Peter_Logan@spartanstores.com)

Here:

http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_1183.htm?lang=en

AUTO_TUNE_SERVER_SIZE configuration parameter

Use the AUTO_TUNE_SERVER_SIZE configuration parameter to set the sizes of
memory and storage spaces to allocate based on the number of expected
concurrent users.
onconfig.std valueNot in the onconfig.std file. Default valueNot set.value
if you created a server during installation Depends on the number of users
you specify in the installation program.values SMALL = 1 - 100 usersMEDIUM
= 101 - 500 usersLARGE = 501 - 1000 usersXLARGE = more than 1000 users takes
effectIf you create a server during installation.After you edit your
onconfig file and restart the database server for the first time.
Usage

If you create a server during installation, you specify the number of
expected users for the database server. The AUTO_TUNE_SERVER_SIZE
configuration parameter is set to the corresponding size, which affects the
size of the following properties:

- The size of the buffer pool.

- The maximum size of logical log files before the server stops

automatically adding logical logs to improve performance

- The initial size of the following created storage spaces, which are

created automatically during installation:

- An extendable plogspace for the physical log

- A dbspace for the logical log

- Dbspaces for databases and tables

- A temporary dbspace

- An sbspace

- A temporary sbspace

The following table shows how the value of the AUTO_TUNE_SERVER_SIZE
configuration parameter affects sizes.
Table 1. Effect on memory and storage space allocations ValueMaximum size
of buffer pools (BUFFERPOOL) Initial size of automatically created storage
spacesMaximum size of logical log files (AUTO_LLOG) SMALL 10% of available
shared memory50 MB 200 MBMEDIUM 20%100 MB500 MB LARGE 33%200 MB1 GB XLARGE
50%500 MB2 GB

If you did not create a server during installation, or you change the value
of the AUTO_TUNE_SERVER_SIZE configuration parameter after you initialize
the server for the first time, the new value affects the size of only the
following properties:

- The size of the buffer pool, if the BUFFERPOOL configuration parameter

setting includes the memory='auto' option.

- The maximum size of all logical log files before the server stops

automatically adding logical logs to improve performance.

Art

Art S. Kagel, Principal Consultant
ASK Database Management

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Fri, May 30, 2014 at 2:16 PM, Peter_Logan@spartanstores.com <
Peter_Logan@spartanstores.com> wrote:

> Is there any documentation relating to the:
>
> AUTO_TUNE_SIZE
> configuration parameter? As to what that can be set to, and what the
> values are of the other AUTO parameters based on this setting?
>
> Looked around and didn't find anything .. thanks in advance ...
>
> Peter Logan
> Database Administrator
> SpartanNash INC.
> Office: 616/878-8309
> Mobile: 616/304-9672
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--089e013d186aba299004faa2e05f

Messages In This Thread

• v12.10.fc3
  Peter_Logan@spartanstores.com -- Friday, 30 May 2014, at 2:16 p.m.
  • Re: v12.10.fc3
    Art Kagel -- Friday, 30 May 2014, at 3:16 p.m.
    • Re: v12.10.fc3
      Peter_Logan@spartanstores.com -- Friday, 30 May 2014, at 4:15 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.