Posted: Mon Feb 09, 2015 3:51 pm
Comparing the uvConfig Files on both Versions, I see the following differences between the 2 versions
Is it OK to change these configuration values or we need to contact IBM Support?
If we do change these in 9.1, do we have to Restart Datastage for these configuration changes to take effect?
v9.1 v7.5 Comment
MFILES 200 150
T30FILE 512 200
RLTABSZ 300 75
MAXRLOCK 299 74
NLSMODE 1 NA No NLS Setting in v7.5
# MFILES - specifies the size of the
# rotating file pool. The value of
# MFILES should be set to a value
# no greater than the kernels
# per process open file limit less the
# sum of the maximum number of named
# pipes opened by a user application
# and the 8 files reserved for internal
# use.
# T30FILE - specifies the number of
# dynamic files that may be opened.
# Used to allocate shared memory
# concurrency control headers.
# RLTABSZ - sets the number of read lock entries
# (both exclusive, READU, and shared, READL) in a
# group lock semaphore set. Great care should be
# exercised when changing this parameter. The
# performance of the disk i/o subsystem may be
# profoundly affected.
# MAXRLOCK - This defines the number of record locks which
# may be obtained against one file in an SQL transaction
# before the lock manager escalates the locking strategy
# to obtain a file lock. This value cannot be greater
# then RLTABSZ - 1.
# NLSMODE - Set to 1 if NLS mode is ON for the
# system as a whole. 0 means that NLS mode is OFF.
Is it OK to change these configuration values or we need to contact IBM Support?
If we do change these in 9.1, do we have to Restart Datastage for these configuration changes to take effect?
v9.1 v7.5 Comment
MFILES 200 150
T30FILE 512 200
RLTABSZ 300 75
MAXRLOCK 299 74
NLSMODE 1 NA No NLS Setting in v7.5
# MFILES - specifies the size of the
# rotating file pool. The value of
# MFILES should be set to a value
# no greater than the kernels
# per process open file limit less the
# sum of the maximum number of named
# pipes opened by a user application
# and the 8 files reserved for internal
# use.
# T30FILE - specifies the number of
# dynamic files that may be opened.
# Used to allocate shared memory
# concurrency control headers.
# RLTABSZ - sets the number of read lock entries
# (both exclusive, READU, and shared, READL) in a
# group lock semaphore set. Great care should be
# exercised when changing this parameter. The
# performance of the disk i/o subsystem may be
# profoundly affected.
# MAXRLOCK - This defines the number of record locks which
# may be obtained against one file in an SQL transaction
# before the lock manager escalates the locking strategy
# to obtain a file lock. This value cannot be greater
# then RLTABSZ - 1.
# NLSMODE - Set to 1 if NLS mode is ON for the
# system as a whole. 0 means that NLS mode is OFF.