IDS 11 sds problem
Hi:
I installed IDS sds in SUN OS 5.9, I initialize the primary and SDS server
successful. I could execute some query from SDS server, But after I ran some
applicaton in the primary server, The sds server disconnect from the primary
server. In the online.log , IDS report the following error:
12:00:15 Adjusting LRU for bufferpool - id 0 size 2k
12:00:15 Old max 55.9 min 46.6 New max 55.9 min 46.6
12:00:16 ERROR: Removing SDS Node JSPMDBSDS has timed out - removing
12:00:17 SDS Server JSPMDBSDS - state is now disconnected
12:00:21 Checkpoint Completed: duration was 46 seconds.
I cann't query the data from the primary server.
The Primary server configuration are listed in following.
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2007. All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
# Warning: Always verify ROOTPATH before performing
# disk initialization (oninit -i/-iy) to
# avoid disk corruption of another instance
ROOTNAME rootdbs # Root dbspace nameROOTPATH /opt/informix/chunk/rootdbs # Path for device containing root dbspace
ROOTOFFSET 500 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # 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 logdbs # Location (dbspace) of physical log
PHYSFILE 200000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 93 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
# Tablespace Tablespace Configuration in Root Dbspace
TBLTBLFIRST 0 # First extent size (Kbytes) (0 = default)
TBLTBLNEXT 0 # Next extent size (Kbytes) (0 = default)
# Security
# DBCREATE_PERMISSION:
# By default any user can create a database. Uncomment DBCREATE_PERMISSON to
# limit database creation to a specific user. Add a new DBCREATE_PERMISSION
# line for each permitted user.
#DBCREATE_PERMISSION informix
# DB_LIBRARY_PATH:
# When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that
# the user-specified path starts with one of the directory prefixes listed in
# the comma-separated list of prefixes in DB_LIBRARY_PATH. The string
# "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for
# extensibility and IBM supplied blades to work correctly.
# DB_LIBRARY_PATH $INFORMIXDIR/extend
# IFX_EXTEND_ROLE:
# 0 (or off) => Disable use of EXTEND role to control who can register
# external routines.
# 1 (or on) => Enable use of EXTEND role to control who can register
# external routines. This is the default behaviour.
#
IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role.
# EILSEQ_COMPAT_MODE:
# When processing characters, IDS checks if the characters are valid
# for the locale and returns error -202 if they are not. This causes
# problems in some applications. This parameter preserves the old
# behavior and permits these characters.
# 0 => Disallow illegal characters. This is the default behavior.
# 1 => Allow illegal characters.
#
EILSEQ_COMPAT_MODE 0
#
# ADMIN_MODE_USERS
# This is a comma separated list of those users who can connect to the
# IDS server while it is in single user mode. This list of users is in
# addition user informix.
#
# Example:
# ADMIN_MODE_USERS usera,userb,userc
#
# ADMIN_MODE_USERS
# Diagnostics
MSGPATH /opt/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
#ALARMPROGRAM /opt/informix/etc/no_log.sh # Alarm program path
ALARMPROGRAM /opt/informix/etc/alarmprogram.sh # Alarm program path
ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event occur
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 32 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 32 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 100 # Unique id corresponding to a OnLine instance
DBSERVERNAME JSPMDB # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE tlitcp,10,60,NET # Configure poll thread(s) for nettype
NETTYPE ipcshm,1,50,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 11 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 8000000 # Maximum number of locks
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
CLEANERS 64 # Number of buffer cleaner processes
SHMBASE 0x10A000000L # Shared memory base address
SHMVIRTSIZE 419600 # initial virtual shared memory segment size
SHMADD 256000 # Size of new shared memory segments (Kbytes)
EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
SHMVIRT_ALLOCSEG 0 # Values between 0 and .99 are %, values > 1 are
# KB - when this much virtual memory is used we
# try to get a new segment. 0 means "off". 2nd
# parameter is alarm level
CKPTINTVL 900 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 512 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON)
# 1 : notify DBA to add new logical logs when necessary. (ON)
# 0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
#
# In case of system configured with C
We need to see the online log files.
Also since you are internal - let's communicate via the internal method=
s.
M.P.
=
"CHUAN LU" =
<luchuan@cn.ibm.c =
om> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
IDS 11 sds problem [9951] =
09/13/2007 11:12 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi:
I installed IDS sds in SUN OS 5.9, I initialize the primary and SDS ser=
ver
successful. I could execute some query from SDS server, But after I ran=
some
applicaton in the primary server, The sds server disconnect from the
primary
server. In the online.log , IDS report the following error:
12:00:15 Adjusting LRU for bufferpool - id 0 size 2k
12:00:15 Old max 55.9 min 46.6 New max 55.9 min 46.6
12:00:16 ERROR: Removing SDS Node JSPMDBSDS has timed out - removing
12:00:17 SDS Server JSPMDBSDS - state is now disconnected
12:00:21 Checkpoint Completed: duration was 46 seconds.
I cann't query the data from the primary server.
The Primary server configuration are listed in following.
#**********************************************************************=
****
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2007. All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**********************************************************************=
****
# Root Dbspace Configuration
# Warning: Always verify ROOTPATH before performing
# disk initialization (oninit -i/-iy) to
# avoid disk corruption of another instance
ROOTNAME rootdbs # Root dbspace nameROOTPATH /opt/informix/chunk/rootdbs # Path for device containing root
dbspace
ROOTOFFSET 500 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes =3D 1, No =3D 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS logdbs # Location (dbspace) of physical log
PHYSFILE 200000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 93 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
# Tablespace Tablespace Configuration in Root Dbspace
TBLTBLFIRST 0 # First extent size (Kbytes) (0 =3D default)
TBLTBLNEXT 0 # Next extent size (Kbytes) (0 =3D default)
# Security
# DBCREATE_PERMISSION:
# By default any user can create a database. Uncomment DBCREATE_PERMISS=
ON
to
# limit database creation to a specific user. Add a new DBCREATE_PERMIS=
SION
# line for each permitted user.
#DBCREATE_PERMISSION informix
# DB_LIBRARY_PATH:
# When loading a (C or C++) shared object (for a UDR or UDT), IDS check=
s
that
# the user-specified path starts with one of the directory prefixes lis=
ted
in
# the comma-separated list of prefixes in DB_LIBRARY_PATH. The string
# "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order fo=
r
# extensibility and IBM supplied blades to work correctly.
# DB_LIBRARY_PATH $INFORMIXDIR/extend
# IFX_EXTEND_ROLE:
# 0 (or off) =3D> Disable use of EXTEND role to control who can registe=
r
# external routines.
# 1 (or on) =3D> Enable use of EXTEND role to control who can register
# external routines. This is the default behaviour.
#
IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role.
# EILSEQ_COMPAT_MODE:
# When processing characters, IDS checks if the characters are valid
# for the locale and returns error -202 if they are not. This causes
# problems in some applications. This parameter preserves the old
# behavior and permits these characters.
# 0 =3D> Disallow illegal characters. This is the default behavior.
# 1 =3D> Allow illegal characters.
#
EILSEQ_COMPAT_MODE 0
#
# ADMIN_MODE_USERS
# This is a comma separated list of those users who can connect to the
# IDS server while it is in single user mode. This list of users is in
# addition user informix.
#
# Example:
# ADMIN_MODE_USERS usera,userb,userc
#
# ADMIN_MODE_USERS
# Diagnostics
MSGPATH /opt/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=3DY
#ALARMPROGRAM /opt/informix/etc/no_log.sh # Alarm program path
ALARMPROGRAM /opt/informix/etc/alarmprogram.sh # Alarm program path
ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event occur
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 32 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 32 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 100 # Unique id corresponding to a OnLine instance
DBSERVERNAME JSPMDB # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE tlitcp,10,60,NET # Configure poll thread(s) for nettype
NETTYPE ipcshm,1,50,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes =3D 1, No =3D 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 11 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 8000000 # Maximum number of locks
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
CLEANERS 64 # Number of buffer cleaner processes
SHMBASE 0x10A000000L # Shared memory base address
SHMVIRTSIZE 419600 # initial virtual shared memory segment size
SHMADD 256000 # Size of new shared memory segments (Kbytes)
EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=3D>unlimited
SHMVIRT_ALLOCSEG 0 # Values between 0 and .99 are %, values > 1 are
# KB - when this much virtual memory is used we
# try to get a new segment. 0 means "off". 2nd
# parameter is alarm level
CKPTINTVL 900 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 512 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new l