Oninit cdi / Archive
Talk to an expert →

new onconfig parameters added onconfig file 11.5

Posted in 2010

Topics: High Availability & Replication, Performance & Tuning, Storage & Space Management, Server Administration

KARL OLIVER — — source: IIUG Forums & Mailing Lists

hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any at all. I assume the conversion process adds them at some stage below are the new parameters added to one instances onconfig file PLOG_OVERFLOW_PATH SBSPACETEMP MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 VP_MEMORY_CACHE_KB 0 SHMNOACCESS CONVERSION_GUARD 1 RESTORE_POINT_DIR /opt/informix_11.5/tmp BAR_DEBUG 0 BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 DD_HASHSIZE 31 DD_HASHMAX 10 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 1 STMT_CACHE_NUMPOOL 4294967295 BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default EXT_DIRECTIVES 0 BATCHEDREAD_TABLE 0 SECURITY_LOCALCONNECTION 0 UNSECURE_ONSTAT 0 ADMIN_USER_MODE_WITH_DBSA 0 SSL_KEYSTORE_LABEL PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 ENCRYPT_HDR 0 ENCRYPT_SMX 0 ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC medium ENCRYPT_MACFILE builtin ENCRYPT_SWITCH 0,0 CDR_SUPPRESS_ATSRISWARN HA_ALIAS UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK TEMPTAB_NOLOG 0 STORAGE_FULL_ALARM 600,3 QSTATS 0 WSTATS 0

↪ replying to KARL OLIVER
Art Kagel — — source: IIUG Forums & Mailing Lists

most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 4, 2010 at 5:57 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > hello folks > Can any one tell me at what stage the new onconfig parameters are added to > the > onconfig file when upgrading from 11.10 to 11.5. > I have converted two instances from 11.10 to 11.50 > One onconfig file has the new parameters at the end of the file the other > doesnt have any at all. > I assume the conversion process adds them at some stage > below are the new parameters added to one instances onconfig file > PLOG_OVERFLOW_PATH > SBSPACETEMP > MAX_INCOMPLETE_CONNECTIONS 1024 > FASTPOLL 1 > VP_MEMORY_CACHE_KB 0 > SHMNOACCESS > CONVERSION_GUARD 1 > RESTORE_POINT_DIR /opt/informix_11.5/tmp > BAR_DEBUG 0 > BACKUP_FILTER > RESTORE_FILTER > BAR_PERFORMANCE 0 > DD_HASHSIZE 31 > DD_HASHMAX 10 > DS_HASHSIZE 31 > DS_POOLSIZE 127 > PC_HASHSIZE 31 > PC_POOLSIZE 127 > STMT_CACHE 0 > STMT_CACHE_HITS 0 > STMT_CACHE_SIZE 512 > STMT_CACHE_NOLIMIT 1 > STMT_CACHE_NUMPOOL 4294967295 > BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default > EXT_DIRECTIVES 0 > BATCHEDREAD_TABLE 0 > SECURITY_LOCALCONNECTION 0 > UNSECURE_ONSTAT 0 > ADMIN_USER_MODE_WITH_DBSA 0 > SSL_KEYSTORE_LABEL > PLCY_POOLSIZE 127 > PLCY_HASHSIZE 31 > USRC_POOLSIZE 127 > USRC_HASHSIZE 31 > ENCRYPT_HDR 0 > ENCRYPT_SMX 0 > ENCRYPT_CDR 0 > ENCRYPT_CIPHERS > ENCRYPT_MAC medium > ENCRYPT_MACFILE builtin > ENCRYPT_SWITCH 0,0 > CDR_SUPPRESS_ATSRISWARN > HA_ALIAS > UPDATABLE_SECONDARY 0 > FAILOVER_CALLBACK > TEMPTAB_NOLOG 0 > STORAGE_FULL_ALARM 600,3 > QSTATS 0 > WSTATS 0> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00504502ae026941200485cbe74c

↪ replying to KARL OLIVER
Plugge, Joe — — source: IIUG Forums & Mailing Lists

Karl, Best practice is to always take the onconfig.std from the new version of the software and "port" your old ONCONFIG to it, so you will see all of the new (where applicable) parameters. If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG. Some of the old methods of setting existing params may also be deprecated, and the new version of the ONCONFIG will point you in the right direction there. Joe ________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] On Behalf Of KARL OLIVER [karl.oliver@maf.govt.nz] Sent: Tuesday, May 04, 2010 4:57 PM To: ids@iiug.org Subject: new onconfig parameters added onconfig file 11.5 [19994] hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any at all. I assume the conversion process adds them at some stage below are the new parameters added to one instances onconfig file PLOG_OVERFLOW_PATH SBSPACETEMP MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 VP_MEMORY_CACHE_KB 0 SHMNOACCESS CONVERSION_GUARD 1 RESTORE_POINT_DIR /opt/informix_11.5/tmp BAR_DEBUG 0 BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 DD_HASHSIZE 31 DD_HASHMAX 10 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 1 STMT_CACHE_NUMPOOL 4294967295 BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default EXT_DIRECTIVES 0 BATCHEDREAD_TABLE 0 SECURITY_LOCALCONNECTION 0 UNSECURE_ONSTAT 0 ADMIN_USER_MODE_WITH_DBSA 0 SSL_KEYSTORE_LABEL PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 ENCRYPT_HDR 0 ENCRYPT_SMX 0 ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC medium ENCRYPT_MACFILE builtin ENCRYPT_SWITCH 0,0 CDR_SUPPRESS_ATSRISWARN HA_ALIAS UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK TEMPTAB_NOLOG 0 STORAGE_FULL_ALARM 600,3 QSTATS 0 WSTATS 0 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary