Upgrade from 9.4 to 11.10
Kennedy, Randy
HP rp5405 (4 PA-8700 650MHz CPUs), 8GB ram, 4 drives (2 mirrored for
O/S, 2 mirrored for my Informix DB so only 1 spindle to work with)
HPUX 11.11
IDS 9.4FC3
We are getting an upgrade to 11.10FC2W4 (we don't get to choose
versions) and the onconfig parameters have changed some and I want to
ensure we are both using good parameter values overall and good
parameter values for the hardware we have (primarily are we using memory
to our fullest advantage). This server's only function is the Informix
DB. It only has 1 instance with 1 production DB and 4 copies of that DB
for development and testing usage. We only use ontape for our backups
(to a remote file system mount). All dbspaces are raw and we use
symbolic links to reference the actual devices.
I have listed our existing 9.4 onconfig as well as our proposed 11.10
onconfig. We are primarily OLTP during day and then run many DSS style
queries/mass updates via cron nightly. Our focus is to ensure the OLTP
performs well, if the DSS suffers, that is OK, we aren't running into
any issues with tasks not completing before next business day.
Any thoughts and/or recommendations would be greatly appreciated. I
will gladly provide any additional info that you may want/need (if I
know how to get it, I am not truly an IDS DBA or HPUX SA, but I have
managed to keep it running so far).
------------------------------------
9.4 current onconfig:
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /db/links/rootdbs # Path for device containing root
dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 384000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored
root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS physdbs # Location (dbspace) of physical log
PHYSFILE 60000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 85 # Number of logical log files
LOGSIZE 12000 # Logical log size (Kbytes)
LOG_BACKUP_MODE CONT
# Diagnostics
MSGPATH /i9.4/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /db/scripts/no_log.sh # Alarm program path
# System Archive Tape Device
#TAPEDEV /dev/rmt/2m # Tape device path
TAPEDEV /remote/recovery/informix/level0 # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 30000000 # Maximum amount of data to put on tape
(Kbytes)
# Log Archive Tape Device
#LTAPEDEV /dev/rmt/2m # Log tape device path
LTAPEDEV /ltape1/informix/log1 # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 4500000 # Max amount of data to put on log tape
(Kbytes)
# Optical
STAGEBLOB # INFORMIX-OnLine/Optical staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLine
instance
DBSERVERNAME courtshm # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No =
0)
NETTYPE soctcp,4,150,NET
NETTYPE ipcshm,1,25,NET
MULTIPROCESSOR 1 # 0 for single-processor, 1 for
multi-processor
NUMCPUVPS 16 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps
to one
NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 80000 # Maximum number of locks
BUFFERS 150000 # Maximum number of shared buffers
NUMAIOVPS 26 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 28 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 160000 # initial virtual shared memory segment
size
SHMADD 80000 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 20 # Number of LRU queues
LRU_MAX_DIRTY 5.000000 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark
percentage
LTXEHWM 60 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 128 # Stack size (Kbytes) #Changed from 64
to 128 per IBM's recommendation 12/14/2008
PC_POOLSIZE 110 # Stored Procedures Cache
DD_HASHSIZE 503 # added 12/14/2008 per IBM's
recommendation
DD_HASHMAX 4 # added 12/14/2008 per IBM's
recommendation
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 15 # Default number of offline worker
threads
ON_RECVRY_THREADS 15 # Default number of online worker
threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRINTERVAL 30 # DR max time between DR buffer flushes
(in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path
# Read Ahead Variables
RA_PAGES 64 # Number of pages to attempt to read
ahead
RA_THRESHOLD 8 # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tempdbs1,tempdbs2,tempdbs3,tempdbs4 # Default temp
dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information
which
# is preserved when an unanticipated error condition (assertion failure)
occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 0 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts
OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps
for
# a single user's session
# ADT*
# The following parameters control the type and level of secure auditing
# present in the OnLine system. By default, ADTMODE is 0 and auditing
# is disabled
FILLFACTOR 85 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get
time from OS(slow)
# Parallel Database Queries (pdq)
# OFF => 0, LOW => 1, HIGH => 100
MAX_PDQPRIORITY 90 # Maximum allowed pdqpriority
DS_MAX_QUERIES 15 # Maximum number of decision support
queries
DS_TOTAL_MEMORY 160000 # Decision support memory (Kbytes)
DS_MAX_SCANS 30 # Maximum number of decision support
scans
DATASKIP off
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 0 # Dbspace down option: 0 = CONTINUE, 1 =
ABORT, 2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads
(per-cpu-vp,additional)
CDR_DSLOCKWAIT 10 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR
queue (Kbytes)
BAR_ACT_LOG /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
HETERO_COMMIT 0
SYSALARMPROGRAM /i9.4/informix/etc/evidence.sh # System Alarm program
path
TBLSPACE_STATS 1
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0
none, 9 max)
ISM_DATA_POOL ISMData # If the data pool name is changed, be
sure to
ISM_LOG_POOL ISMLogs
OPT_GOAL -1
DIRECTIVES 1
RESTARTABLE_RESTORE off
BAR_PROGRESS_FREQ 0
SBSPACENAME # Default smartblob space name - this is
where blobs
SYSSBSPACENAME # Default smartblob space for use by the
Informix
BLOCKTIMEOUT 3600 # Default timeout for system block
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or
anything but 1)
JVPJAVAHOME # JRE installation root directory
JVPHOME # Krakatoa installation directory
JVPPROPFILE .jvpprops # JVP property file
JDKVERSION # JDK version supported by this server
JVMTHREAD green # Java VM thread type (green or native)
JVPJAVALIB
JVPJAVAVM libjava.so
JVPCLASSPATH
JVPLOGFILE jvp.log # JVP log file.
DYNAMIC_LOGS 2
CDR_SERIAL 0,0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as
catalog)
CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces
CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by
default
BAR_DEBUG_LOG /tmp/bar_dbug.log # ON-Bar Debug Log - not in /tmp
please
------------------------------------------------------------------------
------------------------------
Proposed 11.10 onconfig:
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /db/links/rootdbs # Path for device containing root
dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 384000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored
root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS physdbs # Location (dbspace) of physical log
PHYSFILE 60000 # Physical log file size (Kbytes)
PHYSBUFF 128 # Physical log buffer size (Kbytes)
# Logical Log Configuration
LOGFILES 85 # Number of logical log files
LOGSIZE 12000 # Logical log size (Kbytes)
LOG_BACKUP_MODE CONT
DYNAMIC_LOGS 2 # Add logical logs files
dynamically/automatically - newly added for 11.1
LOGBUFF 64 # Logical log buffer size (Kbytes)
# Long Transaction Rollback
LTXHWM 70 # Long transaction high water mark
percentage
LTXEHWM 80 # Long transaction high water mark
(exclusive)
#Tblspace tblspace in Root dbspace
TBLTBLFIRST 0 # First extent size (Kbytes) (0 =
default)
TBLTBLNEXT 0 # Next extent size (Kbytes) (0 =
default)
TBLSPACE_STATS 1
# Diagnostics
MSGPATH /i11.1FC2W4/informix/online.log # System message log
file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /db/scripts/no_log.sh # Alarm program path
# System Archive Tape Device
#TAPEDEV /dev/rmt/2m # Tape device path
TAPEDEV / /remote/recovery/informix/level0 # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 30000000 # Maximum amount of data to put on tape
(Kbytes)
# Log Archive Tape Device
#LTAPEDEV /dev/rmt/2m # Log tape device path
LTAPEDEV /ltape1/informix/log1 # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 4500000 # Max amount of data to put on log tape
(Kbytes)
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine
instance
DBSERVERNAME courtshm # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
#Network Configuration
NETTYPE soctcp,4,150,NET
NETTYPE ipcshm,1,25,NET
FASTPOLL 1 # fast polling enabled - added for 11.1
LISTEN_TIMEOUT 30 # Timeout (in Seconds)
#CPU & VPs
RESIDENT 0 # Forced residency flag (Yes = 1, No =
0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for
multi-processor
#NUMCPUVPS 16 # Number of user (cpu) vps
SINGLE_CPU_VP 0 #multiple CPU VPs
VPCLASS cpu,num=16,noage #
#NUMAIOVPS 2 # Number of IO vps
VPCLASS aio,num=2
AUTO_AIOVPS 1 # auto adds AIO VPs if needed.
VPCLASS idsxmlvp,num=1 # for xml function usage
DIRECT_IO 0 # enabled (Yes = 1, No = 0) will use
KAIO if enabled.
CLEANERS 2 # Number of buffer cleaner processes
(guideline is 1 per disk drive)
#NOAGE 1 # Process aging
#AFF_SPROC 0 # Affinity start processor
#AFF_NPROCS 0 # Affinity number of processors
# Shared Memory #BUFFERPOOL - replaces buffers, lrus, lru_min_dirty, &
lru_mas_dirty - needs two lines
BUFFERPOOL
size=2K,buffers=150000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.0
00000
AUTO_LRU_TUNING 1
LOCKS 200000 # Maximum number of locks
#BUFFERS 150000 # Maximum number of shared buffers -
not used in 11.1
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 160000 # initial virtual shared memory segment
size
SHMADD 80000 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
EXTSHMADD 8192 # Size of new extension shared memory
segments (Kbytes)
SHMVIRT_ALLOCSEG 0.000000 # Values between 0 and .99 are %,
values > 1 are
#LRUS 20 # Number of LRU queues
#LRU_MAX_DIRTY 5.000000 # LRU percent dirty begin cleaning
limit
#LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit
PC_POOLSIZE 110 # Stored Procedures Cache
#Checkpoints & System Block
CKPTINTVL 300 # Check point interval (in sec)
AUTO_CKPTS 1 # Monitor critical resources and trigger
RTO_SERVER_RESTART 0 # Recovery Time Objective for IDS
restart after
BLOCKTIMEOUT 3600 # Default timeout for system block
#OS & Session Features
USEOSTIME 0 # 0: use internal time(fast), 1: get
time from OS(slow)
STACKSIZE 128 # Stack size (Kbytes)
USELASTCOMMITTED NONE # Wait on locks in any isolation level
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or
anything but 1)
EILSEQ_COMPAT_MODE 0 # Enables error message -202
#Distributed Transactions
TXTIMEOUT 300 # Transaction timeout (in sec)
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
distributed env.
HETERO_COMMIT 0
# Recovery Variables
# OFF_RECVRY_THREADS: # Number of parallel worker threads during fast
recovery or an offline restore.
# ON_RECVRY_THREADS: # Number of parallel worker threads during an
online restore.
OFF_RECVRY_THREADS 15 # Default number of offline worker
threads
ON_RECVRY_THREADS 15 # Default number of online worker
threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRINTERVAL 30 # DR max time between DR buffer flushes
(in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path
# Read Ahead Variables
RA_PAGES 64 # Number of pages to attempt to read
ahead
RA_THRESHOLD 16 # Number of pages left before next group
#Temp & Perm dbspaces & sbspaces
DBSPACETEMP tempdbs1,tempdbs2,tempdbs3,tempdbs4 # Default temp
dbspaces
ONDBSPACEDOWN 0 # Dbspace down option: 0 = CONTINUE, 1 =
ABORT, 2 = WAIT for User Input
SBSPACENAME # Default smartblob space name - this is
where blobs
SYSSBSPACENAME # Default smartblob space for use by the
Informix
# DUMP*:
# The following parameters control the type of diagnostics information
which
# is preserved when an unanticipated error condition (assertion failure)
occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 0 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts
OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps
for a single user's session
# ADT*
# The following parameters control the type and level of secure auditing
# present in the OnLine system. By default, ADTMODE is 0 and auditing
# is disabled
#Index Features
FILLFACTOR 90 # Fill factor for building indexes
MAX_FILL_DATA_PAGES 0 # Fill data pages maximally (Yes =
1, No = 0)
ONLIDX_MAXMEM 5120 # Per pool per index (Kbytes)
# Parallel Database Queries (pdq) # OFF => 0, LOW => 1, HIGH => 100
MAX_PDQPRIORITY 90 # Maximum allowed pdqpriority
DS_MAX_QUERIES 15 # Maximum number of decision support
queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 250 # Maximum number of decision support
scans
DATASKIP off
DS_NONPDQ_QUERY_MEM 128 # Non PDQ query memory (Kbytes)
#Optimizer Plans, Directives, & SQL Tracing
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where possible) over
sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not "repeatable read",
optimizer behaves as in (2) below. Otherwise it behaves as in (0)
above.
# 2 => Use costs regardless of the transaction isolation mode. Nested
loop joins are not necessarily preferred. Optimizer bases its decision
purely on costs.
OPTCOMPIND 2 # To hint the optimizer
OPT_GOAL -1 # Optimize for all rows that the query
returns
DIRECTIVES 1 # Enable optimizer directives
IFX_FOLDVIEW 0 # fold multiple tables or union all view
with ansi joins
EXPLAIN_STAT 1 # Enable Query Statistics in EXPLAIN
file.
AUTO_REPREPARE 1 # Automatically re-optimize after DDL
#Optical Storage Subsystem
STAGEBLOB # INFORMIX-OnLine/Optical staging area
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
#Onbar settings
BAR_ACT_LOG /tmp/bar_act.log
BAR_DEBUG_LOG /tmp/bar_dbug.log # ON-Bar Debug Log - not in /tmp
please
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
BAR_PROGRESS_FREQ 0
RESTARTABLE_RESTORE off
#Alarm Program Feature
SYSALARMPROGRAM /i11.1FC2W4/informix/etc/evidence.sh
# System Alarm program path
ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event
occur
#Informix Storage Manager
ISM_DATA_POOL ISMData # If the data pool name is changed, be
sure to
ISM_LOG_POOL ISMLogs
#Java Configuration
JVPJAVAHOME /i11.1FC2W4/informix/extend/krakatoa/jre/
# JRE installation root directory
JVPHOME /i11.1FC2W4/informix/extend/krakatoa/
# Krakatoa installation directory
JVPPROPFILE .jvpprops # JVP property file
JDKVERSION # JDK version supported by this server
JVMTHREAD green # Java VM thread type (green or native)
JVPJAVALIB
JVPJAVAVM libjava.so
JVPCLASSPATH
JVPLOGFILE /i11.1FC2W4/informix/jvp.log # JVP log file.
#Other ER Features
CDR_SERIAL 0,0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as
catalog)
CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces
CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by
default
CDR_EVALTHREADS 1,2 # evaluator threads
(per-cpu-vp,additional)
CDR_DSLOCKWAIT 10 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR
queue (Kbytes)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0
none, 9 max)
#Security
IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role.
#High Availability Clusters (HDR, SDS, & RSS)
DRAUTO 0 # DR automatic switchover
DRIDXAUTO 0 # DR automatic index repair. 0=off, 1=on
LOG_INDEX_BUILDS 0 # logically log content of indexes
SDS_ENABLE 0 # SDS Activation 0 - no, 1 - yes
SDS_TIMEOUT 10 # Time Delay that Primary will wait for
any ACK
SDS_PAGING # Paging File Location
#Technical Support Parameters
RAS_PLOG_SPEED 0 # IDS RAS param; do not change; auto
updated
RAS_LLOG_SPEED 561 # IDS RAS param; do not change; auto
updated
Thanks in advance,
Randy
LIGHT SCANS
Are you upgrading your hardware, too? If not, then what you have is
good (I looked at it fast so I may be missed a few things). I
personally like 1 cpuVP per real cpu (or core) for simplicity and
price (4 informix licenses instead of 16) but only if performance
stays about the same. Your 5 databases in one instance scares me but
you probably don't have a choice in that matter. If you are migrating
to new hardware, then consider just using your production on it (drop
the other DB's) and keep your old (hopefully upgraded) hardware for
test and development.
And for your DSS queries, try invoking LIGHT SCANS with "export
LIGHT_SCANS=FORCE", "SET ISOLATION TO DIRTY READ" and "SET PDQPRIORITY
0".
-L.S.
Art Kagel
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (a...@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Kennedy, Randy
Thanks,
Randy
From: informix-l...@iiug.org [mailto:informix-l...@iiug.org] On Behalf Of Art Kagel
Sent: Tuesday, November 10, 2009 1:42 PM
To: LIGHT SCANS
Cc: inform...@iiug.org
Subject: Re: Upgrade from 9.4 to 11.10
FYI, IBM licenses Informix on the number of cores available on the system NOT the number of CPU VPs you run. If there are 16 cores you pay 16 PVU licenses priced at the number of PVUs each at which the processor is rated. That's regardless of whether you run 1 CPU VP only or 100 CPU VPs per core, the licensing is the same. The only thing you can do is to define a virtual environment which only has access to N cores rather than all of the cores on the system and run the engine within that environment. In that case IBM permits what is known as sub-capacity licensing of the number of virtual CPU cores that the VM is configured to access.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (a...@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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, Nov 10, 2009 at 3:14 PM, LIGHT SCANS <light...@yahoo.com> wrote:
Hello Randy,
-L.S.
Nick
a total of 1Gig. IDS 11 prefers larger log files so that it does not
fill and switch too quickly (which might occur during the batch
processes). It will give you a warning in the alert log when/if that
happens.
>
> # Logical Log Configuration
> LOGFILES 85 # Number of logical log files
> LOGSIZE 12000 # Logical log size (Kbytes)
Nick
Kennedy, Randy
Thanks,
Randy
-----Original Message-----
From: informix-l...@iiug.org [mailto:informix-l...@iiug.org] On Behalf Of Nick
Sent: Wednesday, November 11, 2009 7:27 AM
To: inform...@iiug.org
Subject: Re: Upgrade from 9.4 to 11.10
Nick
Art Kagel
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (a...@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Can I just change the values and it take effect when I restart the engine as 11.10 and it will take care of the moving from old style to new style during the upgrade portion of initialization?
Thanks,
Randy
-----Original Message-----
From: informix-l...@iiug.org [mailto:informix-l...@iiug.org] On Behalf Of Nick
Sent: Wednesday, November 11, 2009 7:27 AM
To: inform...@iiug.org
Subject: Re: Upgrade from 9.4 to 11.10