Informix Freeze or Down
Hi All,
I need the group help on this issue (Informix support doesn't seems to
help).
OS is window2000
RAM 3GB
2 CPU
Informix 7.31 TD3.1
For some reason informix cannot accept new connections or serve
existing connections. No command except onstat -???? is working.
The only way to continue is to restart the server.
Cannot stop the informix services.
I have been running the onstat -a command while this append but really
i cannot say what is the problem.
This happens random ones every week.
I attached the onconfig file and the onstat -a output .
The server is running only informix.
Any help or guides will be more then appreciate
Thanks
Shay
;---------Onstat -a ----------------------------------------------
Informix Dynamic Server Version 7.31.TD1 -- On-Line -- Up 4 days
00:13:03 -- 621376 Kbytes
Message Log File: C:\\informix\\paxys.log
in stored procedure cannot be executed because user "informix" did not
connect
with a password.
12:31:59 Checkpoint Completed: duration was 0 seconds.
12:31:59 Checkpoint loguniq 11118, logpos 0x232018
12:32:18 Logical Log 11118 Complete.
12:32:18 Logical Log 11118 - Backup Started
12:32:18 Logical Log 11118 - Backup Completed
12:35:01 System() command "onmode -z 4636"in stored procedure cannot be executed because user "informix" did not
connect
with a password.
12:35:01 System() command "echo 'sesid=4636 pnr_no=0 dur=S
sesstart=2003-12-15 05:41:39"in stored procedure cannot be executed because user "informix" did not
connect
with a password.
12:35:17 Logical Log 11119 Complete.
12:35:17 Logical Log 11119 - Backup Started
12:35:18 Logical Log 11119 - Backup Completed
12:37:26 Checkpoint Completed: duration was 0 seconds.log12:37:26 Checkpoint uniq 11120, logpos 0x10f018
Configuration File: C:\\informix/etc/ONCONFIG.paxys
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH d:\\IFMXDATA\\paxys\\rootdbs # Path for device containing rootdbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 700000 # 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 rootdbs # Location (dbspace) of physical log
PHYSFILE 15000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 30 # Number of logical log files
LOGSIZE 3000 # Logical log size (Kbytes)LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL,
CONT)
# Diagnostics
MSGPATH C:\\informix\\paxys.log # System message log file path
CONSOLE C:\\informix\\conpaxys.log # System console message path
ALARMPROGRAM # Alarm program path
# System Diagnostic Script.
# SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
# c:\\informix\\etc\\evidence.bat.) Set this parameter
# if you want a different Diagnostic Script than
# {INFORMIXDIR}\\etc\\evidence.bat, which is default.
# System Archive Tape Device
TAPEDEV x:\\informix_backup\\backup # Tape device path
#TAPEDEV nul # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 100000000 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV x:\\informix_backup\\daily # Log tape device path
#LTAPEDEV nul # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 20000000 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical
staging area
OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL
# System Configuration
SERVERNUM 1 # Unique id corresponding to a server instancestance
DBSERVERNAME paxys # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE onsoctcp,1,50,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one
NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 128000 # Maximum number of locks
BUFFERS 100000 # Maximum number of shared buffers
NUMAIOVPS 1 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 30 # Maximum number of logical log files
CLEANERS 9 # Number of buffer cleaner processes
SHMBASE 0xC000000L # Shared memory base address
SHMVIRTSIZE 30720 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 0 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration
parameter.
# To determine the page size used by Dynamic Server 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 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND \\tmp # DR lost+found file path
# CDR Variables
CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue@
It seems there is some procedure which is owned by Informix. Check-out
is there any stored procedure.
Thanks
Zafar
shay@formula-travel.com (shay) wrote in message news:<c08a9d47.0312150910.29e904ef@posting.google.com>...
> Hi All,
>
> I need the group help on this issue (Informix support doesn't seems to
> help).
> OS is window2000
> RAM 3GB
> 2 CPU
> Informix 7.31 TD3.1
> For some reason informix cannot accept new connections or serve
> existing connections. No command except onstat -???? is working.
> The only way to continue is to restart the server.
> Cannot stop the informix services.
>
> I have been running the onstat -a command while this append but really
> i cannot say what is the problem.
>
> This happens random ones every week.
>
> I attached the onconfig file and the onstat -a output .
> The server is running only informix.
>
> Any help or guides will be more then appreciate
>
> Thanks
>
> Shay
>
> ;---------Onstat -a ----------------------------------------------
>
> Informix Dynamic Server Version 7.31.TD1 -- On-Line -- Up 4 days
> 00:13:03 -- 621376 Kbytes
>
> Message Log File: C:\\informix\\paxys.log
> in stored procedure cannot be executed because user "informix" did not
> connect
> with a password.
> 12:31:59 Checkpoint Completed: duration was 0 seconds.
> 12:31:59 Checkpoint loguniq 11118, logpos 0x232018
>
> 12:32:18 Logical Log 11118 Complete.
> 12:32:18 Logical Log 11118 - Backup Started
> 12:32:18 Logical Log 11118 - Backup Completed
> 12:35:01 System() command "onmode -z 4636"> in stored procedure cannot be executed because user "informix" did not
> connect
> with a password.
> 12:35:01 System() command "echo 'sesid=4636 pnr_no=0 dur=S
> sesstart=2003-12-15 05:41:39"> in stored procedure cannot be executed because user "informix" did not
> connect
> with a password.
> 12:35:17 Logical Log 11119 Complete.
> 12:35:17 Logical Log 11119 - Backup Started
> 12:35:18 Logical Log 11119 - Backup Completed
> 12:37:26 Checkpoint Completed: duration was 0 seconds.> log12:37:26 Checkpoint uniq 11120, logpos 0x10f018
>
>
> Configuration File: C:\\informix/etc/ONCONFIG.paxys
> #**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: Informix Dynamic Server Configuration Parameters
> #
> #**************************************************************************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH d:\\IFMXDATA\\paxys\\rootdbs # Path for device containing root> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
> ROOTSIZE 700000 # 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 rootdbs # Location (dbspace) of physical log
> PHYSFILE 15000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 30 # Number of logical log files
> LOGSIZE 3000 # Logical log size (Kbytes)> LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL,
> CONT)
>
> # Diagnostics
>
> MSGPATH C:\\informix\\paxys.log # System message log file path
> CONSOLE C:\\informix\\conpaxys.log # System console message path
> ALARMPROGRAM # Alarm program path>
> # System Diagnostic Script.
> # SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
> # c:\\informix\\etc\\evidence.bat.) Set this parameter
> # if you want a different Diagnostic Script than
> # {INFORMIXDIR}\\etc\\evidence.bat, which is default.
>
> # System Archive Tape Device
>
> TAPEDEV x:\\informix_backup\\backup # Tape device path
> #TAPEDEV nul # Tape device path
> TAPEBLK 16 # Tape block size (Kbytes)
> TAPESIZE 100000000 # Maximum amount of data to put on tape (Kbytes)>
> # Log Archive Tape Device
>
> LTAPEDEV x:\\informix_backup\\daily # Log tape device path
> #LTAPEDEV nul # Log tape device path
> LTAPEBLK 16 # Log tape block size (Kbytes)
> LTAPESIZE 20000000 # Max amount of data to put on log tape (Kbytes)>
> # Optical
>
> STAGEBLOB # Informix Dynamic Server/Optical
> staging area
> OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL
>
> # System Configuration
>
> SERVERNUM 1 # Unique id corresponding to a server instance> stance
> DBSERVERNAME paxys # Name of default Dynamic Server
> DBSERVERALIASES # List of alternate dbservernames
> NETTYPE onsoctcp,1,50,NET # Override sqlhosts nettype parameters
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
> RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
>
> MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor
> NUMCPUVPS 2 # 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 128000 # Maximum number of locks
> BUFFERS 100000 # Maximum number of shared buffers
> NUMAIOVPS 1 # Number of IO vps
> PHYSBUFF 64 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 30 # Maximum number of logical log files
> CLEANERS 9 # Number of buffer cleaner processes
> SHMBASE 0xC000000L # Shared memory base address
> SHMVIRTSIZE 30720 # initial virtual shared memory segment size
> SHMADD 8192 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 8 # Number of LRU queues
> LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 0 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark percentage
> LTXEHWM 60 # Long transaction high water mark (exclusive)
> TXTIMEOUT 300 # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> # System Page Size
> # BUFFSIZE - Dynamic Server no longer supports this configuration
> parameter.
> # To determine the page size used by Dynamic Server 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 10 # Default number of offline worker threads
> ON_RECVRY_THREADS 1 # Default number of online worker threads>
>
Hi Zafar,
Thanks for the fast replay, All my procedures are owned by informix
and this works fine for all our customers.
The problem is random and i cannot point to specific action on the
server to perform this action.
The stringed thing is that i cannot activate informix commands accept
onstat ??? command.
The CPU is free while this append , and memory also.
Need help urgent,
Thanks
Shay
mazafar4@ureach.com (Zafar) wrote in message news:<b9f918b9.0312151414.1abe09b8@posting.google.com>...
> It seems there is some procedure which is owned by Informix. Check-out
> is there any stored procedure.
>
> Thanks
> Zafar
> shay@formula-travel.com (shay) wrote in message news:<c08a9d47.0312150910.29e904ef@posting.google.com>...
> > Hi All,
> >
> > I need the group help on this issue (Informix support doesn't seems to
> > help).
> > OS is window2000
> > RAM 3GB
> > 2 CPU
> > Informix 7.31 TD3.1
> > For some reason informix cannot accept new connections or serve
> > existing connections. No command except onstat -???? is working.
> > The only way to continue is to restart the server.
> > Cannot stop the informix services.
> >
> > I have been running the onstat -a command while this append but really
> > i cannot say what is the problem.
> >
> > This happens random ones every week.
> >
> > I attached the onconfig file and the onstat -a output .
> > The server is running only informix.
> >
> > Any help or guides will be more then appreciate
> >
> > Thanks
> >
> > Shay
> >
> > ;---------Onstat -a ----------------------------------------------
> >
> > Informix Dynamic Server Version 7.31.TD1 -- On-Line -- Up 4 days
> > 00:13:03 -- 621376 Kbytes
> >
> > Message Log File: C:\\informix\\paxys.log
> > in stored procedure cannot be executed because user "informix" did not
> > connect
> > with a password.
> > 12:31:59 Checkpoint Completed: duration was 0 seconds.
> > 12:31:59 Checkpoint loguniq 11118, logpos 0x232018
> >
> > 12:32:18 Logical Log 11118 Complete.
> > 12:32:18 Logical Log 11118 - Backup Started
> > 12:32:18 Logical Log 11118 - Backup Completed
> > 12:35:01 System() command "onmode -z 4636"> > in stored procedure cannot be executed because user "informix" did not
> > connect
> > with a password.
> > 12:35:01 System() command "echo 'sesid=4636 pnr_no=0 dur=S
> > sesstart=2003-12-15 05:41:39"> > in stored procedure cannot be executed because user "informix" did not
> > connect
> > with a password.
> > 12:35:17 Logical Log 11119 Complete.
> > 12:35:17 Logical Log 11119 - Backup Started
> > 12:35:18 Logical Log 11119 - Backup Completed
> > 12:37:26 Checkpoint Completed: duration was 0 seconds.> > log12:37:26 Checkpoint uniq 11120, logpos 0x10f018
> >
> >
> > Configuration File: C:\\informix/etc/ONCONFIG.paxys
> > #**************************************************************************
> > #
> > # INFORMIX SOFTWARE, INC.
> > #
> > # Title: onconfig.std
> > # Description: Informix Dynamic Server Configuration Parameters
> > #
> > #**************************************************************************
> >
> > # Root Dbspace Configuration
> >
> > ROOTNAME rootdbs # Root dbspace name
> > ROOTPATH d:\\IFMXDATA\\paxys\\rootdbs # Path for device containing root> > dbspace
> > ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
> > ROOTSIZE 700000 # 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 rootdbs # Location (dbspace) of physical log
> > PHYSFILE 15000 # Physical log file size (Kbytes)> >
> > # Logical Log Configuration
> >
> > LOGFILES 30 # Number of logical log files
> > LOGSIZE 3000 # Logical log size (Kbytes)> > LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL,
> > CONT)
> >
> > # Diagnostics
> >
> > MSGPATH C:\\informix\\paxys.log # System message log file path
> > CONSOLE C:\\informix\\conpaxys.log # System console message path
> > ALARMPROGRAM # Alarm program path> >
> > # System Diagnostic Script.
> > # SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
> > # c:\\informix\\etc\\evidence.bat.) Set this parameter
> > # if you want a different Diagnostic Script than
> > # {INFORMIXDIR}\\etc\\evidence.bat, which is default.
> >
> > # System Archive Tape Device
> >
> > TAPEDEV x:\\informix_backup\\backup # Tape device path
> > #TAPEDEV nul # Tape device path
> > TAPEBLK 16 # Tape block size (Kbytes)
> > TAPESIZE 100000000 # Maximum amount of data to put on tape (Kbytes)> >
> > # Log Archive Tape Device
> >
> > LTAPEDEV x:\\informix_backup\\daily # Log tape device path
> > #LTAPEDEV nul # Log tape device path
> > LTAPEBLK 16 # Log tape block size (Kbytes)
> > LTAPESIZE 20000000 # Max amount of data to put on log tape (Kbytes)> >
> > # Optical
> >
> > STAGEBLOB # Informix Dynamic Server/Optical
> > staging area
> > OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL
> >
> > # System Configuration
> >
> > SERVERNUM 1 # Unique id corresponding to a server instance> > stance
> > DBSERVERNAME paxys # Name of default Dynamic Server
> > DBSERVERALIASES # List of alternate dbservernames
> > NETTYPE onsoctcp,1,50,NET # Override sqlhosts nettype parameters
> > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
> > RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
> >
> > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> > multi-processor
> > NUMCPUVPS 2 # 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 128000 # Maximum number of locks
> > BUFFERS 100000 # Maximum number of shared buffers
> > NUMAIOVPS 1 # Number of IO vps
> > PHYSBUFF 64 # Physical log buffer size (Kbytes)
> > LOGBUFF 32 # Logical log buffer size (Kbytes)> > LOGSMAX 30 # Maximum number of logical log files
> > CLEANERS 9 # Number of buffer cleaner processes
> > SHMBASE 0xC000000L # Shared memory base address
> > SHMVIRTSIZE 30720 # initial virtual shared memory segment size
> > SHMADD 8192 # Size of new shared memory segments
> > (Kbytes)
> > SHMTOTAL 0 # Total shared memory (Kbytes).
> > 0=>unlimited
> > CKPTINTVL 300 # Check point interval (in sec)
> > LRUS 8 # Number of LRU queues
> > LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning limit
> > LRU_MIN_DIRTY 0 # LRU percent dirty end cleaning limit
> > LTXHWM 50 # Long transact