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

# 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
(Kbytes)
CDR_LOGDELTA 30 # % of log space allowed in queue memory
CDR_NUMCONNECT 16 # Expected connections per server
CDR_NIFRETRY 300 # Connection retry (seconds)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9
max)

# Backup/Restore variables
BAR_ACT_LOG C:\informix\bar_paxys.log #Path of log file for onbar.exe
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
BAR_BSALIB_PATH C:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL

RESTARTABLE_RESTORE OFF #To support restartable restore..values on/off

# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

# Read Ahead Variables
RA_PAGES 32 # Number of pages to attempt to read ahead
RA_THRESHOLD 24 # Number of pages left before next group

# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of
dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables
etc.
# If specified it must be a colon separated list of dbspaces that
exist
# when the Dynamic Server 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 tempdbs # 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 Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR \tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
Server)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session

FILLFACTOR 90 # Fill factor for building indexes

# method for Dynamic Server to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES 32 # Maximum number of decision support queries
DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP # List of dbspaces to skip

# 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 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES 1

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
>
> # 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
> (Kbytes)
> CDR_LOGDELTA 30 # % of log space allowed in queue memory
> CDR_NUMCONNECT 16 # Expected connections per server
> CDR_NIFRETRY 300 # Connection retry (seconds)
> CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9
> max)
>
> # Backup/Restore variables
> BAR_ACT_LOG C:\informix\bar_paxys.log #Path of log file for onbar.exe
> BAR_MAX_BACKUP 0
> BAR_RETRY 1
> BAR_NB_XPORT_COUNT 10
> BAR_XFER_BUF_SIZE 15
> BAR_BSALIB_PATH C:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL
>
> RESTARTABLE_RESTORE OFF #To support restartable restore..values on/off
>
> # Informix Storage Manager variables
> ISM_DATA_POOL ISMData
> ISM_LOG_POOL ISMLogs
>
> # Read Ahead Variables
> RA_PAGES 32 # Number of pages to attempt to read ahead
> RA_THRESHOLD 24 # Number of pages left before next group
>
> # DBSPACETEMP:
> # Dynamic Server equivalent of DBTEMP for SE. This is the list of
> dbspaces
> # that the Dynamic Server SQL Engine will use to create temp tables
> etc.
> # If specified it must be a colon separated list of dbspaces that
> exist
> # when the Dynamic Server 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 tempdbs # 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 Dynamic Server operations.
> # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
>
> DUMPDIR \tmp # Preserve diagnostics in this directory
> DUMPSHMEM 1 # Dump a copy of shared memory
> DUMPGCORE 0 # Dump a core image using 'gcore'
> DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
> Server)
> DUMPCNT 1 # Number of shared memory or gcore dumps for
> # a single user's session
>
> FILLFACTOR 90 # Fill factor for building indexes
>
> # method for Dynamic Server to use when determining current time
> USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
>
> # Parallel Database Queries (pdq)
> MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
> DS_MAX_QUERIES 32 # Maximum number of decision support queries
> DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
> DS_MAX_SCANS 1048576 # Maximum number of decision support scans
> DATASKIP # List of dbspaces to skip
>
> # 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 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
> 2 = WAIT
> LBU_PRESERVE 0 # Preserve last log for log backup
> OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
>
> # HETERO_COMMIT (Gateway participation in distributed transactions)
> # 1 => Heterogeneous Commit is enabled
> # 0 (or any other value) => Heterogeneous Commit is disabled
> HETERO_COMMIT 0
>
> # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
> OPT_GOAL -1
>
> # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
> DIRECTIVES 1

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 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
> > (Kbytes)
> > CDR_LOGDELTA 30 # % of log space allowed in queue memory
> > CDR_NUMCONNECT 16 # Expected connections per server
> > CDR_NIFRETRY 300 # Connection retry (seconds)
> > CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9
> > max)
> >
> > # Backup/Restore variables
> > BAR_ACT_LOG C:\informix\bar_paxys.log #Path of log file for onbar.exe
> > BAR_MAX_BACKUP 0
> > BAR_RETRY 1
> > BAR_NB_XPORT_COUNT 10
> > BAR_XFER_BUF_SIZE 15
> > BAR_BSALIB_PATH C:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL
> >
> > RESTARTABLE_RESTORE OFF #To support restartable restore..values on/off
> >
> > # Informix Storage Manager variables
> > ISM_DATA_POOL ISMData
> > ISM_LOG_POOL ISMLogs
> >
> > # Read Ahead Variables
> > RA_PAGES 32 # Number of pages to attempt to read ahead
> > RA_THRESHOLD 24 # Number of pages left before next group
> >
> > # DBSPACETEMP:
> > # Dynamic Server equivalent of DBTEMP for SE. This is the list of
> > dbspaces
> > # that the Dynamic Server SQL Engine will use to create temp tables
> > etc.
> > # If specified it must be a colon separated list of dbspaces that
> > exist
> > # when the Dynamic Server 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 tempdbs # 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 Dynamic Server operations.
> > # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
> >
> > DUMPDIR \tmp # Preserve diagnostics in this directory
> > DUMPSHMEM 1 # Dump a copy of shared memory
> > DUMPGCORE 0 # Dump a core image using 'gcore'
> > DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
> > Server)
> > DUMPCNT 1 # Number of shared memory or gcore dumps for
> > # a single user's session
> >
> > FILLFACTOR 90 # Fill factor for building indexes
> >
> > # method for Dynamic Server to use when determining current time
> > USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
> >
> > # Parallel Database Queries (pdq)
> > MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
> > DS_MAX_QUERIES 32 # Maximum number of decision support queries
> > DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
> > DS_MAX_SCANS 1048576 # Maximum number of decision support scans
> > DATASKIP # List of dbspaces to skip
> >
> > # 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 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT,
> > 2 = WAIT
> > LBU_PRESERVE 0 # Preserve last log for log backup
> > OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
> >
> > # HETERO_COMMIT (Gateway participation in distributed transactions)
> > # 1 => Heterogeneous Commit is enabled
> > # 0 (or any other value) => Heterogeneous Commit is disabled
> > HETERO_COMMIT 0
> >
> > # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
> > OPT_GOAL -1
> >
> > # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
> > DIRECTIVES 1