v12.10.fc3

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

Here: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/id s_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

Thanks Art .... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 05/30/2014 03:16 PM Subject: Re: v12.10.fc3 [33127] Sent by: ids-bounces@iiug.org Here: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/id s_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 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.